How can you count someone assigned to a cell if there are multiple people assigned in the same cell

Evan Plante

Im using a metrics sheet to show home many people have RYGB symbols. However, there are some rows that have more that one person assigned to the task and it will not count their symbol if this is the case. Is there a formula that can count even if there is more than one person in the "ball in court" column?

Jeff Reisman

@Evan Plante

Try using HAS in place of CONTAINS:

HAS(@cell, "John LoVerde")

HAS will match complete individual values inside a multi-select cell.