It was really in response to a question. Sadly, these videos don't have the same interest or views as others, but I know it's a useful trick to get those trackers working and looking great!
If you just need to check when a specific cell in a spreadsheet was last edited you can just right click the cell and select history and it will tell you all the edits and time of that cell.
Revision history is helpful, and what makes it all work. But this is a way of having these updates visually there as part of the file rather than manually checking :-)
Also, what if I want to check all the cells of a row to see if any of them were updated, and have that last modified date land in the same column every time?
Love how you are getting into app scripts!
It was really in response to a question. Sadly, these videos don't have the same interest or views as others, but I know it's a useful trick to get those trackers working and looking great!
If you just need to check when a specific cell in a spreadsheet was last edited you can just right click the cell and select history and it will tell you all the edits and time of that cell.
Revision history is helpful, and what makes it all work. But this is a way of having these updates visually there as part of the file rather than manually checking :-)
Also, what if I want to check all the cells of a row to see if any of them were updated, and have that last modified date land in the same column every time?
Are you able to also add a column next to the Last Edit, with the User who performed that last edit? Say it's a shared Google Sheet.