Displaying certain options in a multiselect question based on a previous multi-select question + one permanent option

So, I solved this issue partly by creating the following coding mechanism:

But now, my surveyors tell me that the option ‘No infrastructure is pwd/child friendly’ does not turn up without selecting ‘no women’s toilet infrastructure available’.

This does not make sense, because certain toilets may have infrastructure but they may not be child/pwd friendly. How do i rectify this or force the ‘No infrastructure is pwd/child friendly’ in both follow up questions?


tl;dr: I want options for follow-up questions (f_PwD and f_child) to be displayed based on a multiselect option under (f_PT). But I always want the ‘no’ name to be displayed, irrespective of the f_PT selection. is there a simple way to do this. All the answers I’ve seen are multiple lines of code. I need to redo this 6 times within the survey, and the risk of error is great.

Can you also provide the column headers of your screenshot of the survey sheet, please?
Or even better, a working/checked extract of your form?

1 Like

Sample.xlsx (12.0 KB)

I’m adding a sample of the worksheet here since I am unable to share the entire survey file; I was looking for a simple code that could help force me to add the name ‘no’ options in the follow up questions 6(a) and 6(b).

I’d gone through a couple of other solutions, but there are several calculations involved, and I didn’t want to keep repeating it in multiple areas in case I make a mistake.

@dhd, this post discussed previously should help you solve your issue:

Do we not have a simpler solution for this? This is 4 lines of additional code - which I need to repeat for 5 other questions. This survey form is already 800 lines long and the choices sheet has 2000+ records. I was wondering if something simpler was available?