Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
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], <>"")
Answers
-
It looks like you did it correctly to me. Is it not giving you the results you're looking for?
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!