Restricting dropdown lists using VLOOKUP

Gopikrishna Mamidipudi
Gopikrishna Mamidipudi ✭✭✭✭
edited 12/09/19 in Formulas and Functions

Depending on values in one column I want to restrict the dropdown list in another column

Example: I have a sheet: Employees

Role            Name

------            -------------

PM              Jane

PM              John

Dev            Mark

Dev             Stephanie

In another sheet where Tasks I have these same two columns

Role and Name

Once I enter the Role (say PM) it should automatically reduce my dropdown list in the Name Column to (Jane and John).


Is this possible?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!