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

Jeff_Hager July 28, 2020, 4:57am 3

If you are using the built in edit function, you can use the date time special value.

3 Likes

Topic		Replies	Views
Get Last Modified Date When Cell is changed Ask for Help	4	1810	September 2, 2020
Trigger script onEdit event from App Ask for Help	15	5201	January 17, 2024
How to write google sheet script so only latest timestamped forms record if duplicate is the only record? Ask for Help	17	2241	October 9, 2021
Record creation date / modification date of an item Ask for Help	23	2836	January 17, 2024
Google Script: How to spot new sheet entry via form button if it's an EDIT event, not INSERT_ROW? Ask for Help	8	1144	April 16, 2020

Row Modified timestamp

Related topics