Clay Icon
Join the Community
02 Support

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

Avatar of Skye S.Skye S.
·
·

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

  • Avatar of Clay Team
    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 😉

  • Avatar of Skye S.
    Skye S.
    ·
    ·

    Column I am trying to consolidate into: Email Columns I an trying to combine: Valid Apollo + Work Email

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Hey, thanks for reaching out! taking a look

  • Avatar of Clay Team
    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

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    There we go, just updated the formula, and seems to be working now!