So I got the equation format to work when defining a single sequence. I can't get it to work when adding a second sequence.

The equation I used for a specific answer sequence in my array: {LC=(if(LSM_A1==2 and LSM_A2==2 and LSM_A3==2 and LSM_A4==2 and LSM_A5==2 and LSM_A6==2,"3",""))}

This will prefill the next list question (question code -
LC in separate group) with option 3.

I need to combine 64 different sequences in a single equation e.g.
{LC=(if(LSM_A1==2 and LSM_A2==2 and LSM_A3==2 and LSM_A4==2 and LSM_A5==2 and LSM_A6==2,"3",""))} or {LC=(if(LSM_A1==2 and LSM_A2==2 and LSM_A3==2 and LSM_A4==2 and LSM_A5==2 and LSM_A6==1,"2",""))} or ......etc.

I have no idea how to combine these .

Hi,
first you should explain better the algorithm.
I only see in the classification 
A: 8-10
B: 5-7
C: 1-4
Which Yes/No combinaions  lead to which result?
Do you only sum up certain values? Or what do you do to reach a "10"?

Well, some ideas:
Use functions like countif, countifop, sumif.
Use an appropriate coding, e.g. if you sum something it's better to use "0" and "1" instead of "1" and "2"
Using "0" and "1" you could join the six values to a string that you see as a binary number from "000000" = 0 to "111111" = 63

Anyway, as long as I do not understand the logic "When is the outcome A? When is it C?"
I can't say more.

Joffm

Thank you Joffm for making me realise I’m running around in circles and breaking my head by not logically looking at the issue properly. Like they say, you need to understand the problem yourself before you can find a solution. Old age does that.

The survey has 3 questions. First question is an array type, 6 sub-questions (A1...A6), 2 answer options (Yes/No); second question is the equation type question; third (in a separate group) is the list question with the 3 categories.

The array can have different Yes/No answer sequences and these sequences were provided by the client. I have a predefined list with 64 sequences thus do not have insight into how they classify each sequence. All that I have is the sequence and the list question code it represents. 


I use the equation type question to prefill the list question with the category the sequence represents. The equation I use is {LC=(if(LSM_A1==2 and LSM_A2==2 and LSM_A3==2 and LSM_A4==2 and LSM_A5==2 and LSM_A6==2,"3",""))}. LC represents the list question code, LSM the array question code and A1 to A6 the sub-question options in the array (I changed it to alpha-numerical from the original to avoid uncertainty with the answer codes)

The equation works perfect for a single sequence and the list question is prefilled. My problem is when defining all the sequence options and placing it in the same equation question, nothing is prefilled in the list question. I tried it all-in-one, different equation questions each with a single equation but no luck.  

The equations I use for the sequences are as follows etc:
{LC=(if(LSM_1==2 and LSM_2==2 and LSM_3==2 and LSM_4==2 and LSM_5==2 and LSM_6==2,"3",""))}
{LC=(if(LSM_1==2 and LSM_2==2 and LSM_3==2 and LSM_4==2 and LSM_5==2 and LSM_6==1,"2",""))}

Somehow, I need to combine all the different sequence equations into one. This is where I am stuck. I don’t know if it is even possible using the equation type at all. Attached the latest lss export.

Any guidance will be highly appreciated.