Counting nonchecked checkboxes

Stacy M
✭✭✭
I have read a few forums and cannot get the right formula to work to count the number of unchecked boxes in a column that has checkboxes and "-" (for non-applicable). I can count checked boxes and when I try to count unchecked it counts the "-" fields, too.
=COUNTIF(ISBOOLEAN(1), "Cell contains a boolean value", "cell doesn't contain a boolean value")
Help, please?
Answers
-
SO using the sheet summary I created a field to add the following formula. However you could effectively add it to any cell in the sheet itself.
=COUNTIF([Column5]1:[Column5]15, <>1)
Column5 being the checkbox columns
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 146 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!