COUNTIF in Muti-Select Column

Options

Good morning, I am trying to count how many times a name appears in a multiselect column, the problem is that when there is more than one name in the column it will not count it. Here's my formula so far

=COUNTIFS({Construction Damage & Complaint Tracker Range 1}, "Gary"

Although Gary's name should count 5 times, it does not because there are other names in that column as well.

Any help would be appreciated!

Best Answer

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    edited 05/13/22 Answer ✓
    Options

    @britenour

    =COUNTIF({Construction Damage & Complaint Tracker Range 1}, HAS(@cell, "Gary"))

    However, HAS function needs to find an exact match. So as long as its just Gary and doesn't include a last name that should work.

    If it includes a last name you can use:

    =COUNTIF({Construction Damage & Complaint Tracker Range 1}, CONTAINS("Gary", @cell))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!