SUMIFS Children Rows when Date is Filled Out

Options

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!


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!