Count all of the Level 1 Parent rows in a SmartSheet

Paul Stubitsch

In the document's Summary Sheet, I want to count all of the Level 1 parent tasks in the Sheet itself. In the example above, the answer is 2.

Mathieu PERSICO

Hi Paul,

You can add a new column called "Counter" in which you are going to calculate the number of childrens that are included in each row. If the result is higher than 0, then the row is a parent.

=COUNT(CHILDREN([Dept Initiative Name]@row))

Afterwards, add an extra row at the top of your sheet to count the number of cells containing a result higher than 0.

=COUNTIFS(Counter:Counter, >0)

Hope this helps! Have a good day,

Mathieu | info@evolytion.com

Mathieu PERSICO

Hi Paul,

You can add a new column called "Counter" in which you are going to calculate the number of childrens that are included in each row. If the result is higher than 0, then the row is a parent.

=COUNT(CHILDREN([Dept Initiative Name]@row))

Afterwards, add an extra row at the top of your sheet to count the number of cells containing a result higher than 0.

=COUNTIFS(Counter:Counter, >0)

Hope this helps! Have a good day,

Mathieu | info@evolytion.com

Paul Stubitsch

That is AWESOME!

Much more elegant than a formatting a rule I was going to apply to the Task Name if I didn't get a better answer.

Thanks