Timestamp - Record Date & Time in a Field
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
Best Answers
-
Hi Werner,
Yes, there is. Take a look at the method I developed in my post here.
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!
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.
-
Happy to help!
The Time Feature is in the works, so hopefully, soon it will work with fewer workarounds.
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.
Answers
-
Hi Werner,
Yes, there is. Take a look at the method I developed in my post here.
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!
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.
-
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'.
-
Happy to help!
The Time Feature is in the works, so hopefully, soon it will work with fewer workarounds.
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.
-
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!
-
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!
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.
-
-
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 @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
-
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:
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!
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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives