Multiple Countifs Using Symbols

SS_user10294507 ✭✭✭
edited 11/08/22 in Formulas and Functions

I am not an advanced formula user. I want to find the count of records that have multiple criteria. The formula I'm using now returns a value of 3, but should be 9.

=COUNTIFS({Action Item Status}, "Canceled", {Action Item Due Date}, <DATE(2022, 12, 1), {AI Priority}, <>"Low")

I have a symbol column in my Action Item page that uses the 3 priorities (High, Medium, Low). Of the 9 records, three priorities are "Medium" and the remaining 6 are blank "". I want the formula to return null (""), "Medium", and "High" counts summed together (9). Basically, I want to exclude records with "Low" priority, but using my formula it returns a value of 3, seemingly disregarding blank priority values.

Thanks in advance for any assistance you can provide in cleaning up my formula.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!