You need to sign in to do that
Don't have an account?
Christina 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!!
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!!
Example where Over 10% and Under 50%
All Answers
Example where Over 10% and Under 50%
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.