Date Stamp

Dylan Dawson

Hello @Andrée Starå , I also have a need where I'd like to have a date stamp when a task is marked done. I agree with @Gina Adrien in that this should be a common automation for SS. Many of us would like/need the ability to go back to see when a task was completed. Not having a date stamp requires a new field and a manual entry.

Andrée Starå

Hi @Dylan Dawson & @Gina Adrien

Have a look at my post here.

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

TF Assist

I know Excel allows the NOW() function and it can be done with a circular formula forcing the date stamp to remain unchanged once it's entered. If Smartsheet can allow the same formula to exist, this problem is easily solvable. I don't think this function is available at present but please let me know if it can be turned on via settings.

Andrée Starå

Hi @TF Assist

There is a date lock feature or similar coming soon.

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Bee-Eng Ang

Hi Andree,

Is there any further update about the "date lock" feature ? When can we start using it ?

Thanks,

Bee Eng

Andrée Starå

Hi @Bee-Eng Ang

No news yet, but I think it will be released soon.

I hope that helps!

Have a fantastic week & Happy Holidays!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Mike Wilday

You can now set a timestamp date based on another cell change using an automation workflow!

https://help.smartsheet.com/articles/2481986-set-the-current-date-with-record-a-date-action?_ga=2.79950226.443393604.1609776795-1074882870.1602114816