Counting nonchecked checkboxes


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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!