Hello,
I have a spreadsheet for data entry. In a hidden column, I have a column for 'Data submitter' (column B) which specifies the name of the person that enters data in that row. I then have a cell (E10) with a drop down selection that allows the data submitter to select their name (using...