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



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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!