Issue with Prospeo Column on People Table: No Results for Work Emails

For some reason, the prospeo column on my People Table didn't generate results for Work emails. Please advise!

Kenan K.
·
·
https://app.clay.com/workspaces/23827/tables/t_VL14mSDkvxhy/views/gv_QZlHufsQPQzt
Clay Team
APP
·
·
Hi, thanks for getting in touch!
Clay Team
APP
·
·
you mapped the columns wrong
24663c9e-0642-4ea5-8310-958a7219d3b7.png(50 kB)
Kenan K.
·
·
Ok
Kenan K.
·
·
I see why it showed errors on in all the cells under Prospeo
Kenan K.
·
·
How can I correct it?
Clay Team
APP
·
·
Map the full name column in the full name field, this should be enough
Kenan K.
·
·
There's no full name column, I have first and last name columns
Kenan K.
·
·
What do you recommend?
Clay Team
APP
·
·
this formula column:
8cc4d751-71be-4e47-8e9c-856d7af242e1.png(188 kB)
Kenan K.
·
·
Hey, I'll need help with this table. For some reason the formula I created isn't working. I'm getting ''error'' in the cells
Kenan K.
·
·
when running for work emails
Kenan K.
·
·
https://app.clay.com/workspaces/23827/tables/t_b4jB8Og3RHEz/views/gv_E3M7Zi0l229B
Clay Team
APP
·
·
Hey Kenan, jumping in here
Clay Team
APP
·
·
In case it helps for future reference -> Here's a video of how to Split or Combine names with formulas: https://www.loom.com/share/75cf18efe4bf47979c6b4868d1594e6c
Clay Team
APP
·
·
I noticed some of the providers were still using the incorrect input but I just updated them to the full name for you
Kenan K.
·
·
Thank you so much
✨1