Nested IF statement in XLSForm

Miguel-Fernandez — Sun, 12 Dec 2021 09:34:06 GMT

Good afternoon,

I am struggling with creating a nested if statement in the XLSForm for Survey123 Connect. I have a select multiple question that I am trying to count the number of times a selection is made. This is done through a hidden question type with a formula. For example, I have options in the select multiple list for Route 1 EB, Route 1 WB, Route 2 EB, Route 2 WB. Then in a dashboard I have a serial chart with counts for Route 1 and Route 2, etc. I am wanting the counts for Route 1 EB, WB, etc to be added in the hidden question total_route_1. In the survey, Route 1 EB could be selected, Route 1 WB could be selected, or both could be selected. This is the formula I have written and I can't seem to get it to work.

if(selected(${routes},'route_1_EAST') and not(selected(${routes},'route_1_WEST'),1, or (selected(${routes},'route_1_WEST') and not(selected(${routes},'route_1_EAST'),1, or (selected(${routes},'route_1_EAST') and selected(${routes},'route_1_WEST'),2,0))))
‍

Any help would be appreciated.

Thanks,

Miguel Fernandez

Re: Nested IF statement in XLSForm

DougBrowning — Tue, 01 Oct 2019 19:22:54 GMT

You need to use the if part each time. You cannot just give more conditions.

So need to do this
If(condition, yes, if(condition, yes, no))

topic Re: Nested IF statement in XLSForm in ArcGIS Survey123 Questions

Nested IF statement in XLSForm

Re: Nested IF statement in XLSForm