Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
venk1255venk1255 

problem with formula field

Bill_to_Site__r.Address1__c + ','+ Bill_to_Site__r.Address2__c & BR() & Bill_to_Site__r.Address3__c + Bill_to_Site__r.City__c + ','+Bill_to_Site__r.State__c +  Bill_to_Site__r.Country__c +Bill_to_Site__r.Zip__c

 

Error: Field Country__c is a picklist field. Picklist fields are only supported in certain functions. Tell me more

Best Answer chosen by Admin (Salesforce Developers) 
Rahul SharmaRahul Sharma

Try using TEXT function for Country(Picklist) field like it is done as below:

 

Bill_to_Site__r.Address1__c + ','+ Bill_to_Site__r.Address2__c & BR() & Bill_to_Site__r.Address3__c + Bill_to_Site__r.City__c + ','+Bill_to_Site__r.State__c +  TEXT(Bill_to_Site__r.Country__c) +Bill_to_Site__r.Zip__c

 

All Answers

Rahul SharmaRahul Sharma

Try using TEXT function for Country(Picklist) field like it is done as below:

 

Bill_to_Site__r.Address1__c + ','+ Bill_to_Site__r.Address2__c & BR() & Bill_to_Site__r.Address3__c + Bill_to_Site__r.City__c + ','+Bill_to_Site__r.State__c +  TEXT(Bill_to_Site__r.Country__c) +Bill_to_Site__r.Zip__c

 

This was selected as the best answer
venk1255venk1255

Thanks Rahul,

 

its working fine now.