If Statements in Survey123

AFackler_NAPSG — Tue, 07 Jul 2020 20:14:34 GMT

I am trying to create a hidden field in S123 Connect that will automatically calculate a text value (Size field) based on an input from a previous integer question asking how many personnel are in a department. My criteria is as follows:

Personnel between 0-50 = Small
Personnel between 51-100 = Medium
Personnel is 101+ = Large

This has so far been my best attempt but I keep getting errors. I put this in the calculation column in the field I want the calculation to be done in. Any suggestions?

if({$total_personnel}0>=50,"Small",if({$total_personnel}51>=99,"Medium",if({$total_personnel}<=100),"Large")))

Re: If Statements in Survey123

DougBrowning — Tue, 07 Jul 2020 20:47:47 GMT

You need to write out both side of the check then put an and between. I think you were nesting it correctly. No need for a if on large since it is the only possibility left.

if({$total_personnel}>=0 and {$total_personnel}<=50,"Small",if({$total_personnel}>=51 and {$total_personnel}<=100,"Medium","Large"))

Try that. Hope it helps.

topic Re: If Statements in Survey123 in ArcGIS Survey123 Questions

If Statements in Survey123

Re: If Statements in Survey123