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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions