# COUNTIF = BOOLEAN EXPECTED

Options

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"?

Tags:

• Employee
Options

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) + ""

Cheers,

Genevieve

October 8 - 10, Seattle, WA | Register now

• ✭✭✭✭✭✭
Options

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.

Hope this helps

Stefan

Smartsheet Consulting, Solution Building, Training and Support.

Projects for Processes and for People.

• Options

hmm, I have the following

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

and I still get "#Boolean Expected"

• Employee
Options

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) + ""

Cheers,

Genevieve