hey everyone! Is there a way to write a formula for the criteria of a saved search to match the contents of a field to the contents of a multiple select field? Basically what I need is: If shipping zip on a transaction matches any value in a multiple select field of zip codes, then show results. Any help would be appreciated!

How many zip codes are required for selection? If there's only a handful, you could do something like : Formula (Numeric) CASE WHEN {shippingzipfield(whatever the field value)} is '1' or '2' or '3' THEN 1 ELSE 0 Value IS EQUAL TO 1

Thanks so much! We actually can have a long list in the multi-select field. But I think I got it to work with: CASE WHEN INSTR({multi-select field}, {ship zip field}, 1) > 0 THEN 1 ELSE 0 END