Countif function for unchecked box
Is there a way to run the countif function if a check box is unchecked? I see a command example for when it is checked, but I want to exclude any checked boxes as those would mess up my counts due to the negative value associate when it is checked.
Answers

Looks like I was able to reverse engineer this and determine that using a 0, instead of a 1 allowed the function to work as I intended it.

Hi @MattW PDC
I'm glad you were able to figure this out! Yes, 1 represents "checked" in a formula and 0 represents "unchecked". You can also use true and false, but I personally prefer 1 and 0.
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8  10, Seattle, WA  Register now 
Hi
I tried using the countif for unchecked but the amount coming back to me is wrong.
Have checked to source sheet to make sure
=COUNTIF({Reconcile 2}, false)

The first thing I'd check here is the {range} to make sure it's pointing at the correct checkbox column. You can also try using 0 instead of false to see if that helps, too:
=COUNTIF({Reconcile 2}, 0)
If you're still seeing an incorrect number, my next test would be to add a filter in your source sheet to compare the number of rows in the filter versus the value that the formula is bringing back. If none of this has helped, it would be useful to see a screen capture of your source sheet, but please block out sensitive data.
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8  10, Seattle, WA  Register now 
I have this same problem, and it's looking like the formula in the Sheet Summary is counting the empty rows that are at the bottom of the sheet as well. When I used the filters to see how many are unchecked, it's showing the correct number.

@Jayy S. You can subtract 10 from the final COUNTIFS or you can reference another field in the sheet that will have something in every row aside from those ten at the bottom.

That is absolutely ludicrous to have to create so many workaround when the formula should be counting only unchecked boxes. It's also ridiculous that 10 blank rows are automatically added and clogging up the view.

@Jayy S. There isn't the need for "so many" workarounds. It one or the other, and the one is as simple as subtracting 10. I'm also not sure how blank rows are clogging up the view when they are at the bottom of the sheet and blank. It is much less "clogging" than what you would find in programs such as Excel.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.4K Get Help
 325 Global Discussions
 183 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 127 Brandfolder
 154 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!