sum the count of Children to a parent row

Lisa_Doris

I have 4 PM's and I want to see the # of jobs they are assigned with the parent row showing the total # of Jobs of all PM's. I have no problem with the count formula for each PM, but I can't figure out the formula for the parent row.

For example

Parent Row: Total: 16 - what is the formula that would give me the Total of 16?

Child rows:

Gregg(7) ="Gregg(" + COUNT(CHILDREN()) + ")"

Sam(1) ="Sam(" + COUNT(CHILDREN()) + ")"

HIllary(3) ="HIllary(" + COUNT(CHILDREN()) + ")"

TBD(5) ="TBD(" + COUNT(CHILDREN()) + ")"

Andrée Starå

Hi @Lisa_Doris

I hope you're well and safe!

Try something like this.

="Pre Construction (" + (COUNT(DESCENDANTS()) - 4 + ")")

Did that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Lisa_Doris

@Andrée Starå Thanks. Almost works but not quite. The formula brings calculates it at 32 not 16.

It must be counting the sums and and the children under it

Andrée Starå

@Lisa_Doris

Happy to help!

I'd be happy to take a quick look.

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some more screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

Lisa_Doris

@Andrée Starå Thanks Andree, I made a copy and deleted sensitive data to give you an idea of what I am working on.

Andrée Starå

@Lisa_Doris

You're more than welcome!

I've updated the formula. Did it work as expected?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!