So I have a public schedule for my business, but need to edit (which sometimes takes a few days) and then make "public"... Can I do that?
I know I can "hide" but when I reopen, it's live and everyone can access it...another way to handle?
After having done some research and having asked the right questions, I can present you this solution:
ARRAYFORMULAto retrieve only the first two columns.
For the sake of transparency, I've not deleted my previous answer.
I found a way, but it's not an elegant one:
This way the key of the master sheet is not traceable.
Follow this question I've asked about finding public documents.