Clay Icon
Join the Community
02 Support

Is it possible to write a formula that uses data from 2 different tabl...

Avatar of Travers N.Travers N.
·
·

Is it possible to write a formula that uses data from 2 different tables. (I understand I can lookup data, not what I'm trying to do). If for example, I had a list of company descriptions in 1 table, and a list of company description in another table, and I was trying to match companies with similar descriptions, can this be done inside of Clay?

4 comments

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉

  • Avatar of Travers N.
    Travers N.
    ·
    ·

    Also, any reason clearbit descriptions get cut off? Is there a workaround for this?

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Hey Travers N.!! Unfortunately, without the Lookup Record pulling in data from the other table, there's no way to reference another record that's not from the same sheet yet but will ask if it could be done at some point.Also, thanks for flagging the issue about the descriptions. I'll report it to the team!