Need help building a Formula–Text field

Thanks, Mark. I have already tried Contains() directly against the Multi-Select Text field, but I’m still getting inconsistent results.

To keep the example generic, here is the structure I tested:

If(

    Contains([My Multi-Select Field], "Tier 1 - Option A") or

    Contains([My Multi-Select Field], "Tier 1 - Option B") or

    Contains([My Multi-Select Field], "Tier 1 - Option C"),

    "Tier 1",

    Contains([My Multi-Select Field], "Tier 2 - Option A") or

    Contains([My Multi-Select Field], "Tier 2 - Option B") or

    Contains([My Multi-Select Field], "Tier 2 - Option C"),

    "Tier 2",

    Contains([My Multi-Select Field], "Tier 3 - Option A") or

    Contains([My Multi-Select Field], "Tier 3 - Option B") or

    Contains([My Multi-Select Field], "Tier 3 - Option C"),

    "Tier 3",

    "NOT MATCHED"

)

->I also tested a single condition:

If(

    Contains(

        [My Multi-Select Field],

        "Tier 1 - Option A"

    ),

    "MATCHED",

    "NOT MATCHED"

)

When Tier 1 - Option A is the only selected value, the result is still NOT MATCHED.

I created a helper Formula-Text field using:

Lower(ToText([My Multi-Select Field]))

and the displayed result is:

tier 1 - option a

I also tested multiple selections:

tier 1 - option b ; tier 1 - option a

Expected result:

Tier 1

But the formula still returns:

NOT MATCHED

Some other choices work when selected alone, so it seems to be specific to certain configured choices or to how the Multi-Select field is being evaluated.