Hey team, looks like there’s an issue with conditional formulas and fi...

Hey team, looks like there’s an issue with conditional formulas and filtering. I can’t filter by emails in this table, and the conditional formula to run more enrichments is not working.

9 comments

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 😉
Clay Team
APP
·
·
Hey Daniela! Thank you for flagging this, I'll take a look
Clay Team
APP
·
·
Daniela D., looks like the formula to pull final emails was not evaluating if ZB was valid or not so I just updated it with a new prompt and now working. The filter is also working after this because it now leaves the cell empty if it doesn't find anything, whereas before it was inserting a blank space for some reason
Clay Team
APP
·
·
What other formulas or columns where having issues? Let me know!
Daniela D.
·
·
Thank you! The conditional formula in the email enrichment also wasn’t working
Clay Team
APP
·
·
Got it, so in this case Findymail, right? It should have the condition to only run if ZB is not valid?
Daniela D.
·
·
Condition to only run if a row in zero bounce email is empty. I created that column to pull valid emails from the zerobounce enrichment
Clay Team
APP
·
·
Nice! just added that condition to Findymail which would be this !!{{Zerobounce emails}}Let me know if you run into any other issues!
Clay Team
APP
·
·
oops, sorry. I added an extra ! symbol, it should only have one. Just fixed it