Remove a dropdown option once selected
Is there a way to have a single select dropdown list where once an option is selected, it is no longer an option for others to select? I'm trying to create a sign up sheet where someone can volunteer for a specific date and time, but once that slot is filled, someone else cannot sign up for it. I'm trying to do this in a form to populate a grid. Thank you!
Best Answer
-
Hi @Chelsea LeBlanc ,
Smartsheets doesn't currently have the capability to dynamically change dropdown options. It would be a useful capability. You should suggest it as an enhancement, link below.
Mark
https://app.smartsheet.com/b/form/739aa75f30ca43a8a22eb53e4da7d409?ss_v=114.0.2
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Answers
-
Hi @Chelsea LeBlanc ,
Smartsheets doesn't currently have the capability to dynamically change dropdown options. It would be a useful capability. You should suggest it as an enhancement, link below.
Mark
https://app.smartsheet.com/b/form/739aa75f30ca43a8a22eb53e4da7d409?ss_v=114.0.2
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Hi Chelsea
I recently ran a webinar on how to create an Office Sign up solution in Smartsheet. Within it we show a number of solutions including a booking system which we have developed which will do what you are looking for, however it is using a webform with the data stored in Smartsheet.
There are ways of achieving what you are looking for though, using functions and automations. My email address is in my profile screen. If you want, I can either send you a recording of this webinar, so you can see if the tips and trick and I used in the demo can be of help to you, or if you'd rather attend a live webinar, I am repeating it in early Feb. There is a registration form on our website if you'd like to sign up.
https://www.smarterbusinessprocesses.com/new-for-2021-smartsheet-tips-and-tricks-webinars/
Kind regards
Debbie
-
@Debbie Sawyer I took a look at your link but unfortunately the webinars are later in spring. Looking to help our Revenue trainer set up pitch assessment slots this week and would love to take a look at your tips and tricks in the webinar if available? Thanks! Andie
-
Hi Yes, No problem - I'll send you a copy of the webinar recording. I'll also send you an evaluation form, if you fill that in after you have watched the recording there is an opportunity there to request a share to the demonstration workspace, so you can explore the different options we put together.
Kind regards
Debbie
-
Hi @Debbie Sawyer,
Could you send me a copy of the webinar recording for the office sign up solution/ booking system please?
I'm also looking to implement a desk reservation solution but have hit a stumbling block, and looking for a solution @Chelsea LeBlanc raised in this post.
Regards
Simon
-
Hi Simon, could you email me on debbie.sawyer@smarterbusinessprocesses.com and I will send a recording for the webinar as a reply.
I might also be able to help guide on on your stumbling block with the desk reservation solution, pop the issue in the email and I'll do my best to help.
Kind regards
Debbie
-
Hi! I'm trying to do the same thing, is there any way you can share the webinar recording?
-
Hi @Hammermill21 Thank you for finding my email and messaging me - I hope you enjoy the webinar and find it useful - don't forget we are running an enhanced version of the Office Booking webinar this week. Looking forward to seeing you there! :D
-
Kindly share the webinar recording with me too. I, too, have been looking for a sign up tool in my practice. Best, :)
-
@Vpena Thank you for emailing me - I have shared the link and an eval form, don't forget you can have an hrs free consultation following the webinar, if you'd like to discuss how to approach your particular requirement.
Kind regards
Debbie
-
@Debbie Sawyer do you still have the recording for your office sign up process within Smartsheet? I would like to see your build process.
-
Hi Erin
Yes, I can share this with you. Can you email me your Smartsheet email address and I'll share the workspace to you. My email address is debbie.sawyer@smarterbusinessprocesses.com
Thank you!
Debbie
-
@Debbie Sawyer would you mind sending me the recording as well? I can be reached at irene.cuevas@austin.utexas.edu.
Thank you in advance!
Irene
-
I have been asked for a recording link to my Office Bookings webinar by many, yesterday I sent it out again (which is great!) but it made me consider the original question again.
So just in case the webinar wasn't quite what you were looking for, we also have a Smarter Dropdown List Manager app which controls the values in a dropdown list which is configured at a central source. The source is able to be a report, so that you can always have the live active entries in your dropdown list values without having to edit the column properties constantly.
Please do get in touch if you are interested in finding out more.
Kind regards
Debbie Sawyer - Chief Smartsheet Solutions Officer (CSSO)
debbie.sawyer@smarterbusinessprocesses.com
-
Has there been any movement on the dynamic dropdown list? If not, does the Smarter Dropdown List Manager app come at an extra cost?
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives