You need to sign in to do that
Don't have an account?
lil_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","")))
You probably want to throw a delimeter or a Line Break on there like this
All Answers
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","")
You probably want to throw a delimeter or a Line Break on there like this