
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 risposte
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.