count check box

Samuel Dowdy Jr.

=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

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

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.