Optional Section - Hide Control Based on Multiple Fields

draghuna — Thu, 19 Feb 2015 05:12:56 GMT

I have a form with optional section that I am trying to display only if user selects NA (Not Applicable) from one of the six drop down fields (Fields 1 through Field 6).

I have set the main property of the optional section to "Include the section in the form by default". Under conditional formatting, I tried to say Field 1 is "Not Equal To" NA OR Field 2 is "Not Equal To" NA OR... through Field 6 is "Not Equal To" NA then Hide the Control.

Doing this, enables me to show the control only if all fields are selected as NA. I am trying to enable section, if any of the field has NA selected. Can someone assist with a solution?

Thanks

Controls

Optional Section - Hide Control Based on Multiple Fields