Trying to use COUNTIFS with checkboxs

I have been trying to build this from the ground up to try and figure out what I am doing wrong. This seems like it should be easy, but the formula returns "Unparsable".

My formula is: =COUNTIFS([Task Name]:[Task Name], "SMB", [Done:Done], 1)

In english, this should mean if a task name is equal to SMB and the done checkbox is checked, please count.

If I do a single action, it works just fine:

=COUNTIF([Task Name]:[Task Name], "SMB")

Please help me!

Best Answer


  • Deanna Vandermeer
    Deanna Vandermeer Overachievers Alumni
    Answer ✓

    Try your formula this way ...

    =COUNTIFS([Task Name]:[Task Name], "SMB", Done:Done, 1)+""

    Let me know if this works for you.

    Smartsheet Overachievers Alumni

  • First and foremost, thank you so much for replying so quickly!!!

    Well, that got rid of the "Unparsable", but the answer is incorrect. What exactly does the +"" indicate?

  • Actually, that did work, I had a typo! Thank you so much, but was does the +"" add to this?

  • Deanna Vandermeer
    Deanna Vandermeer Overachievers Alumni

    I am so happy that worked for you. Checkboxes have an expected value of 0 or 1, but by adding the +"" to the end of the formula you are ensuring that it will show the result. In this case you are asking for it to return a count of all the checkmarks (the 1s in this case). I hope this makes sense and again, I am happy it worked for you. Please feel free to reach out anytime you need help, I love helping.

    Smartsheet Overachievers Alumni

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!