Hey Guys,

I am having an issue with a workflow rule (that i thought was working on Friday, but now it is not)

Basic gist of the situation is, I have a workflow rule, that will set an 'active on platform' date, the moment any one of five products goes live and then also have a rule to remove that date, if ALL of those five products get turned off, or all 'currently active' products get turned off. (they could have 1, 2, 4 products live and i need the date removed if they are "no longer active on platform")

Below, in sequence, is the logic I have developed and it is no longer working

Update Date for First Platform Activation

.........

AND( 
ISBLANK(Active_on_Platform_Date__c) 
, 
OR( 
ISCHANGED(Product1__c), 
ISCHANGED(Product2__c), 
ISCHANGED(Product3__c), 
ISCHANGED(Product4__c), 
ISCHANGED(Product5__c), 
ISCHANGED(Product6__c), 
ISCHANGED(Product7__c) 
), 
OR( 
ISPICKVAL(Product1__c, "Active"), 
ISPICKVAL(Product2__c, "Active"), 
ISPICKVAL(Product3__c, "Active"), 
ISPICKVAL(Product4__c, "Active"), 
ISPICKVAL(Product5__c, "Active"), 
ISPICKVAL(Product6__c, "Active"), 
ISPICKVAL(Product7__c, "Active") 
) 
)

Which triggers:

Field Update 

Active_on_Platform_Date__c = Now()

Which then triggers an instant internal alert to me and a '7 days after this date' alert

I then also have the following rule to eliminate that date:

AND( 
NOT( 
ISBLANK( 
Active_on_Platform_Date__c 
) 
), 
OR( 
ISCHANGED(Product1__c), 
ISCHANGED(Product2__c), 
ISCHANGED(Product3__c), 
ISCHANGED(Product4__c), 
ISCHANGED(Product5__c), 
ISCHANGED(Product6__c), 
ISCHANGED(Product7__c) 
), 
AND( 
OR( 
ISPICKVAL(Product1__c, "Canceled"), 
ISPICKVAL(Product1__c, "NA"), 
ISPICKVAL(Product1__c, "") 
), 
OR( 
ISPICKVAL(Product2__c, "Canceled"), 
ISPICKVAL(Product2__c, "NA"), 
ISPICKVAL(Product2__c, "") 
), 
OR( 
ISPICKVAL(Product3__c, "Canceled"), 
ISPICKVAL(Product3__c, "NA"), 
ISPICKVAL(Product3__c, "") 
), 
OR( 
ISPICKVAL(Product4__c, "Canceled"), 
ISPICKVAL(Product4__c, "NA"), 
ISPICKVAL(Product4__c, "") 
), 
OR( 
ISPICKVAL(Product5__c, "Canceled"), 
ISPICKVAL(Product5__c, "NA"), 
ISPICKVAL(Product5__c, "") 
), 
OR( 
ISPICKVAL(Product6__c, "Canceled"), 
ISPICKVAL(Product6__c, "NA"), 
ISPICKVAL(Product6__c, "") 
), 
OR( 
ISPICKVAL(Product7__c, "Canceled"), 
ISPICKVAL(Product7__c, "NA"), 
ISPICKVAL(Product7__c, "") 
) 
) 
)

Which triggers a field update to 'remove active on platform date' and blank it out.

Now, I swear on my life this was working thursday and now is no longer working.

Can anyone help me figure out why?