+ Start a Discussion
TheresaAndersonTheresaAnderson 

Help please - I want to capture changes from a select list of check boxes.

The following code works but not the way I expected.   The problem is if the checkbox is true, the fomula continues to add 1 everytime the record is updated. 

 

IF(Sys_SA_6_1__c = True, 1,0) +
IF( Sys_SA_6_2__c = True, 1,0) +
IF( Sys_SA_6_3__c = True, 1,0) +
IF( Sys_SA_6_4__c = True, 1,0) / 4

 

What I would prefer to have is like the following.  But the PRIORVALUE is not allowed with a checkbox. 

 

( IF(PRIORVALUE(Sys_SA_6_1__c) = False, 1, 0) +

IF(PRIORVALUE(Sys_SA_6_1__c) = False, 1, 0) +

IF(PRIORVALUE(Sys_SA_6_1__c) = False, 1, 0) +

IF(PRIORVALUE(Sys_SA_6_1__c) = False, 1, 0) ) / 4

 

Does anyone have a suggestion on how to resolve?  Ultimately, I want a field (%) to determine how many checkboxes are true for the first time and divide by 4 to support the % (knowning that the checkbox could  be true at any given time).