Assignee counts get skewed if multiple assignees

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.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!