Formula for Assigning Reps Based on Cities in Territory List

Hi! I have a list of companies with cities and states that have been enriched. I want to use a formula to assign these to reps based on their territories. However, the reps are assigned by city, not state. Is there a way I can ask Clay to refer to another list of cities when building a formula to assign a lead to a reap (i.e., If /city is equal to one of these 200 cities, list Rep 1). Thanks!

4 comments

Channeled
APP
·
·
💤 You've caught us outside of our support hours (9am-9pm EST), but don't worry - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in the thread below so that we can help you as quickly as possible!
Bo (.
·
·
Yes, absolutely! Have you tried this already, and it didn’t work? You can create a new Formula column in Clay and add the list of 200 cities. For example, you can set up a formula to check if a city matches any of those on the list, and if it does, it assigns the lead to the correct rep. Once the list is in place, you can reference that column in your formula prompt to assign leads based on city. Let me know if you need help setting it up! 😊
Channeled
APP
·
·
We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!
Channeled
APP
·
·
Hi Jackie S.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: