Have Calculated Field Show Label Instead of Value for Dropdown Choices
On dropdown lists, we use both the Label + Value for a choice. We then use calculated fields to consolidate the choices across multiple dropdowns; however, since we used both the Label + Value, what returns in the calculated field is the Value (which isn't the user friendly name). Does anyone have any tips for getting the calculated field to pickup the Label here instead of Value?
We do use IF statements as the workaround, but it is cumbersome when there are a lot of choices / maintenance.
