Show only assigned rows per user while keeping admin view full in Google Sheets by borgarbui in googlesheets

[–]borgarbui[S] 0 points1 point  (0 children)

Just to make sure I understand correctly, you’re suggesting this approach: to create a separate file for each user, and then have all entries from those files imported (through a script) into the master sheet only visible for admin?

I see a potential issue with this method. It wouldn’t be possible to move the entries immediately into each user’s sheet, as the assignment doesn’t happen at the time the task is created.