The ability to setup a sheet that deletes dates as they are full?
Hey team, we are working on a sheet for people to sign up for different class dates. We are limited with the number of seats for each class. Can we set up the sheet so when that date is full, they are no longer able to choose it?
Answers
-
Hi @Michael C
What is the current structure of your sheet, and how are your users going to sign up?
Without knowing too much about your scenario, I would potentially set up a sheet that is pre-filled with all the possible dates/times and classes. Then I would use a Report to only surface the rows that are not filled in yet to show what's available. This can be set as a Gantt chart if you want to show a timeline on the side as well. 🙂
Would that work for you?
If you're looking to remove options from a drop-down automatically, you would either need to use DataShuttle or Bridge to help clear out values from a column. Here's an explanation of the Data Shuttle set-up in another Community thread.
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
Genevieve,
Thanks for the information, I will be researching the Data Shuttle option!
Cheers,
Michael C
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives