Okay then what you want to do is create 2 custom fields and select Formula as the datatype and TEXT as the result type. You formulas will look something like this: CASE(InterCall_Office__c,
"NS Central AL", "Anna Lyon",
"NS Central JB", "Jody Bartlett",
"NS Central JM", "Jessica Morin",
"NS Central SW", "Sean Whiteside",
"NS East JB", "Joy Bonavita",
"NS West CG", "Christy Good",
"NS West JP", "Jana Perry",
"NS West KM", "Kelly Mark",
"WS Business Partner Mgr", "Shelby Cooper",
"WS Reseller Mgr", "Shelby Cooper",
"DS Chicago", "Cameron Hatten",
"DS Denver", "Chad Moroni",
"DS Orange County", "Bill Hensel",
"DS KC/St. Louis", "Kari Markham",
"DS Los Angeles", "Bret Dupuis",
"DS Minnesota", " Jason Foss",
"DS Ohio", "Jill Lionetti",
"DS Atlanta", "Sam Joseph",
"DS Boston", "Darren McLeod",
"DS Philadelphia", "Shana Kaufman",
"DS New Jersey", "Jason Shawgo",
"DS Remote NY/NC", "Julie McGinnis",
"DS Washington D.C.", "Jordan Reid",
"DS Manhattan", " Eric Olson",
"DS Dallas", "Stephanie Barone",
"DS Silicon Valley", "Mia Navarro",
"DS East Canada", "Jared Stanchina",
"DS Florida", "Doug Danowski",
"DS Houston ", "Chad Ramsey",
"DS San Francisco", "Suzanne Smith",
"DS Seattle/WestCanada", "Paul Fox",
"DS East Bay", "Kristine Lamson",
"DS CST Jeser", "Bridget Jeser",
"DS CST Kranz", "Erin Kranz",
"DS CST Tassio", "Tim Tassio",
NULL)
8 answers
