Contact List column allows multiple entries - using in formula
I am trying to obtain the number of tasks with a status of "Red" by assigned user. The author column only had one individual assigned and the formula
=COUNTIFS(Author:Author, ="Jane Doe", Status:Status, ="Red")
returned precisely what I needed. I'm trying to replicate the results for the contributors. However, in many instances, there is more than one contributor assigned in that column. How can I get it to count the row including "John Doe" if the cell includes both "John Doe" and "Susie Someone"?
Help Article Resources
Check out the Formula Handbook template!