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

Text Formula for item saved search, if item subtype is null then “good” else “no”

&gt;*AI generated answer (using internal Slack threads):*
To create a text formula for an item saved search where if the item subtype is null then it returns "good", else it returns "no", you can use a CASE statement in a Formula (Text) field. Here is an example:

```CASE WHEN {itemsubtype} IS NULL THEN 'good' ELSE 'no' END```

This formula checks if the item subtype is null. If it is, it returns 'good'. If it's not null, it returns 'no'.

******
Disclaimer:

This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******

&gt;*Slack thread 1:* <https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1533647081000187|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.811767638

&gt;*Slack thread 2:* <https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1681755297163319|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.808410645

&gt;*Slack thread 3:* <https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1583152608299900|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.806884766



Please provide your feedback on this answer.