function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

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?



, '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.