Counting # of tasks from a specific parent

RSP

Hi all,

I am trying to count the number of tasks in my plan underneath a specific heading. However, I am unsure how to do this for 1 parent heading and not all of them.

For example, I am looking to find the number of tasks under plan stage 2.

• Plan stage 1
• Plan stage 2
• Plan stage 3

I would use "=COUNT(CHILDREN([Task Name]@row))" in the plan and use a countif for anything that =0. However this would count everything for plan stage 1, 2, 3.

Thanks!

Paul Newcome

I would suggest a helper column (that can be hidden after setup) that has

=PARENT([Task Name]@row)

Then you would use a formula such as this to count the number of children for "Plan stage 2":

=COUNTIFS([Helper Column]:[Helper Column], @cell = "Plan stage 2")