Reference
Apps DocsCommunity

Formula

Learn how to read the formula column on monday boards usin gthe platform API

The formula column calculates anything from simple mathematic equations to complex formulas. You can read the formula column via the API, but you currently cannot filter, update, or clear it.

Read the formula column

You can query the formula column using the column_values object that enables you to return column-specific subfields by sending a fragment in your query. Values for the formula column are of the FormulaValue type. 

query {
  items (ids:[1234567890, 9876543210]) {
    column_values {
      ... on FormulaValue {
        value
        id
        display_value
      }
    }
  }
}

Fields

FieldDescription
column Column!The column the value belongs to.
id ID!The column's unique identifier.
text StringReading calculated values is not supported, so this field will return null.
type ColumnType!The column's type.
value JSONReading calculated values is not supported, so this field will return null.
display_value StringThe formula column's content. Only available in API versions 2025-01 and later. Subject to the following limits:

  • Does not support formulas with mirror columns
  • Up to 10,000 formula values per minute
  • Maximum of five formula columns in one request

    • Workaround to read a column's formula (versions 2024-10 and earlier)

    While the FormulaValue implementation doesn't allow you to read the formula in the column or its calculated values, you can query the column's settings_str to return the formula itself as JSON.

    Sample query

    query {
  boards (ids:1234567890) {
    columns (ids: "formula") {
      settings_str
    }
  }
}

    Sample response

    {
  "data": {
    "boards": [
      {
        "columns": [
          {
            "settings_str": "{\"formula\":\"ADD_DAYS({date_1},15) \"}"
          }
        ]
      }
    ]
  },
  "account_id": 12345678
}

    📘

    Join our developer community!

    We've created a community specifically for our devs where you can search through previous topics to find solutions, ask new questions, hear about new features and updates, and learn tips and tricks from other devs. Come join in on the fun! 😎