
I'm using the Salutation Picklist in a Case function and its producing the "Error: Field Salutation is a picklist field. Picklist fields are only supported in certain functions" I thought Case was one of the functions that coped with Picklists fine. The other cases used in it were fine. Any advice on this would be much appreciated.
Thanks
Roger
Below is the formula:
CASE(Salutation,
"Mr", "",
"Mrs", "(Mrs)",
"Ms", "(Ms)",
"Miss", "(Miss)",
Salutation)&
FirstName & Post_Nominals__c & BR()
& CASE( Preferred_Address__c,
"Home",
IF( Home_Address_1__c <> "", Home_Address_1__c & BR() , "") &
IF( Home_Address_2__c <> "", Home_Address_2__c & BR() , "") &
IF( Home_Address_3__c <> "", Home_Address_3__c & BR() , "") &
IF( Home_Town__c <> "", Home_Town__c & BR() , "") &
IF( Home_County__c <> "", Home_County__c & BR() , "") &
IF( Home__c <> "", Home__c & BR () , "")
& CASE(Home_Country__c,
"United Kingdom", " ",
"UK", " ",
Preferred_Country__c),
"Business",
IF( Company_Position__c <> "", Company_Position__c & BR() , "") &
IF( Company_Name__c <> "", Company_Name__c & BR() , "") &
IF( Business_Address_1__c <> "", Business_Address_1__c & BR() , "") &
IF( Business_Address_2__c <> "", Business_Address_2__c & BR() , "") &
IF( Business_Address_3__c <> "", Business_Address_3__c & BR() , "") &
IF( Business_Town__c <> "", Business_Town__c & BR() , "") &
IF( Business_County__c <> "", Business_County__c & BR() , "") &
IF( Business_Postcode__c <> "", Business_Postcode__c & BR () , "") &
CASE(Business_Country__c,
"United Kingdom", " ",
"UK", " ",
Business_Country__c),
"Preferred",
IF( Preferred_Address_1__c <> "", Preferred_Address_1__c & BR() , "") &
IF( Preferred_Address_2__c <> "", Preferred_Address_2__c & BR() , "") &
IF( Preferred_Address_3__c <> "", Preferred_Address_3__c & BR() , "") &
IF( Preferred_Town__c <> "", Preferred_Town__c & BR() , "") &
IF( Preferred_County__c <> "", Preferred_County__c & BR() , "") &
IF( Preferred_Postcode__c <> "", Preferred_Postcode__c & BR () , "") &
CASE(Preferred_Country__c,
"United Kingdom", " ",
"UK", " ",
Preferred_Country__c),
" ")
3 answers
+1 Carissa.
You could try it like:CASE(
Salutation ,
"Mr", "",
"Mrs", "(Mrs)",
"Miss", "(Miss)",TEXT( Salutation )
)