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
By the way, @Nick Singh, about the Lookup Record column not returning a count, that's because it was not an "Exact" match, if you compare the two values from table 1 vs table 2, you're checking if: -> xyz.com "is contained within" (not Equal to) -> https://xyz.comThus, Exact Match Count is not applicable but your workaround with the formula is the way.
I see the issue with Apollo as well, since it's using Javascript for the formula, it's case-sensitive and not converting the value to lowercase to determine a match. You can prompt the formula to "check for lowercase" so it adds it to the formula. I corrected this manually though
.png){kind=logo}
