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!

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!