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')))) |
Solved! Go to Solution.
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.
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.
Perfect. Thanks for your prompt response.