Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
dinesh abcdinesh abc 

how to concatinate picklist value and multipicklist value that will be auto populated in a field

i have source pick list contains source 1,source 2
multi picklist contains mps1,mps 2 i want to show in one field
Nubes Elite Technologies Pvt. LtdNubes Elite Technologies Pvt. Ltd
Hello Dinesh,

You can try this :
IF(INCLUDES( Multi_Picklist_1__c , " mps1"), "source1", NULL)  + BR() + 
IF(INCLUDES( Multi_Picklist_2__c , " mps2"), "source2", NULL)  

Thank You,
www.nubeselite.com
Development | Training | Consulting

Please mark this as solution if your problem is solved.