When using Calculated Fields, you'll get an "invalid formula" output if the formula you've entered can't be evaluated.

Below are some common scenarios where you'll get this message:

• comparing values of different data types (e.g. comparing a string value to a number)
• applying methods/functions to incompatible data types (e.g. the .replace() method will only work with strings, not numbers)
• missing opening or closing quote/parentheses
• using unsupported functions and operators
• missing final "else" statement when using conditional logic
• not enclosing static string values with quotes
• missing required parameters when using functions