Modified =SUM(CHILDREN()) Formula needed

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!

Find more posts tagged with

Sheets

Formulas

Accepted answers

All comments

Paul Newcome

Are you able to provide a screenshot for reference?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.