Count of Children Incorrect

Smartsheet Community:

My Formula Is the Incorrect total number of Children. I am sure it is a Minor Tweak but I cannot seem to find where I need to correct my formula.

Current Formula:

="Site Execution: " + COUNTIF(CHILDREN([% Complete (Actual)]@row), 1) + " of " + ((COUNTIF(CHILDREN([% Complete (Actual)]@row), 1) + (COUNTIF(CHILDREN([% Complete (Actual)]@row), 0)) + " Completed "))

Results 21 Of 48 Completed

However the Total Number of Children is 52. Therefore, it should be 21 Of 48 Completed.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!