Survey123 Formula

Question

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'))))

dougbrowning · Accepted Answer

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.