Remove a dropdown option , if it is already selected
Surprised, this does not exist yet in smartsheet.
I am creating a sheet , All I want to do is once a timeslot has been selected by a customer, the timeslot should no longer appear in the dropdown or hide it or make it un selectable.
I am happy to explore the automation workflow option too, but there is no way to configure either.
I appreciate your solution in this regard asap.
Answers
-
Do you have access to the premium app Data Shuttle?
-
Hi Shar,
I hope you're well and safe!
It's possible with the Premium App, Data Shuttle, but it will not be instant.
Would that still work?
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 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.
-
sure , that works. Pls let me know the process for premium app option and how to configure it. I need to make this work asap.
appreciate your help
-
I'd be happy to help, but I need some more information.
Feel free to reach out through a pm or at andree@workbold.com
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.
-
My suggestion would be to create another sheet that has each of the options listed going down a column. Then in the next column you would use a basic COUNTIFS with a cross sheet reference to count how many times that selection has been made.
Then you would set up an Offload workflow through data shuttle to grab this list filter to only grab those rows where the second column equals zero (meaning it has not been selected).
Next you would create an Upload workflow through data shuttle to grab the data in the .csv file created by the offload and have it set to update the options in the dropdown column on the original sheet.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!