True count of Children(), not just non blanks

vanZylin ✭✭
edited 06/12/23 in Formulas and Functions

Doing project roll up and trying to use the formula below to roll up a complete status.

=IF(COUNTIF(CHILDREN(), "Complete") = COUNT(CHILDREN()), "Complete", "Not")

However, blank cells do not contribute to the COUNT(CHILDREN()), thus if there are three children and someone deletes all values in 3 cells or any non "Complete", then the formula returns "Complete" because all rows with values does in fact equal the count of children.

How can I return the count of children regardless of blank cells?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!