Determining if all check boxes are checked.

Options

How do you write a function to see if all boxes are checked on a row with multiple checkboxes?

I tried using the SUMIF(Check_Box_1@Row = 1) and attempted to use a total number of checks to evaluate, but it does not like that. I tried using IF((checkbox=1 AND Checkbox2=1),"true","false)

But that concept did not work either.

Tags:

Answers

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

    Hi @rwcanary99

    I hope you're well and safe!

    You'd use something like this.

    =IF(COUNTIFS(ColumnNameA@row:ColumnNameE@row, <>"") = 9, 1)
    

    Did that work/help?

    I hope that helps!

    Have a fantastic week & Happy Holidays!

    Best,

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

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    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.

  • rwcanary99
    Options

    Oopps I spoke too soon.

    Spoke too soon.

    It didn't work; it gave a "1," regardless of whether the box was checked.


    My solution is rather wordy:

    =IF(AND(

    OR([In Place]@row = 1, [In Place]@row = "NA"), 

    OR([CNTL Conduit]@row = 1, [CNTL Conduit]@row ="NA"),

    OR([CNTL Bushing]@row = 1, [CNTL Bushing]@row ="NA"),

    OR([CNTL Wire Pulled]@row = 1, [CNTL Wire Pulled]@row ="NA"),

    OR([CNTL Wire Terminated]@row = 1, [CNTL Wire Terminated]@row ="NA"),

    OR([CNTL Wire Labels]@row = 1, [CNTL Wire Labels]@row ="NA"),

    OR([ENET Conduit]@row = 1, [ENET Conduit]@row ="NA"),

    OR([ENET Bushing]@row = 1, [ENET Bushing]@row ="NA"),

    OR([ENET Pulled]@row = 1, [ENET Pulled]@row ="NA"),

    OR([ENET Terminated]@row = 1,[ENET Terminated]@row ="NA"),

    OR([ENET Label]@row = 1, [ENET Label]@row ="NA"),

    OR([PWR Conduit]@row = 1, [PWR Conduit]@row ="NA"),

    OR([PWR Bushing]@row = 1, [PWR Bushing]@row ="NA"),

    OR([PWR Wire Pulled]@row = 1, [PWR Wire Pulled]@row ="NA"),

    OR([PWR Terminated]@row = 1, [PWR Terminated]@row ="NA"),

    OR([PWR Labeled]@row = 1, [PWR Labeled]@row ="NA")

    )

    ,"Comp", "InComp"

    )

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

    @rwcanary99

    Happy to help!

    Try this.

    =IF(COUNTIFS([In Place]@row:[PWR Labeled]@row, <>"") = 16, 1)

    Did that work?

    Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    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!