Topics started by KCL | XM Community

Topics started by KCL

1 Topic

K
KCL
asked in Survey Platform

Constant Sum + Matrix Tables + Data Validation

Hello!  Question Type: Matrix TableMatrix Type: Constant Sum I would like to use data validation to ensure that the total sum of column 1 (orange) matches a value submitted earlier in the survey. I also need the total sum of column 2 (green) to match a different value submitted earlier in the survey. The total sum of column 3 (yellow) does not need validation and does not match any information submitted previously.  In all the posts I’ve read, I see people putting the piped text of the previous answer into the ‘must total’ data validation box. However, that doesn’t work in my situation because there are multiple totals. Is there any way to use data validation with multiple totals?   

3
Nanditha MM
Level 4 ●●●●
17 days ago

Productivity playlist

Terms & Conditions