• Rob Case
  • NEWBIE
  • 0 Points
  • Member since 2014

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 0
    Replies
I was trying to derive the state from area codes in leads and my compiled formula is too large.

I am trying to figure out a way to make it work.  Here is a sample of the formula...

if(ISBLANK(Phone),"--",
if(CONTAINS("205:251:256:334",left(SUBSTITUTE(Phone,"(",""),3)),"Alabama",
if(CONTAINS("907",left(SUBSTITUTE(Phone,"(",""),3)),"Alaska",

and so on and so forth through all of the states with their respective area codes.  Seems simple enough, but needs to be simplified.

Any thoughts are much appreciated!