Trying to sum range of children based on checkboxes

tgattsh ✭✭✭✭✭
edited 06/22/22 in Formulas and Functions

Hi everyone! Hope someone can help.

I am trying to total children in a parent row based on the checkboxes @ row.

Been at this for hours and have tried many different things, the last was "=SUMIFS(CHILDREN([Number of Affected Meters]3:[Number of Affected Meters]4, CHILDREN([Sales or MTS Notified Customer]3:[Sales or MTS Notified Customer]4,1))"

Any help would be much appreciated. Thank you...

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!