Capture Date and Time when column is changed

Options

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 !!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!