sumif with children and checkboxes

edited 12/09/19

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

• The ultimate goal is that I can prepare a quote sheet for a client with all their options then we can eliminate options to help the budget and our grand total will show the revised numbers, with the check boxes (or unchecked boxes) showing what we've cut to get there)

• ✭✭✭✭✭✭
edited 01/26/18

Hi Danny,

Here are the formulas so that you can easily copy them.

=SUMIF(CHILDREN(Include1); "1"; (CHILDREN(Estimate1)))

=SUMIF(CHILDREN(Include2); "1"; (CHILDREN(Estimate2)))

I hope this helps you!

Have a fantastic weekend!

Best,

Andrée Starå - Workflow Consultant / Get Done

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Awesome!  Thank you so much - I knew I was close

In my case for the first line I modified the formula to:

=SUMIF(CHILDREN(Include10), "1", (CHILDREN(Estimate10)))

With the number 10 indicating what line the parent was on (just for reference to anyone else who stumbles upon this.

Thanks again!

• ✭✭✭✭✭✭

Happy to help and your welcome!

Best,

Andrée

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!