topic Re: Multiple if calculation in ArcGIS Survey123 Questions

Multiple if calculation

Hammers211 — Tue, 26 Jul 2022 18:39:51 GMT

I have a survey that consists of 7 Yes/No/NA select_one questions. I would like to write a calculation that will evaluate those 7 questions, and if any of them are answered with a "Yes," a note is displayed with the text "Fail."

Here is what I have for my note calculation:

if(${Prohibited_List} = "Yes", 'Fail', 'Pass') or if(${Drug_Ingredients} = "Yes", 'Fail', 'Pass')

It does not return an error, but it does not function as I would like. I realize I will need to include all 7 questions, but first I'd like to get it working with just these first two.

Thank you!

Re: Multiple if calculation

ZacharySutherby — Tue, 26 Jul 2022 21:59:34 GMT

Hello @Hammers211,

You can consolidate the condition into one if() statement, for example if(${Prohibited_List} = "Yes" or ${Drug_Ingredients} = "Yes", 'Fail', 'Pass').

Re: Multiple if calculation

DougBrowning — Tue, 26 Jul 2022 22:03:48 GMT

When you use or no need for two ifs

if(${Prohibited_List} = "Yes" or ${Drug_Ingredients} = "Yes", 'Fail', 'Pass')