SUMIFS Children Rows when Date is Filled Out

Stephany Gonzales

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!

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!