How to Sum up Children Rows when another Column is Checked?


Hello all!

I have been searching and trying for an answer most of the afternoon now, with no success. I have a budget sheet I am working on that needs to sum up the children Amount rows in a month when a checkbox in the Reflected in Account checkbox is checked.

So far I have been trying this formula:

=SUMIFS(CHILDREN([column name to sum]:[column name to sum]), CHILDREN([checkbox column]:[checkbox column]), 1)

Tried several variations to no success. Anyone know why?

Thanks for any help!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!