cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Greg_Holts
Nintex Newbie

Lookup formula for Dynamic label value from Cascading drop-down

I need to populate a calculated value with data associated with a value selected from a cascading drop-down

Basically, when I select Business Unit

data_analytics.PNG

and then select Task (The control for the Task dropdown is Task_dropdown)

task.PNG

I want  the associated value from the Why column to display in a Calculated Value box

list.PNG

I have tried to use this formula, but I can't get it to work

formula.png

 

Labels: (1)
0 Kudos
Reply
3 Replies
kshubert
Nintex Newbie

Re: Lookup formula for Dynamic label value from Cascading drop-down

I think the issue may be due to your lookup calculation, I believe the lookup should be
lookup("Playbook_task","Title",Task_dropdown,"Why"). To clarify there should not be quotations around the variable and there should be a comma between "Title" and the Variable.
0 Kudos
Reply
Greg_Holts
Nintex Newbie

Re: Lookup formula for Dynamic label value from Cascading drop-down

Hi @kshubert 

Thank you very much for the reply

I used your formula and get the below:

newformula output.PNG

I have tried swapping out ' for " and vice versa, but nothing seems to work

0 Kudos
Reply
Greg_Holts
Nintex Newbie

Re: Lookup formula for Dynamic label value from Cascading drop-down

I got it working!

I swaped out 'Title for 'ID'

lookup("Playbook_task","ID",Task_dropdown,"Why")
0 Kudos
Reply