+ Start a Discussion
AnonymouseAnonymouse 

How to Lookup to Picklist Field From Another Custom Object

Hello,

I currently have a custom object (example: customObject__c). This object is related to another custom object (example: customObject2__c). I would like to have my custom object have a new field lookup to a picklist field from the second custom object.

I was thinking about approaching this as a formula field and then have it return text. I'm not sure if I'm going about this the wrong way.

This is what I have so far:
TEXT(customObject2__r.customfield__c)
How may I approach this? Should I be doing this a different way? What are my options?

Sincerely,
Jackie
Prashant Pandey07Prashant Pandey07
Yes..that's the correct way to return picklist value as text.

Note- You cannot use TEXT() on multi-select picklists. Multi-select picklists are not recommended in formula fields.

--
Thanks,
Prashant
 
Ramana PillaRamana Pilla
Hi,

I used same formula field, but it returned recordID value instead of real picklist value. How do i get the picklist value ? Both the fields are picklist. Could you please suggest on this.

Thanks
Karthikeyan VKarthikeyan V
Hi, Are you found any solution ? Is yes, please post the solution.