I can't get this to work and was hoping someone can help... Any thoughts?
IF(BEGINS( Phone , "(804)"), "Richmond",IF(BEGINS(Phone , "(757)"),"Virginia Beach - Norfolk",IF(BEGINS(Phone , "(704):(980)"),"Raleigh",IF(BEGINS(Phone , "(919)"),"Charlotte",IF(BEGINS(Phone , "(813):(727):(941)"),"Tampa",IF(BEGINS(Phone , "(321):(407)"),"Orlando",IF(BEGINS(Phone , "(904)"),"Jacksonville",IF(BEGINS(Phone , "(770):(678):(404)"),"Atlanta",IF(BEGINS(Phone , "(914):(631):(516):(347):(718):(917):(212):(646):(862):(973):(201):(551)"),"NYC - Newark",IF(BEGINS(Phone , "(484):(610):(835):(215):(267):(856):(609):(302)"),"Philadelphia",IF(BEGINS( Phone , "(781):(857):(339):(617)"),"Boston",IF(BEGINS(Phone , "(716):(858)"),"Buffalo",IF(BEGINS(Phone , "(860)"),"Hartford",IF(BEGINS(Phone , "(401)"),"Providence",IF(BEGINS(Phone , "(305):(786):(954):(754)"),"Miami",IF(BEGINS(Phone , "(412):(878)"),"Pittsburgh",IF(BEGINS(Phone , "(513)"),"Cincinnati",IF(BEGINS(Phone , "(216):(440)"),"Cleveland",IF(BEGINS(Phone , "(614)"),"Columbus",IF(BEGINS(Phone , "(571):(703):(202):(240):(301)"),"DC",IF(BEGINS(Phone , "(410):(443)"),"Baltimore","?-Non-metro")))))))))))))))))))))
