Help needed for generating a formula for approved 2 Email column

Need help in generating a formula that works in my "approved 2 Email" column.

· Sorted by Oldest

Nick S.
·
·
https://app.clay.com/workspaces/207112/tables/t_FOsoEHuQCF4Q/views/gv_cHw3v66dn7Mo
Clay Team
APP
·
·
Hi Nick, thanks for getting in touch! what are you trying to generate with the formula?
Nick S.
·
·
if the domain is ready (1 match found) and there is no existing client (0 matches found), set to Approved 2 Email to YES. if domain is ready (1 match found) and there is an existing client (1 match found), set Approved 2 Email to NO
Nick S.
·
·
Juan P.
Clay Team
APP
·
·
I think there is a bug in your column, is not counting properly the matches
efe7d2f9-de2d-4785-9e01-5f05919d34c9.png(40 kB)
Clay Team
APP
·
·
I will check with the engineers
Nick S.
·
·
is there a work around for now?
Clay Team
APP
·
·
we need to fix this
Nick S.
·
·
is it the bug also here, as this formula is not working either https://app.clay.com/workspaces/207112/tables/t_FOsoEHuQCF4Q/views/gv_cHw3v66dn7Mo Check Verified Master Emails column: ({{Apollo Email Status}}?.includes("Verified") <-- this is not being picked up and mapping the email value in Apollo Email to the column
Clay Team
APP
·
·
I think is the same problem
Clay Team
APP
·
·
we will see sorry for this inconvenience
Nick S.
·
·
can you double check this one too somehow, as if so, I'm blocked and will focus on other things
Clay Team
APP
·
·
will update you once is fixed
🙏1
Nick S.
·
·
is this likely to be fixed today?
Clay Team
APP
·
·
I think so, but can occur during the NY timezone
:thumbsup_all:1