My Google sheet consists of a locked list of items and a single cell that can be edited. This cell acts as a search box to filter the list.

I want multiple users to be able to search at the same time. I would prefer not to do the "copy trick" since that requires users to have a Google account.

Is there a way to do any of the following:

  1. allow each viewer to access a unique instance of the document
  2. boot user off after x minutes; allow one user at a time
  3. (any other ideas?)
  • Welcome. Have you already read in support.google.com/docs or in this site about sheet and range protection in Google Sheets? Are you looking for built-in features only based solution or would you like to use Google Apps Script / Google Sheets API (the later is off-topic in this site)?
    – Rubén
    Nov 5 '19 at 1:13

If the users are not going to modify the file you can share it for view only and many can open and browse the file without making modifications. You can protect the sheets you want untouched too in case the others have edit permissions on the folder. I couldn't find a way, I have a file with drop down menues to select parameters and have the report show different values and still have to make a copy for each team so they can check their values in their files, otherwise when somebody changes a parameter it changes it for everyone

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.