Reassign a task

I have a sheet which has many different controls with owners assigned (and also a delegate column) which need to be updated on a frequency. I have created a report with "current user" so those assignees can log in and see only those assigned to them for updating. It appears that any drop down column can not be updated via a report which causes an issue. What is the best way to perform for due to this limitation. I need the owner of the control/task/row to have the ability to update the delegate column as the owners are at a high level and most likely will be delegating to someone on their team to complete but they will still need the ability to view the status of all of their items.

Best Answer