Auto fill date column based on a status column

GGSF

I have a sheet with a restricted column called "Completion Date". The unrestricted column is called "Status" and users can change using a drop down to "Done". Is it possible to have the "Completion Date" column filled by the system based on when the user updated the "Status" column to "Done"?

Thanks!

Frank Geraci

Yes, you can create an automation to record a date in the "Completion Date" column when the "Status" column value changes to "Done".

https://help.smartsheet.com/articles/2481986-set-the-current-date-with-record-a-date-action

Frank Geraci

Yes, you can create an automation to record a date in the "Completion Date" column when the "Status" column value changes to "Done".

https://help.smartsheet.com/articles/2481986-set-the-current-date-with-record-a-date-action

GGSF

Thanks!