How do formula(text) filters work

AI generated answer (using internal Slack threads):

Formula (Text) filters in NetSuite are used to create custom criteria for saved searches. They allow you to create complex search conditions that are not possible with standard search fields. To use a Formula (Text) field as a filter in a saved search, you need to set it up as a criteria. Here are the steps: 1. Go to the Criteria subtab of your saved search. 2. Click on the 'Add a New Filter' button. 3. In the 'Field' dropdown, select 'Formula (Text)'. 4. In the 'Formula' field, write your formula. This formula should return a text value. 5. In the 'Operator' dropdown, select the appropriate operator for your formula. 6. If necessary, in the 'Value' field, enter the value to compare with the result of your formula. Please note that only the first formula of each type (text, currency, date, etc.) in your results set can be used as an available filter. If you want to use multiple formula results in your filters, you'll have to get creative with your approach. Also, it's important to note that while you can add a formula column as a filter, it may not always work as expected. If you're not getting the expected results, it's worth double-checking your formula and the values you're filtering on. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******