Formula Issue: Email Lookup Returning Incomplete Results - Seeking Assistance

·

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

✅1

9 comments

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