Is is possible to have part of a google doc hidden publicly but able to be edited and “pushed” to LIVE?

Question

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?

Answer 1

I found a way, but it's not an elegant one:

1. Use a master sheet to prepare your data, publicly shared.
   I've created a file myself: master sheet
2. Create a public sheet and use the IMPORTRANGE formula.
   See example file I created: public sheet
3. Use Google Sites to display the public sheet via an iFrame:
   Use the iFrame Wrapper created by Mori.
   See example website page I created: Google Sites Page

This way the key of the master sheet is not traceable.

Follow this question I've asked about finding public documents.

Answer 2

After having done some research and having asked the right questions, I can present you this solution:

1. Use a master sheet to prepare your data.
   I've created another one: Mastersheet - ARRAYFORMULA
   But here's the catch: if your interested in this answer, send me an e-mail (see my profile) and I will add you to the privately shared file.
2. Create another sheet to hold the public data.
   Use the ARRAYFORMULA to retrieve only the first two columns.
3. Publish the public sheet:
   
4. Select the sheet named Public:
   
5. Select the URL to publish:
   
6. You can send out the URL or display it on a website

For the sake of transparency, I've not deleted my previous answer.