topic Re: Survey123 Formula in ArcGIS Survey123 Questions

Survey123 Formula

JasonSimpson — Wed, 16 Jun 2021 14:24:24 GMT

I am trying to populate a comment box with a specific comment based off the answer from a multiple choice question. There are three total choices for the multiple choice, Compliant, Non-Compliant, No Comment. The formula I have come up with is below.

(if(selected(${VSMPSWPPP_SWPPP_MS1},'Compliant'), 'In Compliance',if(selected(${VSMPSWPPP_SWPPP_MS1},'Non-Compliant'), 'Non-Compliant Comment'), if(selected(${VSMPSWPPP_SWPPP_MS1}'N/A'), 'SWPPP Not Inspected'))))

Re: Survey123 Formula

DougBrowning — Wed, 16 Jun 2021 14:32:42 GMT

You have a ( at the beginging and a ) and , in the wrong spots. Also you need the else part on the last if. I just gave it '' for now (this would be the case where nothing at all is selected).

if(selected(${VSMPSWPPP_SWPPP_MS1},'Compliant'), 'In Compliance',if(selected(${VSMPSWPPP_SWPPP_MS1},'Non-Compliant'), 'Non-Compliant Comment', if(selected(${VSMPSWPPP_SWPPP_MS1}, 'N/A'), 'SWPPP Not Inspected', '')))

Try that.

Re: Survey123 Formula

JasonSimpson — Wed, 16 Jun 2021 15:57:41 GMT

Perfect. Thanks for your prompt response.