COUNTIFS and HAS formula not working

Jakearoni

I cant seem to get my formula to count the time a name appears correctly. The formula is returning a value of 1 when it should be 5. It seems to be due to the Project Leader column being multiselect as the person has four instances of being selected with other people and only once cell where she is the only one selected.

=COUNTIFS({Project Leader Column}, HAS(@cell, Name@row), {Project Phase Column}, "Ideation & Assessment (Define)")

Nic Larsen

Try using Contains instead:

=COUNTIFS({Project Leader Column}, CONTAINS(Name@row, @cell), {Project Phase Column}, "Ideation & Assessment (Define)")

Nic Larsen

Try using Contains instead:

=COUNTIFS({Project Leader Column}, CONTAINS(Name@row, @cell), {Project Phase Column}, "Ideation & Assessment (Define)")

Jakearoni

That worked perfectly! Thank you!!