Using COUNTIFS with CONTAINS
I have a contact column where some rows have more than one person assigned to a task. I want to count the number of tasks assigned to any given individual. This is the formula that I have created to do this:
=COUNTIF(CONTAINS("Bernie Sanders", [Assigned]:[Assigned]), "True")
The return value that I get is "0," which is not correct.
Is there another formula that I can try?
Help Article Resources
Check out the Formula Handbook template!