COALESCE invalid formula


Hello team,

Last week, we encountered a very unusual issue: every COALESCE applied between fields from tables within a blend is being flagged as an invalid formula.

Blend:

Error:

Additionally, although the COALESCE function does return a value, all results are coming through as unformatted timestamps.

It’s worth noting that this function was working correctly last week. I’m not sure if this behavior is related to a recent update.

Thank you in advance.