'Error validating formula for calculated column

I'm trying to make up a calculated column that evaluates an existing column with a CASE statement. The following code works fine:

CASE 
  WHEN Technician_Production_date IS NULL THEN 1 
  WHEN Technician_Production_date IS NOT NULL AND Technician_Review_Date IS NULL THEN 2 
  WHEN Technician_Production_date IS NOT NULL AND Technician_review_Date IS NOT NULL AND 
  Chemist_Review_Date IS NULL THEN 3 
  ELSE 4 
END

When i try to do the same statement but assign an existing column as a VARCHAR value instead as below, i get the error: "Error validating formula for (column_name)". Here is the code im trying to run:

CASE 
  WHEN Technician_Production_date IS NULL THEN CAST(Responsible_Technician_Review AS varchar) 
  WHEN (Technician_Production_date IS NOT NULL AND Technician_Review_Date IS NULL) THEN 
  CAST(Responsible_Chemist_Review AS varchar) 
  WHEN (Technician_Production_date IS NOT NULL AND Technician_review_Date IS NOT NULL AND 
  Chemist_Review_Date IS NULL)  THEN CAST(Responsible_Chemist_Approval AS varchar) 
  ELSE "Finished") 
END

What could be causing this?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source