Empty Columns in Company Look Up: Troubleshooting and Fixing the Issue

GEM Resourcing · 2024-01-30 07:58:52.602761+00

Hello there. We need some help as to why the columns are not being filled in when we do a company look up they are not returning any information in the cells as the previously have

Empty Columns in Company Look Up: Troubleshooting and Fixing the Issue | Clay

GEM Resourcing
·
·
https://app.clay.com/workspaces/161420/tables/t_DUiHlvWWQdFQ/views/gv_uS2ki11daACD
Clay Team
APP
·
·
Hi, thanks for getting in touch! I can see that your table is almost empty, including the website column which is mapped in the lookup to match with the google sheet
GEM Resourcing
·
·
We did a company look up from LinkedIn, and saved it to the table template with all of the columns pre formatted. And that's all it produced? It's not running any of the cells?
Clay Team
APP
·
·
Hey GEM Resourcing, happy to jump in here as this scenario is not quite common and hard to catch at first glance. What might've happened here is since this was duplicated but the original table had other fields or the field's names were slightly different then that's why it's not detecting where to extract the data from.
Clay Team
APP
·
·
If those values are updated for those columns that should extract the values, then that would allow the rest to be filled automatically. Let me know if you have additional questions or if you need help doing this!
GEM Resourcing
·
·
Thank you, but that did not seem to work? I have tried uploading new companies to a new table, and that did not work either?
Clay Team
APP
·
·
Hmm, let me make sure the columns are pulling from the right sources.
Clay Team
APP
·
·
This was the issue, those other columns were referencing a column that didn't exist or didn't have any values. I changed them to pull data from the new import column you added and that fixed it. Let me know if you run into any issues!
GEM Resourcing
·
·
Thank you, but the reason I am importing to the "Latest Company Table" is because I had already formatted the cells with a formula?
Clay Team
APP
·
·
I see, but the issue is that once the import was completed for some reason it didn't link to where it should've sourced the leads from, so it had to be re-mapped, the formulas should still work as long as the data exists. Let me know if you see a column that should be populated because the values it depends on already exist but it doesn't run!
GEM Resourcing
·
·
Right! So I tried uploading new companies to the table, and the columns are not working properly? Same as when I try and upload to a new table, the formulas and columns are not working properly? Is CLAY having any issues on that end? Thank you!
Clay Team
APP
·
·
Thanks for the follow up! Will take a look, but I don't think it's an issue with the system itself but maybe just that template that's not detecting the values once you upload them. As mentioned, if the original source was a different column and that's where it was pulling data from then the format has to match for any new data sets that get added so they're auto-detected.
Clay Team
APP
·
·
I see the formula columns but they're only returning specific words, is that the expected behavior, or was it supposed to return different values depending on criteria?
Clay Team
APP
·
·
Also, I think this may be part of the issue (maybe?), the table is turned off so it doesn't auto-update.
GEM Resourcing
·
·
Here is the issue... Is there anything you can suggest or do? I can't seem to upload any new companies to ANY tables. And I have tried everything you have suggested? Thanks again! Look forward to hearing from you.

19 comments