You need to sign in to do that
Don't have an account?
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).