In saved search "Formula (Text)" example of: if Foo = YES then "AAA" Else "BBB"

AI generated answer (using internal Slack threads):

Based on the conversations provided, it seems like you're looking for a way to create a formula in a saved search that will return a specific value based on a condition. In NetSuite, you can use the

CASE WHEN

statement in your formula to achieve this. Here's an example based on your request:

CASE WHEN {foo}='YES' THEN 'AAA' ELSE 'BBB' END

In this formula,

{foo}

is the field you're checking. If the value of

{foo}

is 'YES', then the formula will return 'AAA'. If the value of

{foo}

is not 'YES', then the formula will return 'BBB'. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******