I would like to have 2 dropdowns that reference a column in two separate sheets.

@David Jasven is it possible to link multiple columns from one sheet to another using Submit? For instance, I have a sheet called Customers. I would like the user to be able to choose a customer name from the linked dropdown in a sheet called Jobs. That choice would ultimately import the fields Customer Name and Customer Number from the sheet Customers to the sheet Jobs. Additionally, I have a sheet called Equipment. I would like for a dropdown to be populated from it as well so the user could select the applicable equipment for the job. Any help you can offer would be great!

Answers