Creating a dimension to select a list of values

[Anonymous]

Hello,

I used this formula to select all the values of my field 'CRM Case Title' that containg the word "test" written in all possible ways

=If([CRM Case Title] like ("*TEST*","*test*","*Test*","*testing*","*TESTING*","*Testing*"),[CRM Case Title])

This is what I entered when creating a dimension, but for some reason I got error in my expression,

Could you please help me see what is wrong with my expression?

Thank you so much,

[sunny_talwar]

Try this instead

=If(WildMatch([CRM Case Title], '*TEST*', '*test*', '*Test*', '*testing*', '*TESTING*', '*Testing*'), [CRM Case Title])

[sunny_talwar · Accepted solution]

Although this should be enough because WildMatch function is case insensitive

=If(WildMatch([CRM Case Title], '*Test*'), [CRM Case Title])

[Anonymous]

Perfect!! Thank you so much for your help today 🙂