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
ManishSManishS 

How to populate Region formula field based on State and

I have created a custom formula field by name 'Region' under Lead object with Return Type= Text
 
Now based on the Postal Code and State, Region field should be populated by Region value.
eg:
Area Code
(PostalCode)  State                Region
205AlabamaEast251AlabamaEast256AlabamaEast334AlabamaEast907AlaskaWest480ArizonaWest520ArizonaWest602ArizonaWest623ArizonaWest928ArizonaWest479ArkansasWest501ArkansasWest870ArkansasWest209CaliforniaWest213CaliforniaWest310CaliforniaWest323CaliforniaWest408CaliforniaWest415CaliforniaWest424CaliforniaWest510CaliforniaWest530CaliforniaWest559CaliforniaWest562CaliforniaWest619CaliforniaWest626CaliforniaWest650CaliforniaWest661CaliforniaWest707CaliforniaWest714CaliforniaWest760CaliforniaWest805CaliforniaWest818CaliforniaWest831CaliforniaWest858CaliforniaWest909CaliforniaWest916CaliforniaWest925CaliforniaWest949CaliforniaWest303ColoradoWest719ColoradoWest720ColoradoWest970ColoradoWest203ConnecticutEast475ConnecticutEast860ConnecticutEast959ConnecticutEast302DelawareEast239FloridaEast305FloridaEast321FloridaEast352FloridaEast386FloridaEast407FloridaEast561FloridaEast727FloridaEast754FloridaEast772FloridaEast786FloridaEast813FloridaEast850FloridaEast863FloridaEast904FloridaEast941FloridaEast954FloridaEast229GeorgiaEast404GeorgiaEast470GeorgiaEast478GeorgiaEast678GeorgiaEast706GeorgiaEast770GeorgiaEast912GeorgiaEast808HawaiiWest
I tried using combinations of  OR and AND but no help in getting desired results. Any clue on this would save my day :-)
 
Regrds,
manish