Controlling Drop Down Options with Logic?
We're going to send a form out across our enterprise asking recipients to prioritize their top 4 choices and we want to restrict them to giving only four answers.
Right now the user only gets to provide a second choice once the first choice has been selected and so on up until the fourth option after which it stops.
What I'm wondering, because I know I'm going to be asked, is if once a project has been selected from the drop down, can it be eliminated as an option from the ensuing selections?
My thoughts are that this is a little elaborate for the process today. But like I said, I know somebody up top is going to ask.
If somebody has another option to achieve the same result I'd love to hear it.
Many thanks in advance to anybody who can help.
Answers
-
Not possible at the moment. Best option is to add four columns with the same options and have them select for their 1st through 4th choice. It won't prevent them from selecting duplicates though.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 459 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 137 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives