Finding the date that a cell changed value.


I wish to look at a status cell and work out whether it has changed in the last 7 days or not. I want to use this as part of a formula so I could say has status changed in the last 7 days yes or no and then be able to use that information with other info to generate reports so we can see where action is required.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!