Hey everyone! Just wanted to follow up on this – @PolishedGeek is right!
While our API does not support reading the calculated value of a formula column, you can use the settings_str field to get the config of the formula column.
This config contains the raw formula. Since the formula is almost identical to the Excel syntax, you should be able to pipe this into a formula parser of your choice.
Here’s a simple example of the process:
- Get all the column values from the board
- Get the formula in a given formula column
- Replace the references to {columns} with the values of the column
- Calculate the formula result
I don’t have specific example code for this workaround, but I wanted to chip in and validate @PolishedGeek’s suggestion!