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.

Paul Newcome

Try inserting a date type column and then using a Record A Date automation triggered for when the status column changes to complete.

Abbie G

@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.

Paul Newcome

For cells that have already been changed, you will need to manually update those unfortunately.