Formula for Not In the Last (x) days

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

Hello,

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!

Regards,

Hande Makam

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!