Count # of Parent Rows in a Sheet

CLaughrey · 04/09/18

What formula can I use that simply counts the number of parent rows in a single sheet?

My scenario: Each parent row is a different customer. I want to know how many active customers a particular PM is working with and link that number to a metric widget on the PM's internal dashboard.

Mitch.Shaffer · 04/09/18

I would create a row at the top and make everything a child of that row (see screenshot). Then use the following formula:

="PM Name: " + COUNT(CHILDREN())

Count Parents.png

Diego Cardenas · 07/23/21

Hello @Mitch.Shaffer,

In the example above, it is possible to count the number of Task "12" in this example.

PM name: 12

Just making sure they are counting the Number of task at the lowest level or hierarchy and not considering the customers "4".

Beforehand thank you very much,

Diego Cárdenas

Count # of Parent Rows in a Sheet

Comments

Help Article Resources

Categories