Trying to Count multiple text by referring from another sheet

PR_T

I want to count multiple values from a cells which are separated by ";" from a column.

Can it be achieved by COLLECT/FIND/COUNTIF ?

The following screen shots has the Info & expected output .

Any suggestions please.

 

Genevieve P.

The best way to do this would be to change your Country column into a multi-select column. This allows Smartsheet to read each country as an individual value, even when in the same cell. Then you can use a COUNTIF(HAS formula, like so:

=COUNTIF(Country:Country, HAS(@cell, [By Country]@row))

 

If your Country column is in another sheet, replace the Country:Country column reference with the sheet reference in curly brackets {like this}. Please see a screen capture below of an example from one of my sheets, using a multi-select drop-down column type.

PR_T

Thank you Genevieve Penny It worked

 

 

Genevieve P.

Great! Glad to hear it.