Pull dropdown menu options from one sheet into another based on a defined cell

Hello,

I am curious if there is a way for Smartsheet to populate a designated column in one sheet with dropdown options from another sheet based on the conditions of a cell in the sheet the dropdown should appear in. For instance, if Sheet A has a specific value in the cell, you can pull in the dropdown menu from Sheet B into a different cell in a corresponding column. So, something along the lines of "only show me the dropdown options of Sheet B, column 1 IN Sheet A, column 5 IF Sheet A, column 1 has the value X" I have a picture too of what I'm thinking I'm trying to do. I want to be able to select options from the dropdown list of a column in Sheet B that is feeding into Sheet A. Thank you!

Find more posts tagged with

Formulas

functionality

Workflows in Smartsheet

Accepted answers

All comments

Darren Mullen

@Miriam Nothing built into Smartsheet Core. If you have Smartsheet Bridge you could work something up, or there is this Dropdown Manager available that may do what you want, if I follow your example correctly :)

https://www.youtube.com/watch?v=IDMe0vjBCck

Miriam

Thanks, Darren. I was hoping there'd be something built in. I appreciate your response!

jmyzk_cloudsmart_jp

Hi @Miriam

This is an old comment, but it may be useful for some users wanting dynamic dropdown list-like features with the core capabilities.

In short, the solution displays a cell like the one below to let users choose 03 for Japan, for example;

01 China
02 Korea
03 Japan
04 USA

https://community.smartsheet.com/discussion/105722/dropdown-list-alternative-with-automatic-list-update-and-dynamic-list-features

Automatic List Updates:
- Users frequently request a feature to link dropdown lists to a master sheet, allowing changes to the master sheet to be automatically reflected in all linked dropdown lists.
- Since this functionality is unavailable, users must manually update the lists, creating inefficiencies.
Dynamic Dropdown Lists:
- Users seek dropdown lists that change dynamically based on previous selections. While some workarounds exist, such as using form logic, they require pre-configured columns and work only in specific contexts like forms.

Workarounds and Proposed Solutions:

Numeric ID-Based Dropdown Lists:
- A method where users select items by entering corresponding two-digit numeric IDs. This approach is less intuitive than direct selection but simplifies input for large lists.
- A sample dashboard demonstrating this approach is shared via Smartsheet.
Improved Display of Candidate Lists:
- Formulas dynamically display dropdown options from a master sheet based on user input. This mimics dynamic dropdowns and reduces the clutter of long lists.
Access to Demo Contents:
- These methods are demonstrated via published Smartsheet dashboards, with links provided for users to explore and replicate the solutions.
Request for a copy of the solution available from a form

Miriam

Interesting concept jmyzk, thank you for sharing!

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.