Issue with Email Data in Table: Need Help to Resolve Fill Problem

Hey Team! Not sure if this is a bug or just bad data but in this table 'm enriching people for Work Emails but receiving gmail, yahoo, and hotmail addresses. The drawback to this is that it's not filling in the column properly. I'm manually having to go through to see which is the "current_professional" email. I can't just fill the column with Email 1 for instance because Email 1 could be a personal email in another search/enrichment. Maybe there's a formula to fill cells with the sibling of >Email>"current_professional">Address? Thank you! 👻

👀1

6 comments

Arturo O.
·
·
Hey Jonathan, thanks for the inquiry and sharing the details! Took a closer look and noticed this was due to some providers that take LI URLs as the main input instead of company domain + name. They could return whatever information they have on those prospects which would require filtering, a formula likely does the trick. However, looks like most of those empty fields were due to the email being invalid in the first place. Here's a video of my findings and column I added: https://www.loom.com/share/c03f806623aa4ed6881c0cff0e251ebc Let me know if you have additional questions!
Jonathan T.
·
·
Man this was so awesome, thank you! I was wondering how i might configure something like that so this is perfect.
👻1
Channeled
APP
·
·
Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.
Channeled
APP
·
·
We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!
Channeled
APP
·
·
Hi Jonathan T.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Channeled
APP
·
·
Thank you so much for sharing your feedback Jonathan T.!