Skip to main content
Hi,

 

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 respostas