I'm working on a formula (text) field on a saved search where if {fieldA} = {fieldB} then return a certain value. I am able to do this with the following formula:

CASE WHEN {fieldA} = {fieldB} THEN {name} ELSE Null END

However, the issue is that {fieldA} is a multi-select field. So, this only works if only one thing is selected in that field. Is there some sort of "contains" function I could add to this to say if {fieldA} contains whatever is selected in {fieldB}, then the correct value would be returned?

maybe try this: case when {fieldA} LIKE '%{fieldB}%' then {name} else null end

Thanks @Jenny - unfortunately, this did not work for me. If I add the %'s, it doesn't return anything and, if I just use the LIKE without the %, it treats it the same as =

Suite Answers 70852 has an example of a case when formula including a multi-select field. It's a bit different than the formula you're trying to use, but it might help point you in the right direction to make it work out.

@Chloë Thank you -- using the INSTR formula got me where I needed to be!