Resolving Formula Column Errors with Upstream Enrichment Dependencies
I'm having an issue with a formula column that combines three other columns (First Name, Work Search String, School Search String). The formula works fine when all upstream enrichment columns have completed, but throws an "Error evaluating formula" when I add a new row and the formula tries to execute before the upstream LLM enrichments finish processing. My formula is designed to:
Combine First Name + Work + School with spaces
Skip Work if null/empty
Skip School if null/empty
Always include First Name
The formula works in the preview when I generate it, but fails in practice when upstream columns are still processing. Is there a way to make the formula column wait for upstream enrichments to complete before executing? Or do I need to add explicit dependencies somehow? Current workaround I'm considering: Replace the formula with an LLM enrichment that does the same concatenation logic, but that seems inefficient for such a simple task
