How to use multiple choices of a checkbox?
Posted on 2010-11-22
I have a checkbox field named Grade giving the user 5 choices - let's say
The user can choose one or more up to the entire 5.
Now I have another, computed field that gives results based on those choice(s). So my @if would say something like this:
@If(Grade = "A"; "BLUE"
; @If(Grade = "B"; "PINK"
; @If(Grade = "C"; "WHITE"
; @If(Grade =" "; "make another choice"
; @If(Grade = ("A” : “B” : “C” : “D” : “E”); "RED"
; @If(Grade = "D"; "PURPLE"
; @If(Grade = "E"; "ORANGE"
What is happening is if the user has chosen all 5 letters, it is returning BLUE, where I want it to fail the first 4 evaluations and succeed on the statement that returns RED.
I understand that since all 5 has been chosen, it finds A and returns BLUE - but the field contents isn't JUST A, it reads in the Document Properties Field Tab as
I've tried different separators for the list that should return RED but I still get BLUE. I've tried no separators. The point is that I need a distinct evaluation if all of the letters are chosen vs. just one. I put the multiple choice line in the middle to see if the order of statements matter but it doesn't seem to.
I know I could try lotus script but this seems simple enough for formula language, plus I would still have the separator difficulty in the case when I am avaluating someone who chose all 5.
So my question is, experts - how do you refer to a checkbox or listbox to have all choices evaluated together?