Clay Icon
Join the Community
02 Support

Troubleshooting: Why is the formula still giving me an output with valid email found set to YES?

Avatar of Nick S.Nick S.
·
·

any idea why it's still giving me an output when the formula should only run if "valid email found" is YES. The rest of the formula works well, it just chooses to ignore the initial rule.

7 comments

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Hey Nick! Taking a look

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    I see now! It appears it was not checking if the valid column had YES or nothing in the end, so the default response was to fill it with the domain if all the previous criteria were not met. Adding/prompting it to return nothing or leave it empty if /validColumn is not YES should fix it but it may take a bit of properly writing it out.

    791ec7e9-1ca8-4919-ba9c-e6f8155d2f8c.png(12 kB)
  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    You can manually replace the last part of your formula with this in the meantime, which is exactly what it needs to work though. ​​({{Valid Email Found}} != "YES" ? "" : {{Company Domain}})​​

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Quick example in a separate view in your table:

    41b9d4e0-e3cd-4e3e-9d0f-538923bd82a2.png(20 kB)
    🙏1
  • Avatar of Nick S.
    Nick S.
    ·
    ·

    Will give this a go in a couple of hours

  • Avatar of Nick S.
    Nick S.
    ·
    ·

    🦾 it worked! Arturo O.