Count the number of non blank child cells


The sheet contains the following hierarchy:

There are formulas (COUNT(CHILDREN())) in the blue cells of the Missing study column. I need to count the total number of white (child) cells. In this particular case [10] should appear.

What the formula should look like?

Thank you in advance!


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!