function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Akshay MhetreAkshay Mhetre 

Formula for Picklist value changes

Hello Everyone,

There are two fields  Citytext__c [ Text(255) ]  and City__c [Picklist] and one picklist RCU Location Type contains 2 value-- i)Local ii)OGL.

Requirment: If Citytext__c   and  City__c matches,then RCU  Location Type will automatically change to Local,if both cities are diffrent then RCU Location Type will become OGL.

Facing Problem::-User-added image Please give me solution or any idea to complete this.

 

 

ShivankurShivankur (Salesforce Developers) 
Hi Akshay,

You might want to use the picklist field reference link below: 
ISPICKVAL(Case.City__c, "Local") 

or

TEXT(Case.City__c)
Since you have If condition you can retrieve the text value of Picklist field to comapre within the formula.

Check out usage guidence here:
https://trailhead.salesforce.com/content/learn/modules/advanced_formulas/picklist_formulas

Hope above information helps. Please mark as Best Answer so that it can help others in future.

Thanks.