Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
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
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.
More info:
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Hi Vasanth
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
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.
