Sum of Parent plus Children

jonathan.beaty91616

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!

Andrée Starå

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

jonathan.beaty91616

Thanks for your response Andree!

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

Andrée Starå

Happy to help!

I forgot about the new DESCENDANTS function.

Nicely done!

Pamb10

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.

Andrée Starå

Hi Pam,

Here's some more information: https://help.smartsheet.com/function/descendants

I hope that helps!

Best,

Andrée