Dynamic view, request editable option in table or Sheet view permission by rows

Shashank

Hi, I'm looking for a way to restrict the view of a sheet so that each user only sees the rows where they are assigned. I know this can be done using Dynamic View, but I want users to be able to update multiple rows directly in the sheet, without having to open each row individually in a form.

I also understand that I can create reports to that respective user and share the report, but the main sheet I am using is updated automatically via excel and we don't know when a new user will be added, so making report for all user is not a feasible option.

Here's the situation:

• I have a sheet with columns for Resource Manager, their Assignees, and Assignment Hours for next week.
• I want to send this sheet to each Resource Manager so they can fill in the hours for their own team members.
• Each Resource Manager should only see and edit the rows assigned to them, directly in the sheet —not through individual forms.

Is there a way to filter or restrict the view in a report based on the current user, so they only see their own rows?