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!
Formula to compare any matching multi select
Hello,
I have a multi-select field, Team, deployed to customer and employee. I'd like to create a search that lists the customers where any value for Team on company matches any selected value for Team on the employee.
the simple formula:
case when {custentity_team} in {user.custentity_team} then 1 else 0 end
appears to work when both the selected teams match exactly between customer and employee but not when they have only one common Team.
Has anyone done this or have any ideas as to how to accomplish it?