The Requirement: When the user selects a value in a picklist field, a formula field should store a numerical value.
The Problem: The formula I have written ALWAYS returns the value 0, regardless of the picklist value selected. See attached screenshots for proof of the 1) picklist values and 2) the record I am testing with.
I have no idea what I'm doing wrong. I've done this before several times and consulted the documentation. By all accounts, this formula should be working.
I have tried variations of this formula using TEXT(), IF() and ISPICKVAL(). None of them seem to work -- they all return the exception case ("0").
Here is my formula:
CASE(ampi__Potential_Impact__c, "Almost no impact", 1, "Minor impact", 2, "Moderate", 3, "Significant impact", 4, "Cause early termination or major problems", 5, 0)