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?
Help Article Resources
Check out the Formula Handbook template!