ANS-0084 · SAVED SEARCHES & FORMULAS
How to Display Multi-Select Field Values in NetSuite Saved Searches?
Understand how NetSuite multi-select fields appear in saved search results and methods to customize their display.
Short answer
When a multi-select field is included in a NetSuite saved search, all selected values typically appear in a single, comma-separated line. To display each selected value in its own column, a join can be performed on the multi-select field within the saved search criteria or results.
Scenario
Users often encounter situations where multi-select field values in NetSuite saved searches are presented as a single, comma-separated string. This default display can sometimes make data analysis or reporting less straightforward, especially when needing to view each selected option individually.
Solution
When a multi-select field is added to a saved search, NetSuite by default displays all selected options for a record in a single line, separated by commas. For scenarios requiring each selected value to appear in distinct columns, a join can be performed on the multi-select field within the saved search definition. This approach allows for a more granular display of multi-select data.
Expert NetSuite Support
Need help with this NetSuite issue?
Saved Searches & Formulas consulting and configuration support