Hi all, I have a matrix question with 12 statements and each statement has 3 answers, select all that apply. If they click column B and/or column C, then they must also click column A. However, they can choose not to click on any of the three columns. I tried the custom validation logic but I can't figure out how to do it there. Any suggestions? Thanks.
Solved
Matrix Question Custom Validation
Best answer by rondev
Assuming column A, B and C has recode values 1, 2 and 3 respectively. We can add validation as:
Statement 1 (Recode) is equal to 1,2,3 OR Statement 1 (Recode) is equal to 1,2 OR Statement 1 (Recode) is equal to 1,3 OR Statement 1 (Recode) is empty
AND
Statement 2 (Recode) is equal to 1,2,3 OR Statement 2 (Recode) is equal to 1,2 OR Statement 2 (Recode) is equal to 1,3 OR Statement 2 (Recode) is empty
+22Assuming column A, B and C has recode values 1, 2 and 3 respectively. We can add validation as:
Statement 1 (Recode) is equal to 1,2,3 OR Statement 1 (Recode) is equal to 1,2 OR Statement 1 (Recode) is equal to 1,3 OR Statement 1 (Recode) is empty
AND
Statement 2 (Recode) is equal to 1,2,3 OR Statement 2 (Recode) is equal to 1,2 OR Statement 2 (Recode) is equal to 1,3 OR Statement 2 (Recode) is empty
Leave a Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.