Formula display_value returns nothing in API v2025-01?

[haseeb1431 (haseeb1431@gmail.com)]

I have a query which works perfectly fine but as soon as I add Display_value to get the formula values, it returns null as results. the following is the query that gives me all the required data.

query { boards (ids: [$board_id]) { id name

items_page(limit:5){ 
  cursor 
  items {
    id name 
    column_values{
      id type value 
      ... on TextValue { text} 
      ... on DateValue { time date } 
      ...on LongTextValue { text value } 
      ... on NumbersValue {number id symbol direction}  
      ... on FormulaValue { value  } 
      column{ title}

}}} } }"

However, I want to see display_value for formulas so as soon as I update the query to update Formula value, it starts to return nothing. It seem like a bug on the server side.

      ... on FormulaValue { display_value  } 

[Matias.Monday (Matias)]

Hello there @haseeb1431 and welcome to the community!

I hope you like it here

Our team is aware of this issue and working on a fix that should be deployed this week

Would you be able to please try this starting on Wednesday (15.01.2025)? It should be resolved by then. If you see this not working then, please mention me here!

Cheers,
Matias

[haseeb1431 (haseeb1431@gmail.com)]

Thanks for fixing it and taking care of it. Now I am getting the following response.

is there a limit to get the number of column with formula because otherwise query is working fine? We have around 100 columns

{
    "data": {
        "boards": [
            null
        ]
    },
    "errors": [
        {
            "message": "Too many formula columns have been requested. Please reduce the number of columns.",
            "path": [
                "boards",
                0,
                "items_page",
                "items",
                0,
                "column_values",
                12,
                "display_value"
            ],
            "extensions": {
                "status_code": 400,
                "code": "TOO_MANY_FORMULA_COLUMNS_REQUESTED"
            }
        }
    ],
    "extensions": {
        "valueCompletion": [
            {
                "message": "Cannot return null for non-nullable field FormulaValue.display_value",
                "path": [
                    "boards",
                    0,
                    "items_page",
                    "items",
                    0,
                    "column_values",
                    12
                ]
            },
            {
                "message": "Cannot return null for non-nullable array element of type ColumnValue at index 12",
                "path": [
                    "boards",
                    0,
                    "items_page",
                    "items",
                    0,
                    "column_values",
                    12
                ]
            },
            {
                "message": "Cannot return null for non-nullable field Item.column_values",
                "path": [
                    "boards",
                    0,
                    "items_page",
                    "items",
                    0,
                    "column_values"
                ]
            },
            {
                "message": "Cannot return null for non-nullable array element of type Item at index 0",
                "path": [
                    "boards",
                    0,
                    "items_page",
                    "items",
                    0
                ]
            },
            {
                "message": "Cannot return null for non-nullable field ItemsResponse.items",
                "path": [
                    "boards",
                    0,
                    "items_page",
                    "items"
                ]
            },
            {
                "message": "Cannot return null for non-nullable field Board.items_page",
                "path": [
                    "boards",
                    0,
                    "items_page"
                ]
            }
        ]
    }
}

Also, may be I am not aware, but I am not sure if there is a way to filter columnValues and say give me first 50 columns and then give me rest of them.

[GCavin (Gilles Cavin - Reinventing Formulas in monday.com)]

Hi @haseeb1431,

There is a limit of 5 formula columns per request.

[richard.ekstrand (RickX)]

display_value is not returning values for formulas using API “2025-04”

[rachelatmonday (Rachel)]

Hi @richard.ekstrand,

Can you send your query please? I ran the query below, and it successfully returned the formula in the display_value field.

{
  items(ids: 123456) {
    column_values {
      ... on FormulaValue {
        display_value
      }
    }
  }
}

Best,
Rachel

[jk193 (Jake K)]

@rachelatmonday
Not working still for me today. For example, this query:

query {
  items (ids: [9105478229]) {
    name
    column_values {
      id
      column {
        title
      }
      value
    }
  }
}

should return a value of “5” but instead is null for the column with id “formula_mkqs51dt” and title “Length in Mins”. (It’s a column calculating number of minutes between two date/time cols)

[dvdsmpsn (David @ David Simpson Apps)]

@jk193 try adding this bit?

@rachelatmonday

      ... on FormulaValue {
        display_value
      }