Multiple contacts in one cell count
I am looking to count a specific contact within a cell that has multiple contacts but I would also like to ensure the count is for a specific criteria. For example
Joe Smith and Jane Doe are in the same cell but I want to count how many times Joe smith appears in the smartsheet while also ensuring he is meeting an additional criteria in another column as "in progress".
I am trying countif function with a find function but am having no luck.
any assistance would be greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!