How do I filter on a long list of emails or IDs

The three main options here will be to (1) define a field where it creates a true/false flag that filters on those 1200, (2) use the filter by query functionality or (3) to drop them into the SQL statement directly.

For (2), you can build out a list of IDs that you want to filter down to in a tab, and then on a secondary tab add a filter on that field, select the filter by query option, and point it to the tab where you’ve reduced the list down. More information can be found here in the docs.

You can quickly use an excel sheet to concatenate the single quotes ' on either side as well with something like CONCAT("'",A1,"',") and then chaining those together to get a full list

1 Like