Monday.com icon

Monday.com

Interact with Monday.com API

Actions6

Overview

This node operation reads formula columns from items on a specified board in Monday.com. Formula columns contain calculated values based on other columns, and this operation allows you to retrieve those computed results programmatically.

Common scenarios where this node is useful include:

  • Extracting calculated metrics or KPIs from project management boards.
  • Automating reporting workflows by fetching formula results for multiple items.
  • Integrating Monday.com formula data into other systems or dashboards.

For example, if you have a formula column calculating the total cost of tasks, you can use this node to read those totals for selected items or all items on a board, then pass that data downstream for further processing or visualization.

Properties

Name Meaning
Board The Monday.com board to work with. You select which board's items to read formula columns from.
Formula Columns Select one or more formula columns to read. If left empty, all formula columns on the board will be read.
Output Format Determines the format of the returned formula column data:
- Calculated Value (raw number, date, etc.)
- Formatted Text (as displayed in Monday.com)
- Both (value and text)
Item IDs Comma-separated list of item IDs to read formula columns from. Leave empty to read all items on the board.

Output

The output is an array of JSON objects, each representing an item with its formula column data. Each object contains:

  • item_id: The ID of the item.
  • item_name: The name of the item.
  • One property per requested formula column, named after the column title converted to lowercase with spaces replaced by underscores (or the column ID if no title). The value depends on the selected output format:
    • If "Calculated Value" is chosen, the property contains the raw calculated value (number, boolean, date string, or null).
    • If "Formatted Text" is chosen, the property contains the text as displayed in Monday.com.
    • If "Both" is chosen, the property is an object with value (raw calculated value) and text (formatted text).

Example output snippet when reading two formula columns with "Both" format:

{
  "item_id": 123456,
  "item_name": "Task A",
  "total_cost": {
    "value": 1500,
    "text": "$1,500"
  },
  "completion_percentage": {
    "value": 0.75,
    "text": "75%"
  }
}

No binary data is output by this node.

Dependencies

  • Requires a valid API authentication token credential for Monday.com.
  • Uses Monday.com API version specified in credentials or defaults to "2023-10".
  • The node relies on Monday.com's GraphQL API to fetch items and their column values.

Troubleshooting

  • Empty or missing formula column data: Ensure the selected board actually has formula columns and that the column IDs or titles are correct.
  • Invalid item IDs: If specifying item IDs, verify they exist on the board; otherwise, no data will be returned.
  • API errors or rate limits: The node may throw errors if the API token is invalid or if rate limits are exceeded. Check your Monday.com API credentials and usage.
  • JSON parsing errors: The node parses formula column values from JSON strings. Malformed data could cause errors.
  • Output format confusion: Selecting "Formatted Text" returns only display text, which might not be suitable for calculations downstream. Use "Calculated Value" or "Both" accordingly.

If the node throws an error, enabling "Continue On Fail" can help process remaining items while logging errors per item.

Links and References

Discussion