Fixing Formula for Email Data Verification: Ensure All Columns Filled, Engineer < 12 Months

·

Can you tell me why this formula doesn't work and how to fix it? I want to make sure that all the columns have data to craft this email and that the engineer's experience is less than 12 months.

5 comments

· Sorted by Oldest

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 😉
Alexander T.
·
·
https://app.clay.com/workspaces/90784/tables/t_gHlXmNt1d9gr/views/gv_xnv3IeLV8JHJ
Alexander T.
·
·
The number of months filter works but it doesn't capture the Founder name filter and runs it even if it is empty. I cannot tell about the other ones.
Clay Team
APP
·
·
Hey there Alexander sorry for the delay, let me take a look.
Clay Team
APP
·
·
What column can the formula be found in?

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 😉
Alexander T.
·
·
https://app.clay.com/workspaces/90784/tables/t_gHlXmNt1d9gr/views/gv_xnv3IeLV8JHJ
Alexander T.
·
·
The number of months filter works but it doesn't capture the Founder name filter and runs it even if it is empty. I cannot tell about the other ones.
Clay Team
APP
·
·
Hey there Alexander sorry for the delay, let me take a look.
Clay Team
APP
·
·
What column can the formula be found in?