How to countifs across a date range with a condition and a check box

Hi all, I'm trying to count how many boxes are checked based off a condition within a certain date range. I've tried the below formula but it's not working.

=COUNTIFS({Optom Resignations Range 1}, @cell = "NSW", {Optom Resignations Range 2}, @cell = 1, AND({Optom Resignations Range 3}, @cell >=DATE(2023,3,1), DATE(2024,2,28))))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!