how to record a timestamp based on a condition

Nero Naidoo · 07/19/21

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

Andrée Starå · 07/19/21

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!

Nero Naidoo · 07/19/21

Awesome, that worked. thank you

Andrée Starå · 07/19/21