Can you use CountIF if there is more than one term in a cell?

I have a sheet that is updated from an export from another system. One of the fields in the other system is for category and can have more than one category selected. So when the data exports it appears in Smartsheet as "Category 1, Category 2" - separated by a comma.

I want to count all the rows with Category 1.

Is there a formula to do that?


  • Kelly Drake
    Kelly Drake Overachievers Alumni

    You'll want to use a CONTAINS or a FIND inside your COUNTIF.

    Something like this....

    =COUNTIF(Range:Range, FIND("Search Value", @cell) > 0)

    Kelly Drake (she/her/hers)

    STARBUCKS COFFEE COMPANY| business optimization product manager

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!