How do I create mutually exclusive dropdowns?
Mutually exclusive dropdowns allow you to prevent the signer from filling in two dropdown fields when only one or the other is necessary.
In addition to the options you want to include in your dropdowns, you must also add N/A as an option as well. You must then add one trigger field for each option in the dropdown list, not including N/A. Give each trigger field an initial value of 1 and give each a different data label. Next, add two formula fields and set them to equal each group of trigger fields added together.
Ex. Formula1 = [Q] + [W], Formula2 = [O] + [P] (Q and W being the trigger fields for the first dropdown and O and P the trigger fields for the second dropdown)
Now create a conditional rule for each formula that makes the opposite dropdown appear only when the formula equals 0. Then set each trigger field to appear when their corresponding option is selected from the dropdown.
The result will be that selecting a value from a dropdown will make the other disappear, since a trigger field will appear and cause the formula to not equal 0. Selecting N/A will reset the formula to 0 and cause the other dropdown to reappear. Note that switching to the 'Select' option will not do anything because you cannot use it in conditional logic.
*arrows represent conditional rule pointing from trigger to field to appear