Querying formula column data

monday Apps & Developers Feature Requests - API and Apps Framework
1

Hello, im trying to fetch items data and present it in a table. one of the coulmn i need to present is a formula column with calaulated value in it. is there some way i can get it? am i missing some trick people use to get around this problem?

thank you in advance,
Stav

2

Hi @stavYaarBar,

At this time, I’m afraid our Formula columns are currently not query-able using our V2 API.

However, I would be more than happy to forward your feedback to our Product team for consideration!

In order to see the formula in the Formula column, you can use the settings_str argument for the columns field!

1 Like
3

I see, thank you very much! i can work with the formula on the settings_str field :slight_smile:

1 Like
4

Reading the formula column is now supported via the API!

You can get the calculated value by querying the display_value field on the FormulaValue type. This field is available on API version 2025-01 and later.

Here’s an example:

query {
  boards (ids:116807194) {
    items_page (limit:50) {
      items {
        id
        column_values (ids:["mins"]) {
          ...on FormulaValue {
            display_value
          }
        }
      }
    }
  }
}

Note that querying this field does have rate limits as it’s a computationally intensive request:

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

Formula PRO on the monday.com marketplace is seamlessly integrated with this new API to supercharge your native formula columns. It also fully supports all native formula functions, so you don’t need to learn new syntax to start using Formula PRO.

With Formula PRO, you can unlock powerful features like projecting and writing results from native formula columns to other columns (including some not supported by the native formula column), as well as to mirror columns and subitems.

Additionally, Formula PRO includes 40 automation recipes, with new ones added bi-weekly.

:rocket: Formula PRO: Advanced Automations for native monday formula columns, Mirror Columns & Subitems!