Relevant if not equal to

[CarlHolt1]

Currently have an equal in the Relevant field listed as 

${FLOAT}='SEWAGE' or ${FLOAT}='SHEEN' or ${FLOAT}='SILTY' or ${FLOAT}='SUDS' or ${FLOAT}='OTHER'   

Is there an equal similar to selected(${FLOAT}, !='NONE')?

[Jim-Moore · Accepted solution]

Hi Carl

The not() function might do the trick, as mentioned here: https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm

For example: not(selected(${FLOAT}, 'NONE'))

If ${FLOAT} is a select_one question, you could also use: ${FLOAT} != 'NONE'

Please let me know if either of these are useful in your case.

Best regards,

Jim