Lookup formula for Dynamic label value from Cascading drop-down

Forum|Forum|7 years ago
June 4, 2019
3 replies
20 views

G

+1

Greg_Holts

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

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

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

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

kshubert
Nintex Partner
Forum|Forum|7 years ago
June 4, 2019

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.