How to data shuttle a column from two separate sheets into one dropdown list within a third sheet

Hello,

I maintain items on two different sheets, lets say sheet A and sheet B. On both sheets I have a column named 'Item Name' that contains the descriptive name of each item. I have created a thrid sheet, sheet C, that I would like to use as a separate tracker that references information from sheets A and B. One feature I would like to have on sheet C is an 'Item Name' column that is a dropdown list of all item name values from sheets A and B. Is this possible using data shuttle?

I have done this before when working with a single sheet to sheet data shuttle, for example setting up a dropdown list in sheet C that pulls in the item names from only sheet A. But, I am not sure if a data shuttle can be established that pulls in values from multiple sheets into a single dropdown.

Thank you.

Find more posts tagged with

Accepted answers

All comments

Darren Mullen

@FlynnH I suppose you could create a report with both sheets as sources, export the report, then use that report export as the DataShuttle source.

It wouldn't be fully automated though.

Do you have access to Smartsheet Bridge?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.