So here is what I am trying to do:
Have a Google site that has an embedded editable Google spreadsheet on that allows end users (if they have been given permission) to edit the spreadsheet.
Here is the purpose, I am trying to create a tasks list application that allows authorised users to view a list of currently available tasks (from Google spreadsheet) and then assign themselves a task (which will be one of the columns in the spreadsheet "assigned". Is there a way to have that column (assigned) a drop down box of the current user signed in? I.e. so when user 1 logs in to the site, any task they want to assign themselves will have a drop down option of blank or their name. The same goes for all other users.
Is that possible?