CountIf for check boxes

BESP10
BESP10 ✭✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

Good afternoon, 

 

Can you do a Countif formula for a column that has checkboxes.....so that you can count how many rows have the check box?

 

Thanks

 

 

«1

Comments

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    Yes, this is totally possible. The following formula will count all checked checkboxes. Just replace the checkbox column name in the formula with the name of yours.

    =Countifs([Checkbox Column Name]:[Checkbox Column Name], =1)

     

  • Debbie Sawyer
    Debbie Sawyer ✭✭✭✭✭

    That will work, but to be honest you only need =COUNTIF([checkbox column]:[checkbox column],1)

    You don't need the S on =COUNTIF and you dont need the = on the criteria

    But it will still work with them smiley

    Kind regards

    ​Debbie Sawyer Consultant & Training Manager

     

     

    Smarter Processes mean happy people in successful businesses

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    While true, I make it a practice to use Countifs because there are commonly additional requirements that are required to add to countifs and it makes it very easy to add another range and condition if needed. 

  • BESP10
    BESP10 ✭✭✭✭✭✭

    Thank you 

     

    They both work!

    yes

     

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    Glad we could be of help! Enjoy! 

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    I have gotten myself into the habit of using COUNTIFS and SUMIFS as well. It's just easier to amend later on. When I used COUNTIF, I would add on some criteria without remembering the S at the end which would of course throw an error. I would then typically beat my head against a wall for days trying to figure out what is wrong and finding some complex workaround only to realize days (an a headache) later that it was just the S missing...

    thinkspi.com

  • Debbie Sawyer
    Debbie Sawyer ✭✭✭✭✭

    Hi guys

    In reading both your comments I have realised that it is a great idea!  I'm a stickler for following rules and I had never considered using a multiple conditon formula for a single condition! What am I like!?  I think, like you, I might change my habit here :)

    Sorry if I caused any offence, being new to the community I am learning what is and isn't acceptable!

    Have a good day!

    Kind regards

    Debbie

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    Welcome aboard! yes 

    No offense taken on my side! Just stating some best practices I've developed along the way! 

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Ditto, Debbie. winkyes

    thinkspi.com

  • Paulina Guerrero
    Paulina Guerrero ✭✭✭✭✭

    Ive followed the Countifs scenario shown, but I'm still getting #BOOLEAN EXPECTED error. any thoughts?

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Paulina Guerrero

    Can you copy/paste the exact formula you are using and describe your scenario a little further? What is it that you are counting?

    Keep in mind that a COUNT formula will return a number, so it's best placed in a Text/Number type of column. This error usually means the formula is placed in a column that can't house that specific type of data (see here: Formula Error Messages)

    If you're placing the formula in a checkbox type of column, these can house text or check boxes. You'll want to translate the numerical value coming from the formula into text by adding + "" to the end of the formula, like so:

    =Countifs([Checkbox Column Name]:[Checkbox Column Name], =1) + ""

    Let me know if this works for you!

    Cheers,

    Genevieve

  • Hi am followed the directions and I received BOOTLEAN EXPECTED error. I was reading that this error happens if the formula/text is placed in a checkbox cell. how do i bypass this?

  • boolean expected error*

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

    Hi @Sarah Loewenthal

    You'll need to add +"" at the end. It will show the number, but it will be formatted as text.

    Did that work/help?

    I hope that helps!

    Be safe and have a fantastic week!

    Best,

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

    Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. 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: [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.

  • Abe B.
    Abe B. ✭✭✭✭✭

    Hi everyone,

    None of the above formulas worked out for me/ my case for some reason. I kept trying and changing variables and values from my reference sheet, but still struggling count those checked boxes. Also, every time I select my checkbox column, it represents it by "Range 1" or "Range 2"!


    Regards,

Help Article Resources