Multiple Countifs Using Symbols

Options
SS_user10294507
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.

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!