> For the complete documentation index, see [llms.txt](https://formulapro.shadebridge.com/formula-pro/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://formulapro.shadebridge.com/formula-pro/appendix/errors-and-troubleshooting.md). # 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](/formula-pro/appendix/column-types.md)) *** ### #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](https://github.com/ifeanyidavid/formulapro/blob/main/docs/appendix/reference/custom-functions-overview.md) and [Excel Functions](https://github.com/ifeanyidavid/formulapro/blob/main/docs/appendix/reference/excel-functions.md) 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](https://github.com/ifeanyidavid/formulapro/blob/main/docs/appendix/reference/custom-functions-overview.md) * 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](/formula-pro/appendix/column-types.md)) * 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 **** 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](https://github.com/ifeanyidavid/formulapro/blob/main/docs/appendix/reference/custom-functions-overview.md) and [Recipe Examples](https://github.com/ifeanyidavid/formulapro/blob/main/docs/appendix/reference/recipe-examples.md) * Check [Supported Column Types](/formula-pro/appendix/column-types.md) for compatibility * Ensure your monday.com and Formula Pro accounts are in good standing