Dynamic Dropdown List on a Form
Relatively new user, currently have smartsheet deployed in my production operations and scheduling areas. A little background on what how I'm using smartsheet and my question...
I have a production schedule that is used to track new orders as they come through completion. Simple sheet setup by date with customer information and product separated into columns; as orders are ready for fulfillment, they are marked (check box) as "Ready" by the production scheduler and once completed they are again marked (check box) as "Complete" by an employee. Once an order is confirmed complete and ready for shipment, the last checkbox is selected to indicate an order is "Shipped" which also moves the order to a separate archive sheet. All of this works great, but we had to do something for QC to monitor outgoing shipments, so...
I setup a form on a separate sheet for employees to take pictures of the orders as they are fulfilled and it works great with one exception...the identification number used to track orders is being typed in on the form and it is resulting in too many errors.
The operation I would like to see happen is when a given order is checked as "Ready" to fufill, have the order ID number populate a drop down list on the form so all an employee has to do is select the correct customer, take the pic and submit.
Is this possible? I'm open to moving the form the primary production scheduling sheet if that makes a difference in linking to the correct cells...nothing is set in stone.
Thanks in advance for any and all comments/suggestions!