Drop down list from another sheet
How do I utilize data from another sheet or excel file to create drop down options on a form?
For example, I have a file that contains employee names, emails, job titles, job codes ect and I have a smartsheet that I would like to have a drop down list for each of these options that employees can select from on a form that is connected to the sheet. So if they start to type in their name on the form, it will populate their name to choose from the drop down list.
I've tried to use datashuttle, but it actually takes it away from the form (unless I'm doing this wrong?!).
Any help is appreciated! Thank you!