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