I'm having the following issue, would highly appreciate any help regarding it:
On the Case object I have field__1 (of type picklist). This field is mandatory upon case closure but can be populated before to. It's populated sometimes by the user and at other times automatically. In certain cases I want to update this field based on another field (field__2 - type picklist), by using a workflow. The scenario is: When a case is closed and the field__1 is not empty Check field__2: If field__2 = A or B -> set field__1 to be X If field__2 = C -> set field__1 to be Y If field__2 = D -> set field__1 to be Z
The formula is in the WF, the value (X, Y, Z) to update field__1 is decided in the WF - but how can I transfer this value to the field update action? Is it possible to pass it as a variable somehow? Because the field is picklist I don't have the option "Use a formula to set the new value" - but this is what I need...