Hi all! I'm trying to create a condition where if a counterparty address is from a list of 8 countries, it triggers Legal review. I used Country() on both the billing contact and commercial contract addresses to create two new fields: Billing Country and Commercial Country.
Then I created a Watchlist condition using a series of 16 Contains() formulas (for both the new fields). I've added Watchlist to my long list of conditions that trigger Legal review.
I think this is efficient from a couple of different perspectives: if I win the lottery, whoever takes over for me at Everlaw can see exactly what's happening; or if we decide to add or subtract countries, it's easy enough to add or delete formulas.
But is there a less clunky way to do this?