two listboxen should be switched in dependence. If “Year” is selected, “FiscalYear” must be deselected. If “FiscalYear” is selected, “Year” must be not selected. Thanks for help.
As DataNibbler said, you want to set Field Event triggers on both fields, so "OnSelect" you'll add an action to clear the opposing field. This can be found in the Settings > Document Properties then Triggers tab.
try with some sheet-level triggers - add an action on both the fields [Year] and [FiscalYear], to clear any selections on the other field respectively.
As DataNibbler said, you want to set Field Event triggers on both fields, so "OnSelect" you'll add an action to clear the opposing field. This can be found in the Settings > Document Properties then Triggers tab.
