Currently, we have 8 Checkbox fields that our Onboarding Team manages.
They would like to do a formula field that looks at how many of those fields are checked as TRUE and divide (/) that total by 8
Is that possible?
1 réponse
Yes, your formula would look like this, just plug in the API names for your checkbox fields
(
IF(Checkbox1__c, 1, 0) +
IF(Checkbox2__c, 1, 0) +
IF(Checkbox3__c, 1, 0) +
IF(Checkbox4__c, 1, 0) +
IF(Checkbox5__c, 1, 0) +
IF(Checkbox6__c, 1, 0) +
IF(Checkbox7__c, 1, 0) +
IF(Checkbox8__c, 1, 0)
) / 8
