Timestamp - Record Date & Time in a Field

Werner Gerstacker

Hi there,

I want to set up a workflow with multiple approval steps and record e.g. when each step was approved; is there a way to push the 'current' date and time - as a fixed value, not as =TODAY() - into a cell ?

The modified date/time only catches the last modification of the whole line, so that's not going to work for my purpose.

I know that the 'Activity Log' as well as the 'Cell History' both hold these values for each cell, but is there a way to extract them in case pushing the value is not possible?

Thanks!

-Werner

Andrée Starå

Hi Werner,

Yes, there is. Take a look at the method I developed in 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!

Andrée Starå

@Werner Gerstacker

Happy to help!

The Time Feature is in the works, so hopefully, soon it will work with fewer workarounds.

Andrée Starå

Hi Werner,

Yes, there is. Take a look at the method I developed in 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!

Werner Gerstacker

Thanks @Andrée Starå ,

I've used this workaround before - but man, what a gigantic overhead this is.

For information that

• could just be a simple value-push or
• reusing a value that already stored in the system, maybe even twice (including the information who made the change).

We Germans call that 'von hinten durch die Brust ins Auge'.

Andrée Starå

@Werner Gerstacker

Happy to help!

The Time Feature is in the works, so hopefully, soon it will work with fewer workarounds.

Abnoos Moslehi

@Andrée Starå

Hi Andree,

I am also looking for a way that I can pull the cell history (=timestamp) and represent it in a different cell. In other words, I would like to capture what day and what time my team has performed an action in the each cell.

Is your workaround the way to pull this info up?

Thank you!

Andrée Starå

Hi @Abnoos Moslehi

Yes, it would store when something happened according to your need.

Make sense?

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!

Abnoos Moslehi

@Andrée Starå

That'd be great. I have sent you an email for details.

Thank you!

Andrée Starå

@Abnoos Moslehi

Happy to help!

I just shared it with you!

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

Cole Lusty

Hi @Mike Wilday / @Andrée Starå ,

I am looking for the same granularity that Abnoos requested a few messages back. Is there an option to have a timestamp recorded(same format as the system columns) in the "Record Date" workflow? I would like to capture what day and what time my team has performed an action in order to analyze the team's response time within a single day.

Thanks,

Cole

Andrée Starå

Hi @Cole Lusty

If you don't want to use the Smartsheet API or a 3rd party solution, your best option would probably be my method described below.

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 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!