Count # of Parent Rows in a Sheet

CLaughrey

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

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())

Diego Cardenas

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