COUNTIF/FIND/OR in multiselect column

Lauren Y
Lauren Y ✭✭✭✭
edited 09/15/23 in Formulas and Functions

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!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!