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.

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @MattW PDC

    I'm glad you were able to figure this out! Yes, 1 represents "checked" in a formula and 0 represents "un-checked". You can also use true and false, but I personally prefer 1 and 0.

    Cheers,

    Genevieve

  • 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)

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Susan van Niekerk

    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!