Dynamic Dropdown List on Form
I'm working on creating a form for travel document submission. They have to submit travel documents by specific trip number. I want to make the drop down list for trip numbers dependent on the division the select. ie They select Division A, they only get a list of trip numbers for Division A.
Additionally I want to limit the trip numbers from being used more than once. I'm guessing that would be a dynamic dropdown as well.
Answers
-
@DPS Finance great question! I think the solution might depend on the amount of data …. department and Trip numbers. You could create for each department one column and use the logic in forms..
If my comment helps you, I appreciate a 💡
Kind regards
Nico | LinkedIn
CEO | Lighthouse Consultings
Lecturer in Business Information Systems | DHBW
________________________________________________________________________________
addvalue@lighthouseconsultings.com
We offer Licenses - Training - Solution Engineering
🔴 GOLD Smartsheet Partner _______________________________________________
💯 SCALEABLE Solutions Engineered by Lighthouse Consultings
We Don’t Just Implement Smartsheet; We Revolutionize How You Manage, Plan, And Execute.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 438 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 509 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Trending Posts
- I want to use Power Automate to send a professionally formatted email with Smartsheet data embedded in it. For example, Power Automate would receive the person's name, email, and pre-filled form's lin…
- Hello! Happy Friday! 😀 I am currently working on creating a Supply Request Tracker that will allow the requestor to upload their excel file with the list of needed supplies to a Smartsheet form conne…
- I setup a new Smartsheet and am connecting it to Jira Cloud. All fields are syncing properly except the Team field. I have the column set up as text number but have also tried it as a Drop Down list. …
