You need to sign in to do that
Don't have an account?
LJHOWE I have several different regions with specific agent states to assign to my marketing reps. I'm trying to set up a formula field to look at the region and the agent state and put the name I type in for the marketing rep. The above formula works, but it becomes too large to run. I am open to any suggestions on this. Thanks for any help you can give.
IF(AND FORMULA QUESTION
Code:
Data Type Formula IF(AND( Region__c ="REGION 1", Agent_State__c ="MI"),"JOHN DOE", IF(AND( Region__c ="REGION 1", Agent_State__c ="IN"),"JOHN DOE",)
Message Edited by Buell on 11-13-2008 04:22 PM
All Answers
Message Edited by Buell on 11-13-2008 04:22 PM