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

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

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
Categories
Check out the Formula Handbook template!