Can we add column items from one sheet to another sheet as the drop-down values?

Is this possible within Data Shuttle? It doesn't appear so to me as the source sheet has to be an attachment or from One Drive, Box, etc.


Is there any workaround to this to be able to take row items from a specific column in one sheet and generate the drop-down in another sheet?


Thanks in advance for any tips!

Best Answer

  • MVP OPS
    MVP OPS ✭✭✭
    Answer ✓

    Hello Kelly,

    With data shuttle you can solve the dynamic dropdown problem. You need to set up an offload data workflow of your source sheet first. Then you create an upload data workflow using the offload data as your source and then map your columns to your target sheet.

    Let me know if you have any questions.

    best,

    Brad

    MVP OPS

    best,

    Brad

    www.MVPOPS.com

Answers

  • MVP OPS
    MVP OPS ✭✭✭
    Answer ✓

    Hello Kelly,

    With data shuttle you can solve the dynamic dropdown problem. You need to set up an offload data workflow of your source sheet first. Then you create an upload data workflow using the offload data as your source and then map your columns to your target sheet.

    Let me know if you have any questions.

    best,

    Brad

    MVP OPS

    best,

    Brad

    www.MVPOPS.com

  • Thank you for your input! I thought I needed to add the offload data workflow as well but wasn't certain. Thank you for confirming.