topic If statements in ArcGIS Survey123 Questions

If statements

deleted-user-q9dwpTdLbTzp — Tue, 14 May 2019 14:09:05 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 about 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"))))

Re: If statements

KenBuja — Tue, 14 May 2019 14:14:33 GMT

Is this for Survey123? Please add some tags or text indicating what software you're asking about. Also this space is for asking questions about GeoNet itself. Please move this to the appropriate space

Re: If statements

Anonymous User — Tue, 14 May 2019 21:32:49 GMT

Duplicate question in Survey 123 https://community.esri.com/thread/233754-survey123-if-statements