Choice filter statement based on a matrix question responses and filters

User Support Form Building
,
1

Hi,
I need help with the following scenario. I present a section of the questionnaire where I’m experiencing challenges. The big issue is, calculations/choice filters, meeting the conditions in Q3 based on the responses in Q1. Please help.

Q1. How familiar are you with each of the following letters in the context of sustainable development? Please select a response for each organization (1=Very familiar, 2=Somewhat familiar, 3=Not familiar at all, 4=Never heard of it).
COLUMNS

  1. Very familiar
  2. Somewhat familiar
  3. Not very familiar
  4. I have never heard of it

ROWS [RANDOMIZE]

  1. A
  2. B
  3. C
  4. D
  5. E
  6. F
  7. G
  8. H
  9. I
  10. J
  11. K
    Q2. How favorable is your opinion toward each of the following organizations, based on what you know about them?
    COLUMNS
  12. Very favorable
  13. Somewhat favorable
  14. Neither favorable nor unfavorable
  15. Somewhat unfavorable
  16. Very unfavorable
  17. Don’t know/no opinion
    ROWS
    INSERT LETTERS VERY OR SOMEWHAT FAMILIAR WITH IN Q1. MAINTAIN ORGANIZATION ORDER FROM Q1.

Q3. Using a 10-point scale where ‘1’ means “does not describe at all” and ‘10’ means “describes completely,” please rate each statement on how well it describes each of the following letters in the context of sustainable development. Please feel free to use any number on the scale.

LETTER SELECTION FOR Q3
IF VERY/SOMEWHAT FAMILIAR WITH UNDP IN Q1, SELECT THAT AS ONE LETTER.
CHOOSE REMAINING LETTERS (UP TO 3 TOTAL) IF VERY OR SOMEWHAT FAMILIAR WITH IN Q1 ON A LEAST FILL BASIS. DO NOT CHOOSE ANY LETTERS NOT “VERY OR SOMEWHAT FAMILIAR” WITH IN Q1.

RANDOMIZE WHICH LETTER OF THE THREE IS ASSIGNED TO LETTER A, B, C.

LETTERS

  1. A
  2. B
  3. C
    ATTRIBUTES (RANDOMIZE)
  4. Brings stakeholders together
  5. Can mobilize quickly in times of crisis (e.g., natural disasters, war)
  6. Communicates its goals and accomplishments effectively
  7. Delivers long-term, sustainable solutions
  8. Has a clear focus
  9. Has a long track record of success
  10. Has experts on the global priorities that are important to me/my organization
  11. Has proved its worth as a partner
  12. Has strong problem-solving skills when confronting evolving global priorities
  13. Helps create secure, productive and just communities

I’m experiencing challenges with respect

2

@alefa_banda, you can do this by following our community post discussed previously: