Count of cells in the last 60 days with a specific status

ebitterman ✭✭
edited 11/15/23 in Formulas and Functions

Hi. I've been at this for hours and can't get it. I'm trying to write a formula that will pull a total count of items with a specific status for the last 60 days. Both of the formulas below work separately, but when I try to link them with an AND, it breaks. How do I link these two statements?

=COUNTIFS([Enablement Date]:[Enablement Date], >=TODAY(-60), [Enablement Date]:[Enablement Date], <=TODAY(0))

=COUNTIFS(Status:Status, "enabled and monitoring")


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!