Formula for Not In the Last (x) days

Hande Makam
Hande Makam ✭✭
edited 12/15/22 in Formulas and Functions


We are using the Status/Latest Comment field in our request log source sheet along with a Status/Latest Comment Date field. This date field records the current date when a comment has been made.

Using a formula, how do I find the number of Status/Latest Comment fields in my source sheet that have not been updated in the last 7 days? Thank you so much!


Hande Makam

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!