Count children & grandchildren of multiple rows under main parent

mthasen
mthasen ✭✭
edited 12/09/19 in Formulas and Functions

I'm trying to count the grandchildren status of multiple parent rows, and show a summary under mainparent (binos/mgmt/dmi).

I'm using  fx="Complete (" + COUNTIF(CHILDREN(), "Complete") + "),In Progress (" + COUNTIF(CHILDREN(), "In Progress") + ") , Not Started(" + COUNTIF(CHILDREN(), "Not Started") + ")" to get the summary of the status for each parent (row19 and 22), and trying to sum them to display in row18.

Hope someone could help.

Thanks

Capture_SS.JPG

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!