Home

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

Explore Events
Learn Clay here
Clay Cup

Powered by Tightknit

Formula Issue: Email Lookup Returning Incomplete Results - Seeking Assistance | Clay

Formula Issue: Email Lookup Returning Incomplete Results - Seeking Assistance

·Feb 14, 2024 02:40 AM·

Hi, can you please tell me where the formula for this is going wrong? I have all the email looking up information however its not returning everything in the cell please see screenshot

Loading attachments

9 comments

· Sorted by Oldest

Claire F.
·
·
https://app.clay.com/workspaces/55637/tables/t_lfO1wYkh3Moc/views/gv_HfMJl50hUK7x
Clay Team
APP
·
·
Hey Claire! Taking a quick look
Clay Team
APP
·
·
Looks like Neverbounce is saying that the emails are invalid. I unhid those columns to check the results.
Claire F.
·
·
So even if they are invalid why wouldn't they show up in the final colum?
Claire F.
·
·
Or are you meaning if they are not coming out in the "Validated work Email" because they really shouldn't be used because they are invalid
Clay Team
APP
·
·
Kind of both situations. The waterfall has preset formulas to check for "valid" status, specifically the Validated Work Email column
115d19b0-ca5a-4105-8d15-b4ec4667504d.png(29 kB)
Clay Team
APP
·
·
Of course, you can always have a separate column that collects all emails regardless if you'd like to try them anyway. We usually don't recommend that to decrease the probability of running into high bounce rates but that may not always be the case because some validation tools skip catch-alls even when they're valid or usable, some others may consider them.
Clay Team
APP
·
·
If the formula is updated to not check the validation status, that should work. I added an example next to your current columns in case you'd like to check it out.
Claire F.
·
·
This is fabulous! Thanks very much
✨1