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