Skip to main content
Roger Farrow ha fatto una domanda in #Data Management
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 risposte