sumif with children and checkboxes

01/25/18 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



I appreciate any help you can offer!

smartsheet.JPG

Comments

  • 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)

  • Andrée StaråAndrée Starå ✭✭✭✭✭
    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)))

    Please see attached link/screenshot.

    I hope this helps you!

    Have a fantastic weekend!

    Best,

    Andrée Starå - Workflow Consultant / Get Done

    CloudApp Annotation 2018-01-26 at 9.43.59 fm.png.png

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • 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!

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Happy to help and your welcome!

    Best,

    Andrée

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Sign In or Register to comment.