cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Update Calculated value based on 1 of 2 drop downs

All,

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.

Thanks

Labels: (1)
0 Kudos
Reply
1 Reply
Workflow Hero

Re: Update Calculated value based on 1 of 2 drop downs

Depending on which drop down you select I want the value of the form variable to update and be reflected in the calculated value. 

is it the same form variable you mention at the very beginning? I'd assume yes, otherwise you wouldn't mention it...

then this is not going to work. SP column is only updated after you submit form.

if you want to follow changes within the form you have to set names to the single controls. these names then appear in formula builder as 'named controls' and you have to use these in formulas

if dropdown 2 is blank, but drop down 1 isn't show drop down 1's value and vice versa.

something like this should work

if(isNullOrEmpty(DD2),if(isNullOrEmpty(DD1),"Both DDs are empty",DD1),DD2)

0 Kudos
Accept as Solution Reply