DropDown list - from another Sheet

Vasanth Balakrishnan

hello ,

i have a huge list to be added in Dropdown, Does Smartsheet have option to pull the Dropdown from another sheet, (similar to excel spreadsheet).? Since the list will be Dynamic, editing the downdrop list everytime is time consuming.

thanks

Vasanth

Andrée Starå

Hi @Vasanth Balakrishnan

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

Please submit an Enhancement Request when you have a moment

There are some possible workaround options.

• Smartsheet API
• 3rd party service
• A solution that could be perfect for this use-case is the premium add-on, Data Uploader.

More info: 

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

Would any of those options work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

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

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

David Jasven

Hi Vasanth

https://community.smartsheet.com/discussion/74046/dropdown-list-from-another-sheet

Hi Vasanth,

I understand the challenge you're facing with managing dynamic dropdown lists in Smartsheet. I had the same need and found it cumbersome to update the dropdown manually every time. To solve this, I developed a solution that allows dropdowns to auto-populate based on a column from another sheet, similar to how it works in Excel.

You can see how it works in this demo video: . If you find it useful, you can sign up to use this feature.

Feel free to reach out if you have any questions or need further assistance.

Thanks,
Dave

https://youtu.be/8AYfwDlMoDg?si=jqPfwd22YIAdDQKh

agbush

this is sooo fundamental for me - getting the ability to define a lookup field based on a drop down list of values from another sheet.