+ Start a Discussion
Christina Lam 7Christina Lam 7 

Building a Checkbox with Different Components

Hi!

What's an efficient approach to combine different components in a formula for a checkbox field? I am hoping to create a checkbox field where it will checked when it satisfies a few components: 1. when another checkbox field is checked, 2. when another field within the same object page is "over" a percentage, 3. when another field is "under" a percentage.

How would you combine the IF ( ) and AND ( ) in this scenario? Thank you!!

 
Best Answer chosen by Christina Lam 7
debradebra
IF ( AnotherCheckbox__c && OverPercent__c > 0.10 && UnderPercent__c < 0.50, true, false)

Example where Over 10% and Under 50%

All Answers

debradebra
IF ( AnotherCheckbox__c && OverPercent__c > 0.10 && UnderPercent__c < 0.50, true, false)

Example where Over 10% and Under 50%
This was selected as the best answer
Christina Lam 7Christina Lam 7
Thank you so much for your help!
Christina Lam 7Christina Lam 7
Hello again! How do you combine a IF formula if the checkbox includes AND / OR components?

The checkbox field is only checked if (1. when another checkbox field is checked) PLUS (2. another checkbox is over a percentage OR 3. another checkbox is under a percentage). The issue righ now is the checkbox will not uncheck when the other checkbox field is unchecked. The checkbox must only check when the other checkbox is checked along with either one of the over or under percentage components.