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:
- allow each viewer to access a unique instance of the document
- boot user off after x minutes; allow one user at a time
- (any other ideas?)