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:

Best Answer

  • Genevieve P.
    Genevieve P. Employee
    Answer ✓
    Options

    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

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!