I have a column set as Contact List and the Allow Multiple Contacts per Cell field is checked. I am using COUNTIF statements to count how many people are assigned to the tasks for a dashboard.
I am using the formula: =COUNTIF({Project List Range 3}, Assigned1)
Where Project List Range 3 is the Column in my master sheet that is the Contact List Field with assigned project members and Assigned1 is the name of an individual.
If the individual I am searching for is the only name in the field, it gets counted correctly. If there are multiple people assigned in the field, it does not count any of the names.