count check box

=COUNTIFS({MASTER - Material Requisition & PO Range 3}, "true", {MASTER - Material Requisition & PO Range 2}, [Assigned to]@row)

What am I doing wrong? I want to count the cell if the cell is checked

Answers

  • Garrett Henke
    Garrett Henke ✭✭✭✭✭

    When counting checkboxes I always use 1 if I want to count checked and 0 if I want to count unchecked. I do this because 1 = True and 0 = False when it comes to boolean values. You can use True or False without quotations which is the exact same as 1 or 0. But when you use "true" the formula is looking for a string value of true and not the checkbox.

    There are 2 things you can do:

    1) =COUNTIFS({MASTER - Material Requisition & PO Range 3}, True, {MASTER - Material Requisition & PO Range 2}, [Assigned to]@row)

    2) =COUNTIFS({MASTER - Material Requisition & PO Range 3}, 1, {MASTER - Material Requisition & PO Range 2}, [Assigned to]@row)


    Here are screenshots:

    As you can see in the "true" example the formula is looking for the string value true

  • Rodrigo Blotte
    Rodrigo Blotte ✭✭✭✭

    Garrett,

    What type of formula are you using to instruct Smartsheet to recognize the checkboxes as 1 or 0? I understand the reasoning behind your approach for the counting and I want to follow it but I am unsure on how to do the setup in which the checkbox can be recognized as 1's and 0's so then I can follow your proposed formula.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!