Form Dropdown from another sheet
I have a sheet with a table of employee names & job title for all users in the company
I have another sheet which logs the requests from these users.
So one sheet is a list of people and another is a log of items they request for.
I have a form to capture requests from the list of users to insert into the log of requests.
Since i cannot have a drop down of employee names as a column in my log sheet ( as per https://community.smartsheet.com/discussion/65787/how-to-populate-dropdown-value-list-from-another-sheet), SO I copy the list of names from the employee list sheet and insert it into the form field as a drop down for the user to select his name.
this then adds his name to the log using the exact text of his own name letting me match the two columns in different sheets for analytics etc.
So Currently when I add new employees to the employee list, I have to remember to add them to the drop down on the other sheet's form as well. maintaining two sets of lists is error prone and not ideal.
Please tell me there is a way I can update both at the same time or a smarter way of doing this seeing as we cant create a drop down list with values from a column in a different sheet.
p.s. please dont suggest I buy the premium "Data Uploader" to do what excel has been able to do for over a decade.