Multi Select DropDown list from data on another sheet
I am wanting a multiple select drop down list that gets its data from another list.
Basically I have a list of our equipment along with the current cost in another column. in Column 3 I have combined text of equipment name + price . I want this to be my drop down list in another sheet that will be the equipment order request form. The user can select which items they need ordered and see the current cost/price from column 3 in the cost sheet.
Answers
-
Unfortunately, SS does not support dynamic lists/dropdowns currently so you are out of luck on this one. Feature request has been submitted in the product feedback forum by few users.
-
Hi @heathermax
I hope you're well and safe!
If I understand your question correctly, it should be possible with the Premium App, Data Shuttle.
More info:
Is that an option?
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 support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. 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.
-
@Sameer Karkhanis do understand this correctly? I have a running list of employees in my Staff Sheet; [last][first][full name][contact][department].... I want to use this information in another sheet Dispatch log [patroller].
The Dispatch Log is tracking numerous events that I send patrollers to , I want to pull [full name] from Staff Sheet, into Dispatch Log such that when I start typing Joe B... Joe Baur, Joe Basset, Joe Burrow is displayed until I either pick or my only option is Joe Burrow.
The Staff Sheet will be continually updated so I would rather not have to update the Drop List Option.
I can do this in excel relatively easily
-
@Sameer Karkhanis understand that the above cannot be done?
-
I hope you're well and safe!
Unfortunately, it's not possible now, but it's an excellent idea!
Here's a possible workaround or workarounds
- Premium App, Data Shuttle
- Smartsheet API
- 3rd-party solution
Is that an option?
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 support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. 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 @SkiPatrolScott,
I've been asked to look at Smartsheet for the Mt Hotham Ski Patrol in Australia (replacing MS Access). How far along are you with Smartsheet and dispatching Patrollers and equipment? We want to integrate access by the Medical Centre staff to update Casualty records as well.
Regards, Jim
-
Hi,
I think I have the solution for you. You can use this combined column as your SOURCE DATA
by using a tool that I built. You can see how it works in this demo video: . If it seems like a good fit for your needs, feel free to sign up to use this feature.David Jasven | Workflow and Business Process Consultant / CEO @ Must.do
SMARTSHEET EXPERT CONSULTANT & DEVELOPMENTW: www.must.do | E: smartsheethelp@must.do | WhatsApp: +1 347 380-7697
Feel comfortable to contact me for any help with Smartsheet, integrations, general business process advice, or anything else. I am more responsive on Whatsapp.
😍 If my response helped solve your problem, please consider marking it as Insightful, Vote Up, or Awesome. It helps the community find solutions more easily!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives