Can I "count a specific person in an Assigned To column when there are multiple people in that cell?
I want to know how many tasks are assigned to a certain individual, but this individual is assigned to tasks that are also assigned to others as represented in the Assigned To column. The "Allow Multiple Contacts Per Cell" box checked. Is there a formula that will pull out only one of the names listed? i.e., 3 cells have my person listed; two of the 3 have another individual listed. I want the formula to state that my person has 3 tasks.