I have a sheet used as a "Maintenance Request" sheet. It is populated by a form. Each person submitting a request provides their name/email into the "Submitted By" column. This allows them to receive an alert once the job is complete.
I have frustration coming from the maint dept. when assigning a job/task in the "Designated" column. Every contact from the "Submitted By" column also shows up in the "Designated" drop down menu.
If I restrict the "Submitted By" column, to list values only.....Nobody would be able to enter their names. Additionally, if their names are added to just a text field, they wont receive the email confirmation, once the job is complete.
Is there a work around to a situation like this? I've tried so many different things but, nothing seems to work.