Count children & grandchildren of multiple rows under main parent
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.
Help Article Resources
Check out the Formula Handbook template!