# 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 --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://formulapro.shadebridge.com/formula-pro/appendix/errors-and-troubleshooting.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.