You need to sign in to do that
Don't have an account?
Paula Jarvis 4
Create Workflow on Standard Field to Update Custom Field
I would like to creat a Workflow that updates a Custom picklist Field (MRR Territory) based on the Standard State/Province Field. I will have all 50 states to accommodate for in the formula and three territories (East, Central, West). Here is how I started the Rule:
IF(ISPICKVAL(State/Province, "AL"),
IF(ISPICKVAL(State/Province, "SC"),
(MRR_Territory, (Central))
I keep getting an error message.
IF(ISPICKVAL(State/Province, "AL"),
IF(ISPICKVAL(State/Province, "SC"),
(MRR_Territory, (Central))
I keep getting an error message.
All Answers
IF(TEXT(State) = "AL",
IF(TEXT(State) = "SC",
(MRR_Territory_Marketo__c, (Central))
Here is the updated code
I've updated the fomula to and now I get this error - Error: Syntax error. Extra IF
IF(INCLUDES(State) = "Alabama",
MRR_Territory_Marketo__c, 'Central' )
IF(INCLUDES(State) = "Texas",
MRR_Territory_Marketo__c, 'Central' ))
Let me know if it works