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.
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