COUNTIF = BOOLEAN EXPECTED

nicole.turner

Hi

I want my smartsheet to count the number of checked boxes in a specific column. I have formulated: =COUNTIFS([Ceremony/Party]:[Ceremony/Party], 1). However, it is cominh up with "BOOLEAN EXPECTED"?

Genevieve P.

Hi @KHorlander

Your first formula is actually exactly correct! The error message has to do with where the formula is placed - I expect you're putting this in the same checkbox column, is that correct?

If so, the cell is expecting either a 1 (checked) or 0 (unchecked) so your count of 23 or 89 or whatever number is throwing the error.

You can add "" to the end of your formula to make the count text, which will then be able to show up in a checkbox cell... like so:

=COUNTIFS([Ceremony/Party]:[Ceremony/Party], 1) + ""

See: Formula Error Messages

Cheers,

Genevieve

Stefan

Hi @nicole.turner,

COUNTIFS expects an expression like "=1" after the comma.

By the way, COUNTIFS is provided for multiple criteria to be met. If you just look for "=1", then COUNTIF is enough.

https://help.smartsheet.com/function/countif

Hope this helps

Stefan

KHorlander

hmm, I have the following

=COUNTIF([I will be there!]2:[I will be there!]46, =1

and I still get "#Boolean Expected"

Genevieve P.

Hi @KHorlander

Your first formula is actually exactly correct! The error message has to do with where the formula is placed - I expect you're putting this in the same checkbox column, is that correct?

If so, the cell is expecting either a 1 (checked) or 0 (unchecked) so your count of 23 or 89 or whatever number is throwing the error.

You can add "" to the end of your formula to make the count text, which will then be able to show up in a checkbox cell... like so:

=COUNTIFS([Ceremony/Party]:[Ceremony/Party], 1) + ""

See: Formula Error Messages

Cheers,

Genevieve

KHorlander

Yes, that is what is going on. Thank you!