Capture Date and Time when column is changed

Mashael

Hello everyone!

I want to know if there is anyway to capture the date and time using if function, when a column value is changed to "Approved"

Let's say I have two columns as follows:

Status Time

Approved if ( [Status]@row = "Approved", Today() AND Time(), 0)

is it possible to achieve this in smartsheet?

Thanks !!

Paul Newcome

It is not possible that way.

You can use this method I developed to capture the date/timestamp and then use an INDEX/MATCH to bring it back to your working sheet.

=IFERROR(INDEX({Copy Sheet Modified Column}, MATCH(ID@row, {Copy Sheet ID Column}, 0)) + "", "")

https://community.smartsheet.com/discussion/63561/date-time-stamp-option

Andrée Starå

Hi @Mashael

I hope you're well and safe!

Unfortunately, it's not possible now, but it's an excellent idea!

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

Here's a possible workaround or workarounds

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 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, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!