I've a form variable which is connected to a SP column.
I've a calculated value which is connected to the form variable.
I've 2 panels. Each panel has a drop down with the same information (1 panel will be hidden depending on who you are).
I'm playing with various formulas in the form variable I just can't get this syntax correct.
Depending on which drop down you select I want the value of the form variable to update and be reflected in the calculated value.
i.e. if dropdown 2 is blank, but drop down 1 isn't show drop down 1's value and vice versa.
I'm looking for a no code/no workflow solution ideally.