AnsweredAssumed Answered

Update Calculated value based on 1 of 2 drop downs

Question asked by wilkies0106aw on Jan 13, 2017
Latest reply on Jan 13, 2017 by emha



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.