Auto date and time stamp
Best Answer
-
You can now set a timestamp date based on another cell change using an automation workflow!
Answers
-
Sorry Jonboy0766,
This is one of the most fundamental features you could imagine in a Project Management solution, but is missing from your toolkit in this instance. Smartsheet ignores time in any of the system time columns no matter what you do.
Well, technically the above is not really true. It worked at one time, but then they turned it off because they found a bug. And as we all know, if you find a bug in something, you should completely deprecate all features associated with it immediately and then sit on your hands for over 2 years trying to work out how to implement a fix.
Cheers,
Chris McKay
Down Under Smartsheet Support -
I heard this functionality is now possible, do you know if that's true and how to do it if so?
-
Hi,
You can see the history of every cell with the cell history function. Another option could be to use a third-party solution like Zapier or similar.
Would that work?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
You can now set a timestamp date based on another cell change using an automation workflow!
-
Hi,
This tool/template does not provide TIME stamp but only a DATE.
How can we record both DATE and TIME when a condition is satisfied?
-
Why is it named a "timestamp" if it is missing the time? Timestamping days only work only for some applications and it is not precise enough for many of today's applications. The default timestamps (like modified date, created date) record everything. Is it really not possible to use the same code?
-
try using the newly introduced time formula...
-
So now I am stuck the automation only being able to choose between Change Cell Value and Current Date Stamp.
I need both since that data from the cell can't be extracted!
-
Adding a comment to say this feature would be helpful to my organization as well!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives