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

Options

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!

Zayne

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!