Give me a formula to use in a saved search to see if any transaction is missing a vendor name

AI generated answer (using internal Slack threads):

To create a saved search to see if any transaction is missing a vendor name, you can use a formula field in the criteria of your saved search. Here is the formula you can use:

CASE WHEN {vendor.name} IS NULL THEN 1 ELSE 0 END

In the criteria of your saved search, add a new line with the following settings: - Field: Formula (Numeric) - Operator: equal to - Value: 1 - Formula:

CASE WHEN {vendor.name} IS NULL THEN 1 ELSE 0 END

This formula will return 1 if the vendor name is missing (NULL), and 0 if a vendor name is present. By setting the operator to 'equal to' and the value to 1, the search will only return transactions where the vendor name is missing. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******