Date and Timestamp Action in an Automation Workflow

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!