topic Re: Survey123 IF statements in ArcGIS Survey123 Questions

Survey123 IF statements

deleted-user-q9dwpTdLbTzp — Tue, 14 May 2019 14:23:41 GMT

I'm trying to do a Foot Candle Reading calculation for a lighting assessment. Basically, I need it say "Too Dim" if it's below 0.5, "Too Bright" if it's above 5 and "OK" if it's anything else.

The formula I have in excel is =IF(E6<0.5,"Too Dim",IF(E6>5,"Too Bright","OK"))

I've tried a combination of this:

if(selected(${fcr}"<0.5","Too Dim",if(selected(${fcr}">5","Too Bright","OK"))))

Is this possible or too complicated?

Re: Survey123 IF statements

BrandonArmstrong — Tue, 14 May 2019 20:31:01 GMT

Hi Travis,

Have you considered using a constraint with constraint messages to restrict input to the values you specified?

For instance, you can place the following in the Constraint column

.>0.5 and .<5

and then also provide a Constraint message that states "Value needs to be between 0.5 and 5"

Please refer to the attached XLSForm and linked documentation as an example...

Survey123 - Contraints

Best,

Brandon

Re: Survey123 IF statements

KassandraRodriguez — Tue, 14 May 2019 22:21:50 GMT

if(${fcr} < 0.5, 'Too Dim', if(${fcr} > 5, 'Too Bright', 'OK'))

Try this and I think it would be helpful if you made fcr a decimal type