Multiple contacts in one cell count

Adam Joe

Hello,

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.

Kelly Drake

Try COUNTIFS + CONTAINS.

= COUNTIFS([status range], "in progress", [Range of contact column], CONTAINS("Joe Smith", @cell)

Similar to the solutions here: https://community.smartsheet.com/discussion/64461/countifs-contains-function

Adam Joe

with respect to the @cell, I am referencing another sheet would this have any implications?

Also if I wanted to build in an additional layer around complexity would this be possible?