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
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.6K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 301 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!