COUNTIF = BOOLEAN EXPECTED
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"?
Best Answer

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) + ""
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8  10, Seattle, WA  Register now
Answers

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.
Hope this helps
Stefan
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.

hmm, I have the following
=COUNTIF([I will be there!]2:[I will be there!]46, =1
and I still get "#Boolean Expected"

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) + ""
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8  10, Seattle, WA  Register now 
Yes, that is what is going on. Thank you!
Help Article Resources
Categories
Check out the Formula Handbook template!