When I use a formula to consolidate valid emails into 1 column, in the...

·Dec 05, 2023 05:24 PM·

When I use a formula to consolidate valid emails into 1 column, in the formula editor it shows the correct results but then the column doesnt actually show all the emails in the consolidated column

6 comments

· Sorted by Oldest

Clay Team
APP
·
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Skye S.
·
·
https://app.clay.com/workspaces/11782/tables/t_T9VslzPRdnuR/views/gv_a2ty3XIROAUh
Skye S.
·
·
Column I am trying to consolidate into: Email Columns I an trying to combine: Valid Apollo + Work Email
Clay Team
APP
·
·
Hey, thanks for reaching out! taking a look
Clay Team
APP
·
·
Ah, I see, it's because one of the columns has errors in it and it's waiting on that to "finalize" so it can then evaluate the next step
Clay Team
APP
·
·
There we go, just updated the formula, and seems to be working now!

Clay Team
APP
·
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Skye S.
·
·
https://app.clay.com/workspaces/11782/tables/t_T9VslzPRdnuR/views/gv_a2ty3XIROAUh
Skye S.
·
·
Column I am trying to consolidate into: Email Columns I an trying to combine: Valid Apollo + Work Email
Clay Team
APP
·
·
Hey, thanks for reaching out! taking a look
Clay Team
APP
·
·
Ah, I see, it's because one of the columns has errors in it and it's waiting on that to "finalize" so it can then evaluate the next step
Clay Team
APP
·
·
There we go, just updated the formula, and seems to be working now!