Is there a clever way to make a row modified timestamp? This is so I can sort a list by date modified. The onEdit trigger doesn’t work since Glide updates the sheet with a script/api. Thanks in advance!

This is what I ended up using, which has the added benefit of working on all of the sheets, because it only looks for a column with “Modified Date” in the first row (also, it won’t modify the first row): function onChange(e) { const sheet = SpreadsheetApp.getActiveSheet() const rowIndex = (func…

Row Modified timestamp

Ask for Help

mthakershi July 28, 2020, 4:34am 2

Something like this.

1 Like

Topic		Replies	Views
Get Last Modified Date When Cell is changed Ask for Help	4	1845	September 2, 2020
Trying to create a function that returns a last updated date when a cell is updated in google sheets Ask for Help	3	463	October 19, 2020
Time stamp update Ask for Help	84	7234	August 17, 2022
Record creation date / modification date of an item Ask for Help	23	2883	January 17, 2024
Last Update Date/Time whenever a cell/row is changed in Tables (Glide/GS) Ask for Help	13	1552	November 14, 2021

Row Modified timestamp

Related topics