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 type is kit 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 type is a kit then it returns "good", else it returns "no", you can use the following formula:

```CASE WHEN {type} = 'Kit/Package' THEN 'good' ELSE 'no' END```

This formula uses the `CASE` statement to check the condition `{type} = 'Kit/Package'`. If the condition is true, it returns 'good'. If the condition is false, it returns 'no'.

You can add this formula in the Formula (Text) field of your saved search criteria.

******
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/p1655901675319359|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.831909239

&gt;*Slack thread 2:* <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.83136

&gt;*Slack thread 3:* <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.828491271



Please provide your feedback on this answer.