Dynamic Dropdowns with Data Shuttle

I used Data Shuttle to populate two columns in one of my smartsheets (Region & Building) from another smartsheet.

I want to further refine for example: If Region = Americas it only pulls in Americas buildings. If Region = EMEA it only pulls in EMEA buildings. I tried doing an IF AND with Vlookup but that that becomes unparseable. Has anyone does this successfully?

IF(AND(VLOOKUP([Region@row]="Americas", {Report Range 1}, 2, false)), 

IF(AND(VLOOKUP([Region@row]="EMEA", {Report Range 1}, 2, false)), 

IF(AND(VLOOKUP([Region@row]="APAC", {Report Range 1}, 2, false)), 

IF(AND(VLOOKUP([Region@row]="India", {Report Range 1}, 2, false)))


  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi @MsMaryannM

    I hope you're well and safe!

    You would have to add multiple columns, one for each region, and also separate workflows in Data Shuttle to sync them. I recommend using Dynamic text instructions and/or Conditional Formatting to guide the user to the correct column.

    Make sense?

    Would that work/help?

    I hope that helps!

    Be safe, and have a fantastic week!


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!