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

AI generated answer (using internal Slack threads):

Based on the conversations, it seems like you want to create a text formula for an item saved search in NetSuite where if the item subtype is not null, it returns "good", otherwise it returns "no". You can achieve this by using a CASE statement in your formula. Here's an example of how you might do this:

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

In this formula,

{itemsubtype}

is the field you're checking. If it's not null, the formula will return 'good'. If it is null, it will return 'no'. Please replace

{itemsubtype}

with the actual field API name you're checking in your saved search. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******