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?
Editable Google Spreadsheet on Google site - assign username
google spreadsheets;google sites