Sign Up ›

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

how to call Multiselect picklist value to formula field

How can i create a formula field where it sholud get value from a multiselectpicklist.

 

Any help!!

Best Answer chosen by Admin (Salesforce Developers) 
Navatar_DbSupNavatar_DbSup

Hi,


You have to use includes method inside the formula while working on multipicklist.

 

Try the below code as reference:
if( INCLUDES(Multipicklist__c , ‘abc') ,’abc','1') + ';'+
if( INCLUDES(Multipicklist __c , xyz') ,’xyz’,'2')

 

Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved. 

All Answers

Navatar_DbSupNavatar_DbSup

Hi,


You have to use includes method inside the formula while working on multipicklist.

 

Try the below code as reference:
if( INCLUDES(Multipicklist__c , ‘abc') ,’abc','1') + ';'+
if( INCLUDES(Multipicklist __c , xyz') ,’xyz’,'2')

 

Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved. 

This was selected as the best answer
streetstreet

Thanks Jain, i was looking the same got it, Used as per my requirement.