+ Start a Discussion
Vipin K 10Vipin K 10 

Substitute/replace picklist values in Formula field

Company_Name__c &'_'& TEXT( GEO__c )&'_'& TEXT(Product__c) &'_'& TEXT(Year__c)

I have a formula field as above where GEO__C, Product__C are picklist fields.

Now my requirement is Eg - GEO (India, America, Europe) and Product(Android Phone, Mac Phone)

When GEO is India and Product is Android Phone Value should be : (Samsung_IND_Android_Phone_2017) as per the above formula

GEO : India (IND), America (USA), Europe (UK) - it should substitute the value with upper case. Product : Android Phone(Picklist value should get converted to Android_phone)underscore should get added.

can someone help how to add substitute for picklist field
Balayesu ChilakalapudiBalayesu Chilakalapudi
Try like this,
 
​Company_Name__c &'_'& UPPER(TEXT( GEO__c ))&'_'& UPPER(TEXT(Product__c)) &'_'& UPPER(TEXT(Year__c))


Let us know if it helps.
SalesFORCE_enFORCErSalesFORCE_enFORCEr
You can try adding IF clause something like this
IF(TEXT( GEO__c )='India', 'IND',IF(TEXT( GEO__c )='America','USA',IF(TEXT( GEO__c )='Europe','UK','')))