Apex Code Development You need to sign in to do that
Don't have an account?
mikeafter6 Using picklist in Formula -- How do I get just the value of the picklist field without hard-coding
I have a picklist called 'Relationship'. Formula editor doesn't return a value. I get the error 'use ISPICKLIST or CASE to work with picklists'.
I'm forced to use CASE and hard-code the choices. Is there an easier way?
CASE(Relationship__c
, 'Aunt', 'Aunt'
, 'Best Friend', 'Best Friend'
, 'Boyfriend', 'Boyfriend'
, 'Daughter', 'Daughter'
, '< value missing >'
)
Best Answer chosen by Admin (Salesforce Developers) You will be able to use the TEXT(picklistfieldname) function in the upcoming Summer '09 release which will make this much easier.