COUNTIF/FIND/OR in multiselect column

Lauren Y

Im looking for help using or in searching for any of the values in a column.

Original/reference Column with multiselect where I am looking to find any instances of the sub category.

Attempting to count number of instances of any of the selections:

Current attempt:

=COUNTIF({1 | Neuroscience PPM Range 1}, FIND(OR(@cell = [Risk/Issue]24, @cell = [Risk/Issue]25, @cell = [Risk/Issue]26),

Have made sure that the spelling and cases are correct but Im getting lost in the "or" I think.

TIA!

Paul Newcome

You're close:

=COUNTIFS({1 | Neuroscience PPM Range 1}, OR(FIND([Risk/Issue]24, @cell)> 0, FIND([Risk/Issue]25, @cell)>0, FIND([Risk/Issue]26, @cell)> 0))

Lauren Y

Thank you so much Paul! Appreciate all that you do on here

Paul Newcome

Happy to help. 👍️

If you happen to be at ENGAGE, feel free to track me down. I have "Happy to help 👍️" buttons!