AnsweredAssumed Answered

Case with Value List?

Question asked by truji_ on May 5, 2011
Latest reply on May 5, 2011 by raybaudi


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?

Thank you,