View for current user in sheet/report with editing capabilities other than Dynamic View
I have a sheet with tasks assigned to a variety of users. For security purposes I want each user to view and update only their tasks. What is the best way to accomplish this? With reports, a user has to have access to the whole sheet in order to edit their row. Is there any other solution other than purchasing the Dynamic View add on or coming up with some type of API?