Looking for an idea to validate a column based on values picked within. Right now i have it working so that if the 1st option is picked, a user cannot pick another option. However, if option 1 is not picked, users can pick any variety of the remaning options.
my set up repeats this for each of the options =contains([control],"option 1")&&contains([control],"option 2"). This will repeat 20 or so times to capture each option that may be picked with the 1st, and invalidate the conrol if this is done by the user.
Ideally, i would like to not hardcode the possible options and only state if option 1 is picked, nothing else can be picked with it but still keep this all in one control.
I can provide more information that would be helpful to explain the set up. Thank you in advance for the tips!
Best answer by zbean
View original