Time stamp

Erika Moreno

Hi: I am looking to see if the software is able to time stamp an item to keep a record of it. we would like to have a checklist and once a task is completed or changed. if there can be a timestamp on day/time in order to keep records for auditing purposes. 

 

is there such a thing? 

thank you. 

Erika 

Mike Wilday

Not at this time. This is a request that ALL OF US have asked for multiple times. But there is not an ability to do this at this time. Please submit a Product Enhancement Request to add your vote to this feature! 

Jim Hook

Every cell has a timestamp embedded in it that can be viewed by right clicking on the cell and selecting "view cell history". It shows the whole history of each cell and I use it for forensic purposes regularly. It's more useful to me than a single timestamp that just shows the most recent change date and time.

ron.zanetti53836

Hello. We have a question about the time stamping in the meta data fields of ‘view cell history’. What time zone is used in the time stamping? Is it always PST regardless of where in the world the User is?

Mike Wilday

Good question. @Shane Greenwood, can you respond to this question and let us know if the view history display is in our local time-zone or is displaying a different timezone?

Cecil

Please add my vote for this feature as well.  It is useful to have cell history time stamps, but that alone is not directly tied to a workflow action.  It is also not possible (at least without programming) to compare cell history timestamps for elapsed time (days/hrs/mins).  For the purpose of reporting metrics, being able to determine exactly when a specific workflow action was completed, AND being able to tell how long it took between that action and another time/date is critically needed. 

If this cannot be accomplished easily using sheet fields and formulas, it makes the utility of SmartSheet woefully lacking.

Thanks!

Antony Dowell

Hi, Completely agree with Cecil - this feature is definitely required on reportable fields. I appreciate you can see the history by going into each cell's history, but this does not help when trying to obtain metrics involving performance.

Please include my vote to add this functionality.

On a side note, a select-able variable on dashboards would be great too. I work within a manufacturing facility, who offer a dashboard to all customers, allowing them to check the progress of their orders. Having a dynamic field would be great for them tracking their orders (i.e. order number, part number etc.)

 

Many thanks - Look forward to feedback

Colin Entrekin

I have been asking for this for two years. 😠

Mike Wilday

@Colin Entrekin 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

Brian WDW

Is there a way that a "timestamp" can actually include "time"??

Andrée Starå

Hi @Brian WDW

I hope you're well and safe!

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

Best,

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

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