How do I automatically add today's date when something is marked "complete" in status?

I have been using the formula =IF(Status@row = "complete", TODAY()) to add the date into a "completion date" column.

I thought that it was working, but it updates the date every time I open the Smartsheet. I wanted it to just give the date when it was marked "complete" and then keep that date. Is that possible?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!