Assignee counts get skewed if multiple assignees

Greg Zinn

If my Assignee columns has multiple people in it and data in the row gets skipped in this count. 

this is the old formula:

=COUNTIFS({Assignee}, Team3, {Status}, "In Queue")

Anyone out there have any suggestions.. I have been trying this:

=COUNTIFS({Assignee}, CONTAINS("John Doe"@cell), {Status}, "In Queue"))

 Even if the Assignee column has multiple people I want it to count the row for the person.

Thanks!

Adrian Backus

Hi Zinn,

Try using the HAS function in place of the CONTAINS function.

Proposed Formula:

=COUNTIFS({Assignee}, HAS(@cell, "John Doe"), {Status}, "In Queue")