COUNTIFS: Column Contains, Column with Checkbox

Hello formula experts,

I am trying to return a count of instances where the [Implemented] cell is checked and the [Goal Category] cell contains "Environment" as one of the choices.

This formula is returning #INVALID OPERATION

=COUNTIFS(Implemented:Implemented, 1, [Goal Category]:[Goal Category], CONTAINS("Environment"))

Thanks in advance for your help!


Best Answers

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    edited 02/10/21 Answer ✓

    Hi @Mary Ayers

    I hope you're well and safe!

    Try something like this.

    =COUNTIFS(Implemented:Implemented; 1; [Goal Category]:[Goal Category]; CONTAINS("Environment"; @cell))

    Depending on your country/region, you'll need to exchange the comma to a period.

    Did that work/help?

    I hope that helps!

    Be safe and have a fantastic week!


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: | | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    edited 02/10/21 Answer ✓

    Hi @Mary Ayers

    Hope you are fine, try to use the following formula

    =COUNTIFS(Implemented:Implemented, 1, [Goal Category]:[Goal Category], CONTAINS("Environment", @cell))

    PMP Certified

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  • Mary Ayers
    Mary Ayers ✭✭✭✭
    Answer ✓

    Thank you to both Andrée and Bassam!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!