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

·

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

· Sorted by Oldest

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 😉
Travers Nammack
·
·
Also, any reason clearbit descriptions get cut off? Is there a workaround for this?
Travers Nammack
·
·
https://app.clay.com/workspaces/102418/tables/t_1CH7wixMSz2O/views/gv_OTvB1PuEdxQD
Clay Team
APP
·
·
Hey Travers Nammack!! 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!

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 😉
Travers Nammack
·
·
Also, any reason clearbit descriptions get cut off? Is there a workaround for this?
Travers Nammack
·
·
https://app.clay.com/workspaces/102418/tables/t_1CH7wixMSz2O/views/gv_OTvB1PuEdxQD
Clay Team
APP
·
·
Hey Travers Nammack!! 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!