Hi @Helen and maybe at one point @rob,

This I actually got to bypass somehow, so this problem is solved now.

I do have another Problem.

Forget what I said before, I have new formulas etc.

I will need to explain it again:

We are a news company, publishing different news papers every day.

Product 1 is published every day, produced the day before.

Product 2 is published every sunday and wednesday, produced thursday and monday.

Now in my board I have the following (for this topic relevant) columns:

{Product} - A dropdown. “Product 1” and “Product 2” are the options.

{Release} - Date column for the release date.

{Production} - Date column for the production date.

Now I have different Formula columns:

{Weekday} - `FORMAT_DATE({Release}, "dddd")`

{Text} - a text column used for a GC-Integration to bypass the problem in my comment before.

{Formula 1} -

`SWITCH({Text}, "Wednesday", FORMAT_DATE(SUBTRACT_DAYS({ET}, 2)), "Sunday", FORMAT_DATE(SUBTRACT_DAYS({ET}, 3)), "Monday", FORMAT_DATE(SUBTRACT_DAYS({ET}, 1)), "Tuesday", FORMAT_DATE(SUBTRACT_DAYS({ET}, 1)), "Thursday", FORMAT_DATE(SUBTRACT_DAYS({ET}, 1)), "Friday", FORMAT_DATE(SUBTRACT_DAYS({ET}, 1)), "Saturday", FORMAT_DATE(SUBTRACT_DAYS({ET}, 1)))`

{Formula 2} -

`SWITCH({Product}, "Product 2", {Formula 1}, "Product 1", FORMAT_DATE(SUBTRACT_DAYS({Release}, 1)))`

Now my General Caster Integrations:

"When any column changes, perform “Weekday” and cast result to “Text”,

"When any column changes, perform “Formula 2” and cast result to “Production”.

The first integraton works fine.

The second one does not.

It casts the dates of Formula 2 for “Product 1” but not for “Product 2”, it is an invalid date.

I also tried casting it into a new text column, but it only casts “Product 1” and for “Product 2” nothing at all, not even “invalid date”.

Here I tried to recreate the problem for you to see and GC decided to cast one correctly, but the other one is still “invalid date”.

Why cant General Caster just cast what is in the Formula 2 column? @rob