Formula to determine the date that another cell was updated

Andrea Mayer
Andrea Mayer ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions


Looking for some formula help. I am using the formula below and need to figure out how to display the date the Status cell was changed instead of updating to today's date.

=IF([Status]1 = "Completed", TODAY())

Thanks for your help!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!