Common Errors and Troubleshooting

This guide covers the most common errors you may encounter when using Formula Pro, with explanations and steps to resolve them.

---

Formula Errors

These errors appear when a formula fails to evaluate correctly.

#NULL!

Meaning: The formula refers to an empty intersection between two ranges.

Possible causes:

• Incorrect range references

• Column references that don't overlap as expected

Resolution:

• Check that your column references are correct

• Verify the referenced columns exist and contain data where expected

• For lookup-style formulas, ensure the ranges are properly defined

---

#DIV/0!

Meaning: The formula is trying to divide by zero.

Possible causes:

• A divisor column is empty or zero

• A calculation produces zero before division

Resolution:

• Use IF or IFERROR to guard against division by zero, e.g.:

  IF({item's Divisor} = 0, 0, {item's Numerator} / {item's Divisor})

• Or: IFERROR(DIVIDE({item's Numerator}, {item's Divisor}), 0)

• Ensure the divisor column has valid values before the formula runs

---

#VALUE!

Meaning: A value in the formula is the wrong type — for example, text was used where a number was expected.

Possible causes:

• Passing text to a function that expects a number (e.g., SUM, DATEVALUE)

• Passing a number to a function that expects text

• Invalid date or time format

• Result format doesn't match the destination column type (e.g., projecting text to a Number column)

Resolution:

• Use VALUE() to convert text to numbers where needed

• Use TEXT() or CONCATENATE() for string output

• For dates, use DATEVALUE() or ensure YYYY-MM-DD format

• Check that the formula output matches the destination column type (see Supported Column Types)

---

#REF!

Meaning: The formula references a column that no longer exists or is unavailable.

Possible causes:

• A column was deleted or renamed after the automation was set up

• The column ID in the recipe no longer exists

• Wrong board or item context

Resolution:

• Open your automation settings and reselect the trigger and destination columns

• Verify the board and columns still exist and you have access

• Re-save the recipe to refresh column references

---

#NAME?

Meaning: The formula contains an unrecognized function name.

Possible causes:

• Typo in function name (e.g., CONCATENAT instead of CONCATENATE)

• Function not supported in Formula Pro

• Incorrect spelling or casing (function names are case-insensitive, but must be spelled correctly)

Resolution:

• Check the Formula Pro Custom Functions and Excel Functions for valid names

• Fix any typos in function names

• Ensure you're not using Excel functions that are not implemented (e.g., LAMBDA, FILTER, XLOOKUP)

---

#NUM!

Meaning: The formula produced a number that is too large, too small, or otherwise invalid.

Possible causes:

• Overflow (e.g., very large exponentiation)

• Invalid input to math functions (e.g., negative number to SQRT)

• Result outside valid range for the column type

Resolution:

• Add bounds checking with IF or MIN/MAX

• Validate inputs before passing to functions like SQRT, LN, LOG

• Use IFERROR to provide a fallback value

---

#N/A

Meaning: A required value was not found. Often means a lookup returned no match.

Possible causes:

• VLOOKUP, MATCH, or similar function found no matching value

• Referenced column is empty

• Lookup range doesn't contain the search value

Resolution:

• Use IFNA or IFERROR to handle no-match cases, e.g.:

  IFNA(VLOOKUP(...), "Not found")

• Verify the lookup value exists in the source range

• Check for extra spaces or formatting differences

---

#ERROR!

Meaning: The formula could not be evaluated. Generic syntax or evaluation failure.

Possible causes:

• Syntax error (missing parenthesis, invalid operator)

• Invalid expression structure

• Unsupported or malformed formula

Resolution:

• Check for matching parentheses and brackets

• Verify all function arguments are correctly separated by commas

• Simplify the formula and test in parts

• See "Formula evaluation errors" below for more specific cases

---

#GETTING_DATA

Meaning: Data is still loading for one or more columns used in the formula.

Resolution:

• Wait a moment and try again

• If it persists, check that the trigger column and any referenced columns are loading correctly

• Verify board and column access

---

Formula Evaluation Errors

These are classified evaluation errors with more specific messages.

Formula syntax error

Meaning: The formula has invalid syntax — unexpected operator, token, character, or missing parenthesis.

Resolution:

• Check for unmatched ( and )

• Ensure operators (+, -, *, /) are used correctly

• Verify string literals are properly quoted with "..." or '...'

• Remove any invalid characters or extra commas

---

Unknown column or variable

Meaning: The formula references a column or variable that is not defined in the current context.

Resolution:

• Verify column names match exactly (including spaces)

• Ensure you've selected the correct columns in the recipe configuration

• For mirror/subitem recipes, confirm the column exists in the expected board context

---

Wrong number of arguments

Meaning: A function was called with too many or too few arguments.

Resolution:

• Check the function's signature in the function reference

• Ensure required arguments are provided

• Remove extra commas or add missing arguments

---

Formula math error

Meaning: A mathematical operation failed (overflow, out of range, infinite result).

Resolution:

• Avoid operations that can overflow (e.g., very large exponents)

• Use IFERROR to catch and handle these cases

• Validate inputs before passing to math functions

---

Field and Column Errors

Board not found

Meaning: The board could not be found.

Resolution:

• Verify the board ID exists and you have access

• Check that the board wasn't archived or deleted

• Reconnect the integration if board access has changed

---

Column not found

Meaning: The destination (or source) column could not be found.

Resolution:

• Open automation settings and reselect the column

• Confirm the column exists on the board and hasn't been deleted or renamed

• For mirror columns, ensure the linked board and column are correctly configured

---

Column type not supported

Meaning: The selected column type is not supported for this operation.

Resolution:

• Choose a compatible column type (see Supported Column Types)

• For some recipes, only certain column types (e.g., Text, Numbers, Date, Status) are supported

• Use a different recipe or column if needed

---

Invalid column value

Meaning: The value could not be saved to the destination column because it is incompatible with the column type.

Resolution:

• Ensure the formula output matches the destination column format:

  • Status: Exact status label

  • Date: YYYY-MM-DD

  • Timeline: YYYY-MM-DD+YYYY-MM-DD

  • Email: email:Display Name

  • Link: url:Label

• Use TEXT(), FORMAT_DATE(), or similar to format the output correctly

---

Invalid value — label does not exist

Meaning: You're trying to set a Status or Dropdown value that doesn't exist in the column's options.

Resolution:

• Use SWITCH or IF to map your logic only to existing labels

• Add the label to the column's options in monday.com, or

• Change the formula to output a label that already exists

---

Missing permission

Meaning: You do not have permission to update this board or column.

Resolution:

• Check your monday.com board and column permissions

• Ensure the Formula Pro app has the required scopes (usually granted during installation)

• Ask a board admin to grant you edit access

---

Account and Subscription Errors

No app subscription found

Meaning: No active Formula Pro subscription was found for your account.

Resolution:

• Subscribe to Formula Pro from the monday.com marketplace or app settings

• Verify your subscription is active and not expired

• Contact support if you believe you have an active subscription

---

Operation limit exceeded

Meaning: You've reached the operation limit for your current plan.

Resolution:

• Upgrade your Formula Pro plan for more operations

• Reduce the number or frequency of automations

• Check your usage in the app settings

---

Authorization failed

Meaning: The connection to monday.com has expired or is invalid.

Resolution:

• Go to Integrations → Formula PRO Automation → Settings

• Disconnect and reconnect your monday.com account

• Grant all requested permissions when reconnecting

---

monday.com API Errors

API temporarily blocked

Meaning: monday.com has temporarily rate-limited or blocked the request.

Resolution:

• Wait a few minutes and try again

• Reduce automation frequency if you have many recipes

• Contact support if this persists

---

Resource not found

Meaning: The requested item, group, or board could not be found.

Resolution:

• Verify the item, group, or board ID exists

• Check that you have access to the resource

• Re-save your automation to refresh IDs

---

Item name too long

Meaning: The item name exceeds monday.com's limit (typically 1–255 characters).

Resolution:

• Shorten the formula output used for the item name

• Use LEFT() or MID() to truncate if needed

• Ensure the formula doesn't produce unexpectedly long strings

---

Setup and Configuration Errors

No access token found

Meaning: The app cannot authenticate with monday.com.

Resolution:

• Reconnect your account in the Formula Pro settings

• Clear browser cache and try again

• Reinstall the app if the issue persists

---

No subitem board found

Meaning: The board does not have subitems enabled, but the recipe requires them.

Resolution:

• Enable subitems on the board in monday.com

• Or choose a different recipe that doesn't require subitems

---

No formula column ID found

Meaning: The formula column trigger could not find a valid formula column.

Resolution:

• Ensure the board has a formula column

• Reselect the formula column in the recipe configuration

• Use "When column changes, execute formula" instead of "project formula column" if the setup fails

---

No supported columns for webhook / formula column trigger

Meaning: Formula Pro does not support formula columns or groups as dependencies for certain triggers.

Resolution:

• Use the recipe "When column changes, project result of calculated formula to column" (or its variations) instead

• Ensure the formula column references supported column types (not other formula columns or groups)

---

No relation column found for mirror column

Meaning: The mirror column is not properly configured with a linked board and column.

Resolution:

• Configure the mirror column in monday.com with a linked board and column

• Ensure the relation is set up before adding the automation

---

Contact Support

If you've tried the resolutions above and the issue persists, we're here to help.

Email

[email protected]

When contacting support, please include:

• A brief description of the issue

• The recipe type and configuration (without sensitive data)

• The exact error message you see

• Steps to reproduce, if possible

• Your monday.com account email (if relevant)

What to expect

• We typically respond within 1–2 business days

• For urgent issues (e.g., production outages), mention "Urgent" in the subject line

• We may ask for additional details or screenshots to diagnose the problem

Self-service

• Review the Formula Pro Custom Functions and Recipe Examples

• Check Supported Column Types for compatibility

• Ensure your monday.com and Formula Pro accounts are in good standing