No matter what formula is within a calculated field, the field returns “invalid formula” and will not calculate further, such as with dates.
for example COALESCE(Date(Table 1), Date (Table 2)) returns “invalid formula” as a TEXT field, even when you put a “parse_date()” in there.
This is been happening all week. PLEASE FIX