Clay Icon

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!

  • Avatar of Channeled
    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!

  • Avatar of Bo (.
    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! ๐Ÿ˜Š

  • Avatar of Channeled
    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!

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Hi Jackie S.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: