# sum the count of Children to a parent row

Options
✭✭✭✭

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

• ✭✭✭✭✭✭
Options

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!

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭
Options

@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

• ✭✭✭✭✭✭
Options

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)

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

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!

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!