Issue with Empty Cells in School Name Retrieval for Leads

·

I asked Clay to return a the name of the school for a lead if that lead has gone to that particular school, but the cells are all empty. The logic on AI checks out. What's going on? See image.

1 comment

Channeled
APP
·
·
This is likely happening because the AI column is missing required data to run properly. Empty cells often occur when: 1. The column needs specific data to function (like education history) that might be missing 2. The AI formula might need iteration - it's normal if it doesn't work perfectly on first try To fix this: ** Check if you've set "Required to Run" for necessary fields ** Create a new column by duplicating the current one ** Run it only on empty rows (filter for "is empty") ** Then merge the columns
Sources: Referencing dynamic data from other columns | Documentation | Clay University AI Formulas + Conditional Runs [Clay 101] - Clay University