google sheetsgoogle-shared-drive
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:
Create a Google Form, which people can use to record their purchases. Just let people access the form and not the sheet.
The form will submit the results to a Google Spreadsheet. Keep the data in this sheet and put any calculations etc. into a different sheet that reads from the first one.
Since 2020-06-02 it is possible to have multiple links mixed with text - Google Sheets introduced me to this feature. This feature seems to be public (it is not some internal test), since I found it in official documentation:
Tip: You can add multiple links in a single cell in a spreadsheet. To add multiple links > in a cell, highlight the text you want to link. Then, at the top, click Insert link Insert link or press CTRL + k or ⌘ + k on your keyboard.
Cell correctly renders text with the links. List of links will pop up when cell is selected:
Edit: One thing that does not work is preserving this links through expressions. For example i use =FILTER(main!A:M, main!B:B="favourites") to create filtered view. While link only cell displays properly, links mixed with text to not render correctly in this view.
Best Answer
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