Just curious if there are plans to support querying Formula column values via API. I don’t see anything on the Roadmap board. I see another post from a year ago. Is this not on the radar? It would be extremely useful!
Hello there @jsararas!
Our team knows that this is a feature that would be beneficial to some users and it is being taken into account
Having said that, it is not something that is set for the nearest future.
I will add your vote to it!
If this is deployed, it will be posted in our changelog
Getting the calculated values is only the first step in my (experienced) opinion.
You want to be able to use the calculated data as any other data from an other column.
Most of the time it means handling it as a specific kind of data: Date, Number, People, Text, etc.
If you just get the values without that Data Type context you will still be limited, although less than today of course.
Please consider voting for this feature that explains how to achieve this:
Laurent, CRM & monday.com dev (and previously BI Analyst)
@LaurentConroux This is a real gap in the API’s capabilities. We need to be able to get the value calculated in a formula column. Why would we set up formulas that we then can’t get the results of with the API? That means we have to replicate a calculation in another platform. This issue has been brought up several times in the past several years. Any progress?
Only monday knows, but most of us are waiting for it.