I need help with my COUNTIFS formula

Options

I am trying to get a count of rows on a sheet that are not Completed AND are not a Sub-Task. My formula works on a syntax level, but it is not coming back with the right answer. Can someone help me figure out what I'm doing wrong?


=COUNTIFS({PMO Support Tasks Range 5}, "<>*Completed*", {PMO Support Tasks Range 1}, "<>*Sub-Task")


@Paul Newcome tagging you because you are a whiz with formulas!

Kelly L. Gabel

Owner/Founder

Tech-Savvy Academy

kellylgabel.com

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!