Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Needing a formula in a saved search to return a value if a multi-select field contains the value of
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?