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

Sabrina Petersen

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?

sravya.gupta127326

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

sravya.gupta127326

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

Sabrina Petersen

That is exactly what I needed. Completely forgot about automation. 🤦‍♀️