Count that excludes blanks


I have the formula below that works perfectly, but I want it to exclude anything in the column "Phase Gate Criteria Identifier" that is blank. Can anyone help add that in? thanks!!

=COUNTIFS([Stage-Gate Category]:[Stage-Gate Category], "Planning & Resourcing", Header:Header, 0, [Current Phase?]:[Current Phase?], 1, [Phase Gate Criteria Identifier]:[Phase Gate Criteria Identifier], <>"")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!