# Sum of Parent plus Children

edited 12/09/19

Is there a way to get the parent row to indluce sum of parent plus children? We use a JIRA connector, and the team bills hours to the parent or Epic, as well as the Stories and Tasks with that Epic Link. As another screwball, JIRA reports time in minutes, so I have to convert Time Spent to Actual Hours by dividing by 60, which should still work if I can get =SUM(Parent() + Children()) / 60 to work...Thanks!

Tags:

• ✭✭✭✭✭✭

Hi Jonathan,

Try something like this.

=SUM([Time Spent]@row) / 60 + SUM(CHILDREN([Time Spent]@row)) / 60

The same version but with the below changes for your and others convenience.

=SUM([Time Spent]@row) / 60 + SUM(CHILDREN([Time Spent]@row)) / 60

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

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.

• edited 07/29/19

Here is the formula I ultimately created and is now working as planned:

=SUM([Time Spent]X / 60) + SUM(DESCENDANTS())

The column header was Actual Hours, so we were already converting Descendant time from Time Spent into Actual Hours column.

Thanks again for your response! JB

• ✭✭✭✭✭✭

Happy to help!

I forgot about the new DESCENDANTS function.

Nicely done!

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.

• ✭✭✭✭
edited 10/21/19

what exactly does "Descendent" mean?

Im working with Stories and Sub-tasks in Jira. Is it referring to this?

We enter time on each sub-task and I need to show the total time on a report for the parent story.

• ✭✭✭✭✭✭

Hi Pam,

I hope that helps!

Best,

Andrée

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!