Fixing Error Evaluating Formula for Certain Records in Data

·Jun 26, 2025 10:52 PM·

got "Error evaluating Formula" for some of the records while most of them have good outputs, Manually checked inputs they are perfectly fine/similar to other records that worked

2 comments

· Sorted by Oldest

Clay
APP
·
·
This error typically occurs when your formula is expecting data that doesn't exist in some records. Try refreshing your browser using Cmd/Ctrl + Shift + R first, as this often resolves the issue. If that doesn't work, the formula might be assuming all rows have certain data. Add conditional logic to your formula like "if {{column_name}} exists..." so it only processes data when it's available. Remember that AI formulas may need iteration. You can adjust your prompt or modify the generated code to handle these edge cases better.
Sources: AI Formulas + Conditional Runs [Automated Inbound] - Clay University AI Formulas + Conditional Runs [Automated Outbound] - Clay University
Daniela D.
·
·
Hey there! Apologies for the delay. Happy to help✨. Could you share your table url and the column (name) that has this issue? We'll review this.

Clay
APP
·
·
This error typically occurs when your formula is expecting data that doesn't exist in some records. Try refreshing your browser using Cmd/Ctrl + Shift + R first, as this often resolves the issue. If that doesn't work, the formula might be assuming all rows have certain data. Add conditional logic to your formula like "if {{column_name}} exists..." so it only processes data when it's available. Remember that AI formulas may need iteration. You can adjust your prompt or modify the generated code to handle these edge cases better.
Sources: AI Formulas + Conditional Runs [Automated Inbound] - Clay University AI Formulas + Conditional Runs [Automated Outbound] - Clay University
Daniela D.
·
·
Hey there! Apologies for the delay. Happy to help✨. Could you share your table url and the column (name) that has this issue? We'll review this.