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	1864	September 2, 2020
Record creation date / modification date of an item Ask for Help	23	2909	January 17, 2024
Time stamp update Ask for Help	84	7268	August 17, 2022
Trigger script onEdit event from App Ask for Help	15	5233	January 17, 2024
Trying to create a function that returns a last updated date when a cell is updated in google sheets Ask for Help	3	496	October 19, 2020

Row Modified timestamp

Related topics