Search code examples
google-sheetspermissionsspreadsheetuser-permissionsrestriction

Restricted about what the elses who's people can edit with ? On protected of sheet and range by protected sheets option


I was setting that about protected sheets on my sheet is turning it on. With the specific setting those are :

  1. Restricted by just only me (owner) can edit the whole sheets and range.
  2. Anyone doesn't allowed or haven't a permission to edit anything except a range I desired to allowed to people to edit.

But the problem is : When I'm trying to become anyone (who doesn't have that permission) and open it on my g.sheet mobile was get on an update before it but point is. It just open ans work by once only every single I open it everytime. That's always happend when after I made a single changes with the ranges which is have an allowed ranges.


Solution

  • I think I was did a mistaken because it was twisted about something what just did supossed be I'm not do. What I've just do to resolved this is just make them twisted it back to supossed be happend. It's about I've given a granted of an access for a special people (add an user as editor) for an particular ranges meanwhile it supossed be not happend to me to do that. And the other changes has an given access to that user as a viewer in a shared and manage option. What is the right way for supposed be happend is make them a twistedd back of those of both setting what I've just done an above I've mention it.