I have a list of flags classified in three filters (drop-down lists). The problem is that the drop-down list does not work in reading mode, only in editor mode. I just wanted people to see the lists and be able to interact. Is it possible to use this option in some way without having to be in editor mode?
Editor mode https://imgur.com/keuA6mq
Reading mode (link shared) https://imgur.com/THz0yQk
The implementation you are looking for is not possible using view only (Read only) permission on Google Sheets due to the fact that when someone makes changes to the selected cell via the dropdown menu, this will count as an "Edit".
A workaround I could suggest is to set the view to Edit and protect all cells on the sheet with the exception of the cells with dropdown list (Data validation) and set the edit permission access to only yourself. Here's more information on how to protect an entire sheet or range/s of cells:
