I am trying to define a field to be calculated based on another field's value(s) which happens to be a checkbox. I can get the results I am looking for by evaluating only one of the checkbox options (if only one is checked off, where there are more than one options checked off, this calculation will not work), but I am having trouble figuring out what the syntax would be to find all of the field_name(s) where checkbox = (option)3 whether or not the checkbox is checked for just option 3 or if it is checked for option 2 and 3, 1 and 3 or 1, 2 and 3. Below is the calculation (very simple)that only partly works but, is not the ultimate goal for this calc field. If anyone has any idea how to expand the capability of this calc, I would really appreciate your input.

If(Checkbox = "3", Field_Name, "N/A")

Some other things I have tried:

If((Checkbox = "3","2","1"), Field_Name, "N/A")

If((Checkbox = "3,2,1"), Field_Name, "N/A")

Thanks,

Justine

I think I understand what you want. First, make sure the checkbox fields are defined as text.

If(PatternCount(Checkbox, "3"), Field_Name, "N/A")

-bd