This error means a formula in a Make module field contains a syntax error, references an invalid function, or receives unexpected data types. Check the formula for missing parentheses, incorrect function names, and null values from previous modules. Use Make's formula editor preview to test formulas before running the scenario.
What does "Error evaluating formula in Make" mean?
When Make shows "Error evaluating formula," it means a formula expression in one of your module's input fields could not be calculated. Make formulas use a proprietary syntax for transforming data between modules — functions like formatDate(), substring(), parseJSON(), and ifempty(). If the formula has a syntax error, references a non-existent function, or receives a data type it cannot process, evaluation fails.
This error falls under Make's DataError category, which means the scenario itself is configured correctly but the data flowing through it caused a validation failure. The error message usually includes the specific formula that failed and a hint about what went wrong, making it one of the more debuggable Make errors.
Common pitfalls include using JavaScript syntax instead of Make's own formula syntax (they are different), forgetting that Make formulas are case-sensitive, and not handling null values from previous modules. A module that sometimes returns data and sometimes returns null will cause formula errors intermittently — working fine in testing but failing in production.
Common causes
The formula has a syntax error
missing parentheses, incorrect nesting, or wrong separator characters
The formula uses a JavaScript
function name instead of Make's proprietary function (e.g., .length instead of length())
A variable from a previous module is
null or empty, and the formula does not handle null values
The formula references a function that
does not exist in Make's formula library
Data type mismatch
the formula expects a string but receives a number, date, or object
Special characters in text data (quotes, backslashes) are
not escaped, breaking the formula syntax
How to fix formula evaluation errors in Make
Click the module with the error and open the field containing the formula. Make's formula editor highlights syntax errors in red. Check for missing parentheses, incorrect function names, and unescaped special characters. Use Make's built-in formula reference (the 'fx' icon in the formula editor) to verify function names and required parameters.
For null value errors, wrap your formula in ifempty() to provide a fallback: ifempty(1.fieldName, "default value"). For data type mismatches, use explicit conversion functions like toString(), toNumber(), or parseDate(). Test your formula using Make's 'Run once' feature with sample data before enabling the scenario for production. If your scenario has complex multi-step formulas that keep breaking, RapidDev can help simplify your data transformation logic.
Prevention tips
- Always wrap mapped values in ifempty() when the source module might return null — this prevents evaluation errors on empty data
- Use Make's formula reference (fx icon) to verify function names and parameters — Make uses its own syntax, not JavaScript
- Test formulas with 'Run once' using both typical and edge-case data before enabling the scenario for automated runs
- Escape special characters in text formulas using the replace() function to prevent syntax-breaking characters from causing errors
Still stuck?
Copy one of these prompts to get a personalized, step-by-step explanation.
My Make (Integromat) scenario shows 'Error evaluating formula' on a formatDate() function. The date sometimes comes as null from the trigger. How do I handle null dates in Make formulas?
Fix my Make formula to handle null values from the previous module and convert the date to YYYY-MM-DD format safely.
Frequently asked questions
Why does Make show "Error evaluating formula" on a formula that worked before?
The formula likely depends on data from a previous module that sometimes returns null or a different data type. Add ifempty() wrappers and type conversions to handle variable data.
Does Make use JavaScript syntax for formulas?
No. Make has its own formula syntax that is similar to but different from JavaScript. For example, string length uses length(string) not string.length. Check Make's formula reference for the correct syntax.
How do I test a Make formula before running the full scenario?
Use the 'Run once' button to execute the scenario with sample data. The formula editor also shows a preview of the formula output when you hover over it, though this only works with data from the most recent run.
Does the formula error consume Make operations?
The error stops execution at the module where the formula fails. Operations consumed by modules that ran before the error are still counted. The failed module and subsequent modules do not consume operations.
How do I handle null values in Make formulas?
Use the ifempty() function: ifempty(value, fallback). For example, ifempty(1.date, now) uses the current date if the source date is null. You can also use the if() function for more complex null-checking logic.
Talk to an Expert
Our team has built 600+ apps. Get personalized help with your issue.
Book a free consultation