Unable to get formula column values via API

[dinithij (Din Jaz)]

Hi All

I am working on building a small monday.com app and trying to retrieve formula column values through API. I get ‘null’ as the value for all formula type columns.

Questions,

1. Is it possible to get formula type column values via API?
2. If it is not possible, Is there any way I can get the used formula, for me to do the calculation on client side?

Thanks
Dinithi

[PolishedGeek (Polished Geek | Platinum Partner)]

Hi @dinithij - The API will not give you dynamic results for things like formula and progress columns. You’ll need to pull in the column settings and generate the values on your end from what you find in the settings.

We built an app that uses both formula and progress columns to prioritize cards on a board view, and @Spunkie may be able to add more context as well. It will take more coding on your end to reproduce the dynamic functionality.

Perhaps if we’re lucky the next version of the API will include dynamic values.

[dipro (Dipro Bhowmik)]

@dinithij - you can also check out this post for a discussion on how to do this:

Mutation: create_column for a 'formula' type column

Hey everyone! Just wanted to follow up on this – @PolishedGeek is right! While our API does not support reading the calculated value of a formula column, you can use the settings_str field to get the config of the formula column. This config contains the raw formula. Since the formula is almost identical to the Excel syntax, you should be able to pipe this into a formula parser of your choice. Here’s a simple example of the process: Get all the column values from the board Get the formula i…

[azmat (azmatullah)]

we can create subitem colmn by API??

[AlexSavchuk]

@azmat

Thanks for asking! At this time, you will not be able to create sub-item columns via the API, just like with Connect Board columns.

I would recommend raising this question as a separate topic in the future, as your query doesn’t quite seem to be related to the main topic of the discussion here. I hope that makes sense

-Alex

[dipro (Dipro Bhowmik)]

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

[hellotimi (David Kalu (Formula PRO - Use formula column results in automations!))]

Formula PRO on the monday.com marketplace is fully integrated with this new API to elevate your native formula columns. It supports all native formula functions, so you won’t need to learn new syntax to use Formula PRO.

Unlock powerful capabilities with Formula PRO, including projecting results from native formula columns to other columns (even those not supported by the native monday formula column), as well as to mirror columns and subitems.

Plus, Formula PRO comes with 40 automation recipes, with new ones added every two weeks.

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