Count the number of non blank child cells

Hi!

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!

Tags:

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!