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 '13 at 5:29
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.
Reference
Using Google Spreadsheets, you can use onEdit.
-
2