Trying to Count multiple text by referring from another sheet

PR_T
PR_T
edited 12/09/19 in Smartsheet Basics

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.

 

IMG.PNG

out put.PNG

Comments