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 am attempting to use a formula on a Set Field Value action to determine which value to apply to each item on a saved search. My 4 possible values are from a list. However, I can't get it to work as a formula. I've tested it by choosing a static value, which works, but a formula result using the CASE method isn't recognized. I've tried returning formula results as list IDs, string versions of the List ID, and string versions of the values, but no luck. Would anyone happen to know what I'm missing? Screenshots over the in the thread --&gt;

`Attempt #1`
CASE
 WHEN NVL({reorderpoint},0) = 0 AND NVL({preferredstocklevel},0) = 0 AND NVL({quantityonhand},0) &gt; 0 THEN 1
 WHEN NVL({reorderpoint},0) = 0 AND NVL({preferredstocklevel},0) = 0 AND NVL({quantityonhand},0) = 0 THEN 2
 WHEN NVL({reorderpoint},0) &gt; 0 AND NVL({preferredstocklevel},0) &gt; 0 THEN 3
 ELSE 4
 END

Attempt #2
CASE
 WHEN NVL({reorderpoint},0) = 0 AND NVL({preferredstocklevel},0) = 0 AND NVL({quantityonhand},0) &gt; 0 THEN 'SunSetting Inventory'
 WHEN NVL({reorderpoint},0) = 0 AND NVL({preferredstocklevel},0) = 0 AND NVL({quantityonhand},0) = 0 THEN 'NonStock Inventory'
 WHEN NVL({reorderpoint},0) &gt; 0 AND NVL({preferredstocklevel},0) &gt; 0 THEN 'Replenished Inventory'
 ELSE 'Not Defined'
 END

Attempt # 3
CASE
 WHEN NVL({reorderpoint},0) = 0 AND NVL({preferredstocklevel},0) = 0 AND NVL({quantityonhand},0) &gt; 0 THEN '1'
 WHEN NVL({reorderpoint},0) = 0 AND NVL({preferredstocklevel},0) = 0 AND NVL({quantityonhand},0) = 0 THEN '2'
 WHEN NVL({reorderpoint},0) &gt; 0 AND NVL({preferredstocklevel},0) &gt; 0 THEN '3'
 ELSE '4'
 END

You definitely have to set it as a number. So option 2 is out. Is the number you are using the internal ID of the values in the Sublist not just the order. Check Customizations &gt; Lists 