Sum of Parent plus Children

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!

SS Capture.PNG

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!