Show the result of a formula in calendar view

Hey @bechstein
You need to use an actual Date column.
If you need to calculate a date based on a formula, you can use the General Caster app for monday.

Hello there @bechstein

The formula column’s result is not available via API (used by views).

You can either use an app (Like General Caster) to do this for you (cast the result in a different column type and then use that column’s result), or you can get the formula’s structure and then query for the values of the columns that are involved in the formula, perform the proper calculations on your end and then send the result via API to a column.

To do this, you would start with a query like this one:

{
  boards(ids: 1234567890) {
    columns(ids: "formula") {
      settings_str
    }
  }
}

I have to say the first option (an app from the marketplace) is much easier to implement.

Let me know if you have any other questions!

Cheers,
Matias