Case with Value List?
Is it possible to create a case / if calculation for multi-checked value lists?
I have two checkbox fields with 9 values. If a user selects "ABC" in one field, I want the other field to automatically select "A" from the value list.
I was able to do this by doing an if calculation (If(field1="ABC";field2="A";""). However, it does not work for fields that have more than 1 value selected. I.e Field 1 = "ABC" and "CBA", the if calculation ignores the "ABC" because there is a "new line" or a new option selected. It would be quite long to create an if calculation for all possible values. Any ideas?