function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
kmckay9kmckay9 

Formula syntax - help needed

Hi,

 

I'm trying to create a workflow that will update the Lead Status field when these conditions are met:

 

- Latest Lead Source is changed

- Lead Status equals "In Process"

- Timeline is changed, AND the timeline is shorter (ex:  12+ Months is now 6-12 Months, 3-6 Months or 0-3 Months).

 

 

 

Here is the formula that I have gotten to - but the syntax is clearly not right.  Any help / suggestions would be greatly appreciated. Thanks in advance.

 

 

AND ( ISCHANGED(Latest_Lead_Source__c),  ISPICKVAL (Status, "In Process"), ( ISCHANGED(Time__c),  

AND 

(Time__c="0-3 Months"), AND ( PRIORVALUE="3-6 Months", "6-12 Months", "12+ Months", "Unknown", "No Project"),

OR (Time__c="3-6 Months")), AND ( PRIORVALUE="6-12 Months", "12+ Months", "Unknown", "No Project"),

OR (Time__c="6-12 Months"), AND ( PRIORVALUE="12+ Months", "Unknown", "No Project")

OR (Time__c="12+ Months"), AND ( PRIORVALUE="12+ Months", "Unknown", "No Project"))