This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I'm looking to have a Saved Search formula that would result in a Color being shown if it is part of an item description - possible to do something like:
CASE WHEN {item.description} contains (not sure the sql equivalent for contains is) ("blue", "red", "yellow") THEN show the color that the description contains END

Im generally bad at formulas, so I say brute force it

CASE WHEN INSTR({item.description}, 'blue') &gt; 0 THEN 'blue' WHEN INSTR({item.description}, 'red') &gt; 0 THEN 'red' WHEN INSTR({item.description}, 'yellow') &gt; 0 THEN 'yellow' END

hopefully your descriptions don't contain multiple colors

Do you want to display the color name, or actually style the search results based on the color?  If it's the latter, I saw this article once, though never had the need for it myself:  <http://www.melioza.com/2016/08/common-html-code-to-format-netsuite.html>

The basic idea is wrapping the column in a DIV or SPAN tag so you can apply styles to it.