COUNTIF Multiple Select Row

Mike Buckiewicz

I am trying to count all of the instances One Value is showing up in the assigned row even if two people are assigned to the same row. This is the equation I came up with but I keep getting zero even though there is actually one with that value combined with another value. What am I doing wrong?

=COUNTIFS({Project Oversight Range 5}, (CONTAINS("Mike Buckiewicz", @cell)))

A variation of this equation worked to count if there was one selection only in the column but is not calculating when there are multiple.

Please help!

Charlotte Loison-Jimenez

You may want to try the HAS function instead of CONTAINS. It should work with multi-select dropdown and multi-contact columns. Maybe something like:

=COUNTIFS({Project Oversight Range 5}, (HAS(@cell, "Mike Buckiewicz"))

https://help.smartsheet.com/function/has?_ga=2.1631090.234980845.1615223151-1183548819.1604442814

Charlotte Loison-Jimenez

You may want to try the HAS function instead of CONTAINS. It should work with multi-select dropdown and multi-contact columns. Maybe something like:

=COUNTIFS({Project Oversight Range 5}, (HAS(@cell, "Mike Buckiewicz"))

https://help.smartsheet.com/function/has?_ga=2.1631090.234980845.1615223151-1183548819.1604442814

Mike Buckiewicz

Yes this is it! I am still learning functions so will add HAS to my arsenal!