Hi, I'm looking for a way to restrict the view of a sheet so that each user only sees the rows relevant to them. 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.
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.
- Ideally, each Resource Manager should only see and edit the rows assigned to them, directly in the sheet or a report—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?
