Home
Events
Groups
Members

01 Watercooler
02 Bugs
02 Starting with Clay
Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
Gtm Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Powered by Tightknit

Issue with Lookup Formula Returning ID Instead of Company Size Tags

·

·

Hi Team, I am trying to Lookup a single row in a table to get company size from a company table. But when I use the formulae for size, it gives me id as output column intsead of size tags i.e. 1-10 11-50 etc.

Issue with Lookup Formula Returning ID Instead of Company Size Tags | Clay

4 comments

· Sorted by Oldest

Channeled
APP
·
·
When using the "Lookup Single Row in Other Table" integration, you can extract specific variables from your companies table into your target table.Here's how to get the company size instead of just the ID: 1. Add the "Lookup Single Row in Other Table" column 2. Click on any cell in that column 3. Select the specific company size variable you want to extract from your companies table 4. The output will now show the company size value instead of just the IDThis is particularly useful for "1 to many" data relationships, where you need to reference specific information from a parent table. Sources: Find People [Clay 101] - Clay University Write to Table [Clay 101] - Clay University
Channeled
APP
·
·
Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!
Tanvi R.
·
·
Hi aditya, thanks for reaching out! Do you mind sending the link to the table so we can take a look? https://downloads.intercomcdn.com/i/o/1171717996/ac7729f84b426e1d0358af02/image.png?expires=1733340600&signature=cc14fa0e2d6a86edeab2c8566cf96745f8b6705e5d967baaafa9231b20fa96e1&req=dSEgF85%2FmohWX%2FMW1HO4zYTywSj%2FApcQ2BKsam%2FhVPty%2Bg%3D%3D%0A
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in Clay Support.