Item saved search, formula that returns “Valid” if isdropshipitem=T

AI generated answer (using internal Slack threads):

To create an item saved search with a formula that returns "Valid" if isdropshipitem=T, you can use a formula text field in your saved search. Here's how you can do it: 1. Go to your saved search and add a new column. 2. For the type, select "Formula (Text)". 3. In the formula field, enter the following formula:

CASE WHEN {isdropshipitem} = 'T' THEN 'Valid' ELSE 'Invalid' END

This formula uses a CASE statement to check if the 'isdropshipitem' field is 'T'. If it is, it returns 'Valid'. If it's not, it returns 'Invalid'. Remember to replace 'isdropshipitem' with the actual field ID if it's different in your system. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******