SUMIFS Children Rows when Date is Filled Out

Great Morning!

I am trying to do a formula so sum children rows with SUMIFS following this criteria =SUMIFS(CHILDREN([TOTAL OWE - LIVE]:[TOTAL OWE - LIVE]), CHILDREN([MUNIS APPROVAL LEVEL 5 DATE]:[MUNIS APPROVAL LEVEL 5 DATE]), ISDATE(@cell))

In other words, on the parent row named TOTAL PO LIQUIDATED I would like to get the total amount owe-live when the date on the field MUNIS APPROVAL LEVEL 5 DATE is filled out. I would like to copy this formula for all the vendors but when I apply the formula as is now, it's adding all the values in the column, even for different vendors.

Your help is greatly appreciated.

Thank you!

Find more posts tagged with

Accepted answers

All comments

David Joyeuse

Hi @Stephany Gonzales

This seems to be the same topic as:

https://community.smartsheet.com/discussion/71748/sumifs-isblank-not-is-blank-children-rows

So to make it short:

=SUMIFS(CHILDREN(), CHILDREN([MUNIS APPROVAL LEVEL 5 DATE]@row), ISDATE(@cell))

Hope it helped!

Stephany Gonzales

Hello David,

Thank you for your response. Your formula works perfectly for the column Total Owe-Live that adds up the children of the same column; however, the Total PO Liquidated is referring to the children rows at Total Owe-Live (different column). How should we formulate that function? (screenshot attached)

The parent Row Total Owe-Live has the following formula (when the date is blank): =SUMIFS(CHILDREN(), CHILDREN([MUNIS APPROVAL LEVEL 5 DATE]@row), ISBLANK(@cell))

Thank you in advance for your help!

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.