how to record a timestamp based on a condition
Hi, I have a process that needs to be reviewed by a certain time. the reviewer will tick the reviewed box once the work has been reviewed. I want to record the date with the time that was reviewed once the check box has been ticked. i see that smartsheet doesn't have this functionality, so i tried a workaround that someone suggested by created a sheet to copy the row once the checkbox has been ticked and using the system auto number date created function and then index matching back to the master sheet. for some reason, this only returns the date without the time. is there any way to resolve that?
this is the copied sheet with the date and time stamp
this is the formula I'm using to index match back to the master file
=INDEX({Date Reviewed}; MATCH([Unique reference]@row; {Unique reference}; 0))
the formula works but returns a value with date only, no time
Best Answers
-
Hi @Nero
I hope you're well and safe!
Add +"" after the formula to see the time as well.
Did 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 support the Community by marking it Insightful/Vote Up or/and as the accepted answer. 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.
-
Awesome, that worked. thank you
Answers
-
Hi @Nero
I hope you're well and safe!
Add +"" after the formula to see the time as well.
Did 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 support the Community by marking it Insightful/Vote Up or/and as the accepted answer. 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.
-
Awesome, that worked. thank you
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives