Skip to main content
This formula checks to see if one of the 6 statuses has changed to "APPROVED'

 

         next it makes sure that none of the statuses is a "REJECT"

 

         next it makes sure that none of the statuses is a "BLANK"

 

It was working but is not now, any ideas?

 

Rule Criteria

(ISCHANGED( Credit_Status__c ) ||

 

ISCHANGED( Facilities_Planning_Status__c ) ||

 

ISCHANGED( Legal_Status__c ) ||

 

ISCHANGED( Marketing_Status__c ) ||

 

ISCHANGED( Customer_Services_Status__c ) ||

 

ISCHANGED( Regulatory_Status__c ))

 

&&

 

(NOT ISPICKVAL( Credit_Status__c ,"REJECT") &&

 

NOT ISPICKVAL( Facilities_Planning_Status__c ,"REJECT") &&

 

NOT ISPICKVAL( Legal_Status__c ,"REJECT") &&

 

NOT ISPICKVAL( Marketing_Status__c ,"REJECT") &&

 

NOT ISPICKVAL(Customer_Services_Status__c ,"REJECT") &&

 

NOT ISPICKVAL( Regulatory_Status__c ,"REJECT"))

 

&&

 

(NOT ISPICKVAL( Credit_Status__c ,"") &&

 

NOT ISPICKVAL( Facilities_Planning_Status__c ,"") &&

 

NOT ISPICKVAL( Legal_Status__c ,"") &&

 

NOT ISPICKVAL( Marketing_Status__c ,"") &&

 

NOT ISPICKVAL( Customer_Services_Status__c ,"") &&

 

NOT ISPICKVAL( Regulatory_Status__c ,""))
6 个回答
  1. 2011年11月17日 19:39
    The formula is not currently looking for "APPROVED". Other than that, what's not working?

     

    You will need to add a check for ISPICKVAL(fieldnamehere, "APPROVED") to each of the checks on the ISCHANGED statements in the first block.