Function to retrieve count in a multi-select column

Marianne Pho

I am trying this as well and keep getting "Unparseable". The column I am using is the Assigned To multiselect contact column. The formula I use is: =COUNTIFS([Assigned To]:[Assigned To], FIND("John Doe", @cell) > 0))

Is there anything else I can try?

Paul Newcome

@Marianne Pho Try removing one of the closing parenthesis from the end.

=COUNTIFS([Assigned To]:[Assigned To], FIND("John Doe", @cell) > 0)