Auto Populate "Date Completed" when Status changes to "Complete"

Options

Hello,

I am trying to auto populate the "Date Completed" field when the "Status" column changes to "Complete".

I tried =IF(Status@row = "Complete", TODAY(), "")

However, every time the SmartSheet opens, the date changes to "Today's Date". How can I lock the date in that column once the status changes to complete?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!