Sheet Summary Formula - (status type) due in next 7 days

AlixGustav
AlixGustav ✭✭
edited 02/02/24 in Formulas and Functions

I have a manually altered date column [Next BHL Follow Up Date]

and a status column with a few options such as "Give Reminder to Attend Appointment"

How do I get a sheet summary that tells me the number of Give Reminder to Attend Appointment s are dated for the next 7 days?


Thanks,

Alix

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!