Show the result of a formula in calendar view

Hi,

based on a start date I used a formula to calculate a ‘follow up date’. With FORMAT_DATE I did the formating. But the column is not provided in den calendar view. I guess monday does not accept the formula as a date field.

Any idea how I get the result of the formula into a date automatically?

Cheers

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