Modified =SUM(CHILDREN()) Formula needed

Sylvia Kay

Dear All,

I am struggling to modify this formula: =SUM(CHILDREN(Points@row))

Working in agile development, my "Points" column contains development points needed to complete a task. Overall I have 4 hierarchy levels: Task, User Story, Epic, Initiative. I would like to display

• the sum of task points on the User Story line
• the sum of User Story points on the Epic line
• the sum of Epic points on the Initiative line

How could I accomplish that?

I do have a "Helper Column Ancestors" that has a number associated to the hierarchy: Initiative = 0, Epic = 1, User Story = 2, Task = 3.

Thank you for your support!

Paul Newcome

Are you able to provide a screenshot for reference?