How to populate a Smartsheet form dropdown

Hello!

When using a Smartsheet form that is based off of a sheet, I want to be able to select an option from a drop down in the form, that currently exists in the sheet.

For example: I want all of Column A (Event Names), to populate into a form dropdown. That way I can use the form to edit event details.

Happy to provide additional details if needed!

Thank you!

Find more posts tagged with

Forms

Dropdown

Accepted answers

All comments

jjg279

Howdy, if I am understanding correctly I think all you need to do is change your column type to "Dropdown list"

The choices will autofill based on what you already have the column but you can edit them freely.

Naeem Ejaz

Unfortunately, Smartsheet forms don’t currently support dynamically populating dropdown options from existing column values (like all entries in Column A). Dropdowns in forms are static and must be manually set in the column properties.

chasehcowart

@Naeem Ejaz does the Smartkey add on fix this through the SmartDropdown feature?

Naeem Ejaz

Smartkey Add-on (if you’re referring to a third-party integration or custom solution) can enhance dropdown functionality by dynamically filtering values. ?

Andrée Starå

https://community.smartsheet.com/discussion/141581/how-to-populate-a-smartsheet-form-dropdown

Hi,

I hope you're well and safe!

Unfortunately, it's not possible at the moment, but it's an excellent idea!

Please submit this as Product Feedback or an Idea (If it hasn't been added already) when you have a moment.
Feel free to share the link to the Idea here so that others and I can add our votes.

Here's a possible workaround or workarounds

1️⃣ A solution that would be perfect for this use case is the premium add-on, Data Shuttle.

More info: https://www.smartsheet.com/marketplace/premium-apps/data-uploader

2️⃣ Premium App, Bridge

3️⃣ Smartsheet API

4️⃣ 3rd-party option/service

Would any of those options work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer. I appreciate it, thank you! 🙏

Deanna Vandermeer

Back in 2017, we experienced the exact same issue. The fact that Smartsheet still does not currently offer a way to maintain a datasheet to be used to populate drop down column lists as part of its core product. Our district's IT programmer actually created us a fantastic way to do this exact same thing utilizing Smartsheet's open API. We have been using it for years but it would be wonderful if Smartsheet could add this option to their core product. Not every industry can afford their premium apps.

Debbie Sawyer

SBP has an add on tool that does this for you. Its called Smarter Dropdown List Manager. See here for more details. https://smarterbusinessprocesses.com/smarter-dropdown-list-manager-2/

Its in our lowest priced apps and is a great little tool. You can populate dropdown lists from source sheets or reports. The dropdown lists can be in the Grid or in the Sheet Summary, the app updates regularly so the lists are up to date.

My email address is in my profile data if you'd like to reach out to find out more.

Kind regards

Debbie

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.