I'd like to do something like this:
Checkbox1 = A
Checkbox2 = B
Determine which checkboxes are selected and total the points.
E.G. If Checkbox1 is selected, the total for Calculated Field is 2 points.
If Checkbox2 is selected, the total for Calculated Field is 2 points .
(if both are selected, the total for Calculated Field is 4 points )
One thing to note - If I set each checkbox to have numeric values, they can't both be 2 points. WF wants unique values for each.
Topics help categorize Community content and increase your ability to discover relevant content.
You shouldn't need to use the numeric values. In your calculated field, you could just put an If statement like IF(ISBLANK( Checkbox Field ),0,IF( Checkbox Field ="Choice 1",2,if( Checkbox Field ="Choice 2",2,4),4))
Hi Greg. I agree that the checkbox formula you described will work for single-select checkboxes ("radio buttons", we used to call them), but in the past, to do multi-select checkbox math, I had to resort to some pretty fancy calc formulas to make it work. If that's changed now, though, that would be terrific!
Thanks for the suggestion. We had 12 multi-select options so doing a nested if for that number of combinations wasn't feasible.
Instead, I had to make a calculated field for each option that did a "contains" to see if the option showed up in the result from the field. From there, I created another calculated field that added those other 12 fields together. Incredibly clunky and ugly but it's getting the job done.