Forum Discussion
MarkShnier__You
Qrew Legend
4 days agoYou can only use the function Contains a field, which is of type Text. So in my example, I assumed that you would make a helper field that would convert the multi select text field to be a text field.
also, the contains function should just be looking for the phrase Tier 1.
so if you were not using a helper field, that would look like this.
IF(
Contains(ToText([My Multi-Select Field]), "tier 1"), "Tier 1",
Contains(ToText([My Multi-Select Field]), "tier 2"), "Tier 2",
Contains(ToText([My Multi-Select Field]), "tier 3"), "Tier 3")