Auto fill date column based on a status column

Options

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!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!