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?
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this communitySo 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:
ARRAYFORMULA
to retrieve only the first two columns.For the sake of transparency, I've not deleted my previous answer.
ARRAYFORMULA
is the use of arrays in the new Google Sheets (instead of =ARRAYFORMULA(A:B)
use ={A:B}
). See Using arrays in Google Sheets
– Rubén♦
Aug 6 '15 at 18:45
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.