+ Start a Discussion
lil_rangerlil_ranger 

formula field help

How would I update this formula field to display more than one choice?  The Type__c field is a multi-picklist, so I need this formula field to reflect that.  Any help would be greatly appreciated.  It currently only displays one choice even though the type field on the account I'm looking at displays 2.

 

IF(INCLUDES(Type__c,"Consultant"),"Consultant", 
IF(INCLUDES(Type__c,"Reseller"),"Reseller", 
IF(INCLUDES(Type__c,"End User"),"End User","")))

 

Best Answer chosen by Admin (Salesforce Developers) 
Steve MolisSteve Molis

You probably want to throw a delimeter or a Line Break on there like this

 

IF(INCLUDES(Type__c,"Consultant"),"Consultant" + BR(), NULL) + 
IF(INCLUDES(Type__c,"Reseller"),"Reseller", + BR(), NULL) + 
IF(INCLUDES(Type__c,"End User"),"End User", NULL)



IF(INCLUDES(Type__c,"Consultant"),"Consultant" + " ; ", NULL) + 
IF(INCLUDES(Type__c,"Reseller"),"Reseller", + " ; ", NULL) + 
IF(INCLUDES(Type__c,"End User"),"End User", NULL)

 

All Answers

CheyneCheyne

You could use the string concatenation operator, instead of nested IF statements. Your formula would look like this:

 

IF(INCLUDES(Type__c,"Consultant"),"Consultant","") & IF(INCLUDES(Type__c,"Reseller"),"Reseller","") & IF(INCLUDES(Type__c,"End User"),"End User","")

Steve MolisSteve Molis

You probably want to throw a delimeter or a Line Break on there like this

 

IF(INCLUDES(Type__c,"Consultant"),"Consultant" + BR(), NULL) + 
IF(INCLUDES(Type__c,"Reseller"),"Reseller", + BR(), NULL) + 
IF(INCLUDES(Type__c,"End User"),"End User", NULL)



IF(INCLUDES(Type__c,"Consultant"),"Consultant" + " ; ", NULL) + 
IF(INCLUDES(Type__c,"Reseller"),"Reseller", + " ; ", NULL) + 
IF(INCLUDES(Type__c,"End User"),"End User", NULL)

 

This was selected as the best answer