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
You can make your formula column wait for upstream enrichments using conditional run settings. Go to your formula column's Run Settings and add an "Only run if" condition that checks if the upstream columns have completed.
Use this formula to check column completion status:
Clay.getCellStatus(#{{field_id}})This function checks whether your upstream enrichment columns have finished processing before your formula runs. You can combine multiple status checks for all three upstream columns (First Name, Work Search String, School Search String) in your condition. [1]
This approach is more efficient than replacing your formula with an LLM enrichment for simple concatenation.
Is that what you were looking for?
If you need any more help with setting up your formula column or have other questions, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any other issues you’re facing?
Great, thanks
Glad I could help. Let me know if you need anything else.