Is it possible to create a "last updated" field under Google Sheets?
I have a status column, where the status progresses something like:
New -> Pending -> Started -> Done
I would like to add a "status last changed on XXX" column, where XXX would be a timestamp for when the status was changed, so that then I can filter for example anything that hasn't changed status in over a week (or color-code it/etc.)
I know I can in theory look this up under the revision history, but that is quite a tedious work-around
I am looking for a way that if a single cell is modified, then another specific cell will be updated with the current timestamp