function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
mikeafter6mikeafter6 

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) 
MarkSilberMarkSilber
You will be able to use the TEXT(picklistfieldname) function in the upcoming Summer '09 release which will make this much easier.