Looking to create a formula to count number of tasks
On the "Corporate Legal" row the formula in the "0 of 8" is the following:
=COUNTIF(CHILDREN(), 1) + " of " + COUNT(CHILDREN())
I want to create a Parent Count for all tasks. There are other sections with the same setup. I want the parent section (the cell with a blue border) to count all number of tasks.
So if I have "0 of 8" and "5 of 10", the parent total shall show "5 of 18".
Please help, thank you!
Help Article Resources
Check out the Formula Handbook template!