Is there a spreadsheet function that can watch a row and update a cell with the current date when any cell in that row changes? If not for the entire row then perhaps just watch a single cell?

  • Working single cell onEdit answer on the following Web Applications thread; could be modified to watch an entire row I would think: goo.gl/ps3ZI5
    – panhandel
    Nov 23, 2013 at 5:29

2 Answers 2


One way of doing it, would be to use the onEdit trigger. Unfortunately, that doesn't work. Besides that, you have to use extensive programming techniques to achieve your goal.

Issue Tracker

See the following feature request on the issue tracker: issue 200; onEdit: access original data.
If you vote, it might get introduced.



Using Google Spreadsheets, you can use onEdit.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.