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?
Best Answer
-
You can use the new Record Date automation for this - it works beautifully. https://help.smartsheet.com/articles/2481986-set-the-current-date-with-record-a-date-action?_ga=2.55574114.839407798.1617699064-1916390700.1572860636
Thanks,
Sravya
Answers
-
You can use the new Record Date automation for this - it works beautifully. https://help.smartsheet.com/articles/2481986-set-the-current-date-with-record-a-date-action?_ga=2.55574114.839407798.1617699064-1916390700.1572860636
Thanks,
Sravya
-
That is exactly what I needed. Completely forgot about automation. 🤦♀️
Help Article Resources
Categories
Check out the Formula Handbook template!