Hi, I am constructing a matrix table in which participants have to fill out one column to total 35. However, the first column must remain constant at 15. I am unable to use two different validations for the columns in my table. Is there code to require two different validation numbers for each matrix column?
If this is not possible, I have been exploring an alternative route. I have hidden the 'total' cell for the left column, as it is not important to my study. With the total column not showing, I could create an additional row and hide it from participants such that the left row always also equals 35 (but participants view it as totaling 15 because the row containing "20" is hidden from them).
Although I have successfully been able to hide a single cell from the matrix, and have been successful hiding a column, I cannot figure out how to hide only a row. I have looked at several related posts on this forum and none of these options have been successful.
Your help is greatly appreciated!
Can you require different validation for each column in a matrix table?
Leave a Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.