topic Re: Relevant if not equal to in ArcGIS Survey123 Questions https://community.esri.com/t5/arcgis-survey123-questions/relevant-if-not-equal-to/m-p/844087#M21676 <HTML><HEAD></HEAD><BODY><P>Hi Carl</P><P></P><P>The <STRONG>not()</STRONG> function might do the trick, as mentioned here:&nbsp;<A href="https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm">https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm</A></P><P></P><P>For example: not(selected(${FLOAT}, 'NONE'))</P><P>If ${FLOAT} is a select_one question, you could also use: ${FLOAT} != 'NONE'</P><P></P><P>Please let me know if either of these are useful in your case.</P><P></P><P>Best regards,</P><P>Jim</P></BODY></HTML> Wed, 08 May 2019 07:19:41 GMT Jim-Moore 2019-05-08T07:19:41Z Relevant if not equal to https://community.esri.com/t5/arcgis-survey123-questions/relevant-if-not-equal-to/m-p/844086#M21675 <HTML><HEAD></HEAD><BODY><P>Currently have an equal in the Relevant field listed as&nbsp;</P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P>${FLOAT}='SEWAGE' or ${FLOAT}='SHEEN' or ${FLOAT}='SILTY' or ${FLOAT}='SUDS' or ${FLOAT}='OTHER'&nbsp;&nbsp;&nbsp;</P></BLOCKQUOTE><P>Is there an equal similar to&nbsp;selected(${FLOAT}, !='NONE')?</P></BODY></HTML> Tue, 07 May 2019 19:37:36 GMT https://community.esri.com/t5/arcgis-survey123-questions/relevant-if-not-equal-to/m-p/844086#M21675 CarlHolt1 2019-05-07T19:37:36Z Re: Relevant if not equal to https://community.esri.com/t5/arcgis-survey123-questions/relevant-if-not-equal-to/m-p/844087#M21676 <HTML><HEAD></HEAD><BODY><P>Hi Carl</P><P></P><P>The <STRONG>not()</STRONG> function might do the trick, as mentioned here:&nbsp;<A href="https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm">https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm</A></P><P></P><P>For example: not(selected(${FLOAT}, 'NONE'))</P><P>If ${FLOAT} is a select_one question, you could also use: ${FLOAT} != 'NONE'</P><P></P><P>Please let me know if either of these are useful in your case.</P><P></P><P>Best regards,</P><P>Jim</P></BODY></HTML> Wed, 08 May 2019 07:19:41 GMT https://community.esri.com/t5/arcgis-survey123-questions/relevant-if-not-equal-to/m-p/844087#M21676 Jim-Moore 2019-05-08T07:19:41Z