Unable to get formula column values via API

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

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.

1 Like

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

we can create subitem colmn by API??

@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 :slight_smile:

-Alex

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

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.

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