I want to create a formula field to select the Province/State Code based on the City.
Can someone please help?
Thanks
Tarun
4 answers
thats fine, the formula will be as below
CASE(City__c,
'Kitchner', 'ON',
'London', 'ON',
'Milton', 'ON',
'City Name here', 'Province Name here',
NULL)
