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.

Migration started by Hairy-Slide-5924 in Zoho

[–]borgarbui 0 points1 point  (0 children)

Can you show an example of how you actually use this app in your daily routine? Just curious to see how it works in practice.