Clay Icon

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.

  • Avatar of Clay T.
    Clay T.
    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 ๐Ÿ˜‰

  • Avatar of Alexander T.
    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.

  • Avatar of Clay T.
    Clay T.
    APP
    ยท
    ยท

    Hey there Alexander sorry for the delay, let me take a look.

  • Avatar of Clay T.
    Clay T.
    APP
    ยท
    ยท

    What column can the formula be found in?