COUNTIF with simple criteria, but not working

edited 07/02/24 in Formulas and Functions

I am attempting to chage a COUNT fx to a COUNTIF with 1 criteria, but I can't seem to get it right.

Using a parent row, I am wanting it to count descendants if the current proficiency is not mastered, so that the number will update when proficiency is changed

This is the equation I used:

=COUNTIF([DESCENDANTS]:[Current Proficiency],<>"Mastered") + "skills"

It is providing an unparseable error.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!