I tried this, but I get an error message.
TEXT( Opportunity__r.CPC__c )
Error msg:
CPC is a multi-select picklist field. Multi-select picklist fields are only supported in certain functions.
Thanks @JackieT
you could try something like this:IF(INCLUDES( Multi_Picklist_1__c , "A"), "A", NULL) + BR() +
IF(INCLUDES( Multi_Picklist_1__c , "B"), "B", NULL) + BR() +
IF(INCLUDES( Multi_Picklist_1__c , "C"), "C", NULL)
actually this one might be a little better looking (not much) IF(INCLUDES( Multi_Picklist_1__c , "A"), "A" + BR(), NULL) +
IF(INCLUDES( Multi_Picklist_1__c , "B"), "B" + BR() , NULL) +
IF(INCLUDES( Multi_Picklist_1__c , "C"), "C", NULL)
Here's an updated version (thanks to @DeepakA) I found that Report and Dashboard Charts gack on the BR() tags, so I replaced them with the SFDC semi-colon delimiter. SUBSTITUTE(
IF(INCLUDES(Account__r.F-ingMulti_Picklist__c, "Multi"), "Multi ;", NULL) +
IF(INCLUDES(Account__r.F-ingMulti_Picklist__c, "Picklist"), "Picklist ;", NULL) +
IF(INCLUDES(Account__r.F-ingMulti_Picklist__c, "Fields"), "Fields ;", NULL) +
IF(INCLUDES(Account__r.F-ingMulti_Picklist__c, "Suck"), "Suck ;", NULL) + ".", ";.", NULL)
Here you go: How do I create a formula that shows the value(s) of a multi-select picklist?
We need to create a formula field on a child object that displays all of the selected values from a multi-select picklist on the parent object.
To achieve this result, you can create a formula using syntax like the example below.
IF ( INCLUDES ( parent.multipicklist__c , "Value 1" ), "Value 1; ",null ) &
IF ( INCLUDES ( parent.multipicklist__c , "Value 2" ), "Value 2; ",null ) &
IF ( INCLUDES ( parent.multipicklist__c , "Value 3" ), "Value 3; ",null ) &
IF ( INCLUDES ( parent.multipicklist__c , "Value 4" ), "Value 4; ",null ) &IF ( INCLUDES ( parent.multipicklist__c , "Value 5" ), "Value 5; ",null )
did you try using?
TEXT(Opportunity__r.Project_State__c)
orCASE(Opportunity__r.Project_State__c ,
"AK" , "AK",
"AL" , "AL",
"AR" , "AR",
"AZ" , "AZ",
"CA" , "CA",
"CO" , "CO",
"CT" , "CT",
"DE" , "DE",
"FL" , "FL",
"GA" , "GA",
"HI" , "HI",
"IA" , "IA",
"ID" , "ID",
"IL" , "IL",
"IN" , "IN",
"KS" , "KS",
"KY" , "KY",
"LA" , "LA",
"MA" , "MA",
"MD" , "MD",
"ME" , "ME",
"MI" , "MI",
"MN" , "MN",
"MO" , "MO",
"MS" , "MS",
"MT" , "MT",
"NC" , "NC",
"ND" , "ND",
"NE" , "NE",
"NH" , "NH",
"NJ" , "NJ",
"NM" , "NM",
"NV" , "NV",
"NY" , "NY",
"OH" , "OH",
"OK" , "OK",
"OR" , "OR",
"PA" , "PA",
"RI" , "RI",
"SC" , "SC",
"SD" , "SD",
"TN" , "TN",
"TX" , "TX",
"UT" , "UT",
"VA" , "VA",
"VT" , "VT",
"WA" , "WA",
"WV" , "WV",
"WI" , "WI",
"WY" , "WY",
Null)
Here you go JackieT
IF(INCLUDES( Multi_Picklist_1__c , "A"), "A" + BR() , NULL) +
IF(INCLUDES( Multi_Picklist_1__c , "B"), "B" + BR() , NULL) +
IF(INCLUDES( Multi_Picklist_1__c , "C"), "C" + BR() , NULL) +
IF(INCLUDES( Multi_Picklist_1__c , "D"), "D" + BR() , NULL) +
IF(INCLUDES( Multi_Picklist_1__c , "E"), "E", NULL)I've got the solution... just in case anyone else needs it! This example uses States!
if(ISPICKVAL( Opportunity__r.Project_State__c , "AK") , "AK",
if(ISPICKVAL( Opportunity__r.Project_State__c , "AL") , "AL",
if(ISPICKVAL( Opportunity__r.Project_State__c , "AR") , "AR",
if(ISPICKVAL( Opportunity__r.Project_State__c , "AZ") , "AZ",
if(ISPICKVAL( Opportunity__r.Project_State__c , "CA") , "CA",
if(ISPICKVAL( Opportunity__r.Project_State__c , "CO") , "CO",
if(ISPICKVAL( Opportunity__r.Project_State__c , "CT") , "CT",
if(ISPICKVAL( Opportunity__r.Project_State__c , "DE") , "DE",
if(ISPICKVAL( Opportunity__r.Project_State__c , "FL") , "FL",
if(ISPICKVAL( Opportunity__r.Project_State__c , "GA") , "GA",
if(ISPICKVAL( Opportunity__r.Project_State__c , "HI") , "HI",
if(ISPICKVAL( Opportunity__r.Project_State__c , "IA") , "IA",
if(ISPICKVAL( Opportunity__r.Project_State__c , "ID") , "ID",
if(ISPICKVAL( Opportunity__r.Project_State__c , "IL") , "IL",
if(ISPICKVAL( Opportunity__r.Project_State__c , "IN") , "IN",
if(ISPICKVAL( Opportunity__r.Project_State__c , "KS") , "KS",
if(ISPICKVAL( Opportunity__r.Project_State__c , "KY") , "KY",
if(ISPICKVAL( Opportunity__r.Project_State__c , "LA") , "LA",
if(ISPICKVAL( Opportunity__r.Project_State__c , "MA") , "MA",
if(ISPICKVAL( Opportunity__r.Project_State__c , "MD") , "MD",
if(ISPICKVAL( Opportunity__r.Project_State__c , "ME") , "ME",
if(ISPICKVAL( Opportunity__r.Project_State__c , "MI") , "MI",
if(ISPICKVAL( Opportunity__r.Project_State__c , "MN") , "MN",
if(ISPICKVAL( Opportunity__r.Project_State__c , "MO") , "MO",
if(ISPICKVAL( Opportunity__r.Project_State__c , "MS") , "MS",
if(ISPICKVAL( Opportunity__r.Project_State__c , "MT") , "MT",
if(ISPICKVAL( Opportunity__r.Project_State__c , "NC") , "NC",
if(ISPICKVAL( Opportunity__r.Project_State__c , "ND") , "ND",
if(ISPICKVAL( Opportunity__r.Project_State__c , "NE") , "NE",
if(ISPICKVAL( Opportunity__r.Project_State__c , "NH") , "NH",
if(ISPICKVAL( Opportunity__r.Project_State__c , "NJ") , "NJ",
if(ISPICKVAL( Opportunity__r.Project_State__c , "NM") , "NM",
if(ISPICKVAL( Opportunity__r.Project_State__c , "NV") , "NV",
if(ISPICKVAL( Opportunity__r.Project_State__c , "NY") , "NY",
if(ISPICKVAL( Opportunity__r.Project_State__c , "OH") , "OH",
if(ISPICKVAL( Opportunity__r.Project_State__c , "OK") , "OK",
if(ISPICKVAL( Opportunity__r.Project_State__c , "OR") , "OR",
if(ISPICKVAL( Opportunity__r.Project_State__c , "PA") , "PA",
if(ISPICKVAL( Opportunity__r.Project_State__c , "RI") , "RI",
if(ISPICKVAL( Opportunity__r.Project_State__c , "SC") , "SC",
if(ISPICKVAL( Opportunity__r.Project_State__c , "SD") , "SD",
if(ISPICKVAL( Opportunity__r.Project_State__c , "TN") , "TN",
if(ISPICKVAL( Opportunity__r.Project_State__c , "TX") , "TX",
if(ISPICKVAL( Opportunity__r.Project_State__c , "UT") , "UT",
if(ISPICKVAL( Opportunity__r.Project_State__c , "VA") , "VA",
if(ISPICKVAL( Opportunity__r.Project_State__c , "VT") , "VT",
if(ISPICKVAL( Opportunity__r.Project_State__c , "WA") , "WA",
if(ISPICKVAL( Opportunity__r.Project_State__c , "WV") , "WV",
if(ISPICKVAL( Opportunity__r.Project_State__c , "WI") , "WI",
if(ISPICKVAL( Opportunity__r.Project_State__c , "WY") , "WY",
Null))))))))))))))))))))))))))))))))))))))))))))))))))ouch! Multi-Picklists are evil... I think you might have to create a series of IF statements, kinda like this... but it's gonna be ugly. IF(INCLUDES( Multi_Picklist_1__c , "A"), "A ;",
IF(INCLUDES( Multi_Picklist_1__c , "B"), "B ;",
IF(INCLUDES( Multi_Picklist_1__c , "C"), "C ", NULL)))
If you want to format it exactly like a standard Multi-Select Picklist you can add spaces, Trim the whole thing to get rid of the space at the end, then use Substitute to replace the spaces with space-semicolon.
SUBSTITUTE(TRIM(
IF(INCLUDES(Multi_Picklist_1__c,"A"),"A ",NULL)&
IF(INCLUDES(Multi_Picklist_1__c,"B"),"B ",NULL)&
IF(INCLUDES(Multi_Picklist_1__c,"C"),"C ",NULL)
)," ","; ")
You'll have to tweak it if any of your Multi-Select Picklist values have a space in them.Built a formula builder if anyone is interested, should speed up the process a bit
Salesforce - Multi Picklist Formula Creator
https://docs.google.com/spreadsheets/d/1gMgC7mjTlYL7T5-dpgAyGRkGHv7ma4NdwwsFVlv2Y_U/edit?usp=sharing (https://docs.google.com/spreadsheets/d/1gMgC7mjTlYL7T5-dpgAyGRkGHv7ma4NdwwsFVlv2Y_U/edit?usp=sharing" target="_blank)
Simply Copy the file to your google drive to edit
then paste in your lookup field along with your value list of the multi picklist
