+ Start a Discussion
Query UserQuery User 

Multiple Picklist value into Formula(Text)



Can any one please help in populating Multiple picklist value into a Formula(Text) field


Thanks  in advance

:) :) :) :) :):) :) :) :) :)

You have to write if statement for all possible multi select picklist options


Lets say here we have a multi select picklist field called Mutiple on account with options like one, two, three, four, five and I want to show their field values on opportunity then we have to write five if statements each for multi select picklist option. 


IF(INCLUDES(Account.Multiple__c, "one"),"one", "")&"; "&IF(INCLUDES( Account.Multiple__c, "two"),"two","")&"; "&IF(INCLUDES( Account.Multiple__c, "three"),"three", "")&"; "&IF(INCLUDES( Account.Multiple__c, "four"),"four", "")&"; "&IF(INCLUDES( Account.Multiple__c, "five"),"five", "")

Margaret BraunMargaret Braun
This works kind of, it brings back alot of ; any idea on how to get rid of them?