Clay Icon
Join the Community
02 Support

Formula Issue: Email Lookup Returning Incomplete Results - Seeking Assistance

Avatar of Claire F.Claire F.
·
·

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

9 comments

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    Hey Claire! Taking a quick look

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    Looks like Neverbounce is saying that the emails are invalid. I unhid those columns to check the results.

  • Avatar of Claire F.
    Claire F.
    ·
    ·

    So even if they are invalid why wouldn't they show up in the final colum?

  • Avatar of Claire F.
    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

  • Avatar of Clay T.
    Clay T.
    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)
  • Avatar of Clay T.
    Clay T.
    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.

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

  • Avatar of Claire F.
    Claire F.
    ·
    ·

    This is fabulous! Thanks very much

    ✨1