nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Need help with using SUM/SUMIF function along with Hierarchy

NishaTKD

Could someone please help by pointing out what is wrong with this function? I would like row 1 to show the total of row 2 and row 7. (i.e. when the Hierarchy level is 1)

=SUMIF([PO Amount]1:[PO Amount]10, [Project Hierarchy]@row, 1)

Here is the screenshot of my Smartsheet data source

I have a function in row 2 and row 7 that works just fine. it is =SUM(CHILDREN([PO Amount]7:[PO Amount]9)).

Thanks in advance.

Find more posts tagged with

Accepted answers

Ameya Athalye

use =SUM(CHILDREN()) formula on parent row and it should show you the desired sums.

Mike TV

@NishaTKD

=SUMIF([PO Amount]1:[PO Amount]10, [Project Hierarchy]@row = 1)

Such a little thing. needs to be = 1 instead of , 1 at the end.

All comments

Ameya Athalye

use =SUM(CHILDREN()) formula on parent row and it should show you the desired sums.

Mike TV

@NishaTKD

=SUMIF([PO Amount]1:[PO Amount]10, [Project Hierarchy]@row = 1)

Such a little thing. needs to be = 1 instead of , 1 at the end.

NishaTKD

Thank you @Ameya Athalye. It worked! :-)

Ameya Athalye

Awesome!

NishaTKD

Thank you @Matt C. for pointing out the error :-) I corrected the function but got CIRCULAR REFERENCE error. Perhaps I had used other functions in the same row. However I was able to get to the desired state just by using =SUM(CHILDREN()).

Thank so much for prompt inputs!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.