sumif with children and checkboxes

I'm trying to create a setup where I sum together only the children if another box for that row is checked.



I've come up with (see screenshot below as well):



=SUMIF(CHILDREN(Include),1,CHILDREN())

But despite trying different variations of the formula I get everything back as #UNPARSEABLE



I appreciate any help you can offer!

smartsheet.JPG

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!