Querying Formula column values

Hello there @gjones and welcome to the community!

I have added your vote for this request :grin:

In the meantime, as a workaround, you can try using an app like General Caster to cast the result of a formula to a text or numbers column, so that said result is available via API.

Of course if the request gets implemented, we will announce it here!

Thank you for the feedback!

Cheers,
Matias

Thanks @Matias.Monday ! I have looked at General Caster and Autoboost, both are cost prohibitive unfortunately, but I appreciate the suggestion :+1:t2:

Hello @gjones,

I will reply here if this gets implemented on monday’s end then!

Cheers,
Matias

This is a huge limitation. Any integrations will need to recreate the formulas in order to retrieve the data.

Hello there @david.kershaw and welcome to the community!

I hope you like it here :muscle:

I have added your vote for this request.

In the meantime, you can check out the General Caster app in our marketplace :grin:

Cheers,
Matias

Please add me vote for this as well as this is a must.

Hello there @Doka, you can vote at the top left corner of the screen!

Link not working anymore

Update on this feature request – it’s on the roadmap! We’re aiming to release formula support this year as part of our mondayDB improvements :slight_smile:

We’ll update the tag on this post once it’s released, or you can follow our Changelog to get notified in real-time.

6 Likes

Fantastic news Dipro! This really opens up a lot of possibilities.

Appreciate the team listening to the community :confetti_ball:

2 Likes

Can I know when this feature will be enabled.

Still planned for the end of the year!

3 Likes

Exciting! following for the updates when released :smiley:

Honestly I hope there is a new “formula column 2.0” as well. The existing formula functions have oddities, they have parameters switched from excel or google sheets, calculate differently than they do, output dates inconsistently - and sometimes fail to handle date localization correctly, don’t handle null values consistently with each other or with how excel or google sheets would.

I just think its a good opportunity to break with the past.

Plus, I think not having to emulate the oddities caused by formulas working on the column view layer rather than data layer, when the view layer doesn’t exist on the backend, would reduce complexity and chances of anomalous results.

Thank you for the feedback, @codyfrisch !

I will send it to the team :smile:

Hi Everyone

I am super excited to share the formula column value is now available to read using the Platform API!

This open the doors to a lot of new possibilities, such as creating brand new types of apps or extending existing ones to now also support the formula column.

Looking forward to your feedback.

Happy Coding!

2 Likes

very happy too :slight_smile: but absolutely doesn’t work … I’m using the 2025-01 version. :slight_smile:
query {
items (ids:[1720260604]) {
column_values {
… on DropdownValue {
values {
id
label
}
column {
id
}
},
… on FormulaValue {
value
__typename
id
display_value
}
}
}
}

Hi @rgrv13,

What about your query isn’t working? I copy and pasted the one you sent into my playground, replaced the item ID, and returned the display_value!

Best,
Rachel