On one of the columns, I can change the status to complete. When that cell is changed to complete,
Abbie G
✭
is there a way to record all the dates when the cells where changed to complete? Hopefully this makes sense.
Answers
-
Try inserting a date type column and then using a Record A Date automation triggered for when the status column changes to complete.
-
@Paul Newcome Thank you! Is it possible to get it for past cells that were changed to complete? I know I can get the data from cell history, but I'd like an entire column of it as well.
-
For cells that have already been changed, you will need to manually update those unfortunately.