2 Replies Latest reply on May 5, 2011 6:51 AM by raybaudi

    Case with Value List?



      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,