Survey123 select_multiple with specific relevant follow up questions

[LillianNix819]

I'm working on creating a Survey123 Connect form with one of the multiple selection questions being "Equipment Used" which consists of the options: handline, truck, broadjet, UTV, or backpack. I would like for a follow up question "Truck #" and "UTV #" to appear whenever Truck or UTV are selected. However, the issue I am running into is that whenever you select another Equipment Used option, the follow up question no longer appears. For example: if you select "Handline" and "Truck" then "Truck #" does not appear. Same goes for if you select "Truck" and "UTV" neither "Truck #" or "UTV #" follow up questions appear. There could be any variation/combination of equipment used. 

[Neal_t_k · Accepted solution]

When you use a select multiple, the answer results in a comma delimited list.

For that reason use have to use the Selected() formula instead of "=".  So for instance if you want it relevant when truck is selected you would use selected(${Equipment_Used}, 'Truck').  Which would essentially look for any instance of Truck in your list.

Keep in mind you want to match the name column in your choice list and not the label.

https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm

[LillianNix819]

Thanks! That worked.