Date and Timestamp Action in an Automation Workflow

Genevieve P.

Hey @JPeace

There currently isn't a log to see the exact changes made to a workflow, thank you for posting your suggestion!

I've moved it over into the Product Ideas topic so other members can vote on your feature request to show their support.

Cheers,

Genevieve

MennoStassen

Record the time an event occurred without needing to manually look at cell history. Need to be able to calculate the delta between when action A and Action B were so would like the option in automation to not just record a date but also the time.

MennoStassen

https://community.smartsheet.com/discussion/comment/433503#Comment_433503

Hi Andrée,

Thanks for your comment, a very crafty solution indeed that I am sure will work very well for a lot of users. I had thought of this as well for a small requirement I have, however I'm afraid that it doesn't scale very well to larger requirements. Our main requirement is to record the timings of 40+ columns in a sheet with 300+ columns already containing 20+ references to other sheets. If Smartsheet allowed a sub selection of columns to be copied instead of the whole row then this could work initially but with a whole row I will be maintaining countless extra sheets just for this purpose.

ERICSONM

As my line is in cleaning job it is required to have the accurate time capturing prior and end of the activity. If this will add in the feature of Smartsheet that will much be appreciated.

Andrée Starå

https://community.smartsheet.com/discussion/comment/441005#Comment_441005

Hi,

I hope you're well and safe!

This might help!

Please have a look at my post below with a method I developed.

More info: 

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

Would that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

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

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

Eric V.

This is urgent for me, I am using smartsheet for a few months and this is evolving really good, but this function is mandatory for my projects, like sharepoint lists has with NOW() default value

Adam Nay

When a condition is met place local time into a cell.

For example, when a checkbox is checked place the time into the cell next to it. I'm trying to make a sign-out based off a check box update that is emailed to the individual.

Andrée Starå

https://community.smartsheet.com/discussion/140764/timestamp-automation

Hi,

I hope you're well and safe!

Yes, that would be a great addition to Smartsheet.

In the meantime, please take a look at my post below, which outlines a method I have developed.

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

Would that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer! I appreciate it, thank you! 🙏