Capture Date and Time when column is changed


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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!