Sign Up ›

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

Tricky Workflow Rule

I have a workflow rule that populates a status field but I don't want it to fire if 3 options are the current values or if the options that excluded are manually selected.  Based on different variations I can either get the field to populate, or have the field not change but if I remove the selection then the rule won't populate the appropiate status.  Below is the current workflow which is not populating the status but keeping the Values.  Any Help?

AND( 
(OR ( 
TODAY() >= Targeted_Close_Date__c -15, 
TODAY() <= Targeted_Close_Date__c+15 
)), 
(OR ( 
ISPICKVAL(Account_Status__c,"Active – Delayed"), 
ISPICKVAL(Account_Status__c,"Inactive – Out of Business "), 
ISPICKVAL(Account_Status__c,"Inactive – Regrettable Loss"), 
(AND (ISCHANGED(Account_Status__c),ISPICKVAL(Account_Status__c,"Active – Delayed"))), 
(AND (ISCHANGED(Account_Status__c),ISPICKVAL(Account_Status__c,"Inactive – Out of Business"))), 
(AND (ISCHANGED(Account_Status__c),ISPICKVAL(Account_Status__c,"Inactive – Regrettable Loss")))) 
) 
)

 

 

BA_AdminBA_Admin

You can find more luck if this post goes onto Formulas & Validation Rules Discussion section
JJJenkinsJJJenkins

Thanks - I'll remove it and repost