Auto fill date column based on a status column


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"?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!