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?

2 Answers 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:
    enter image description here
  4. Select the sheet named Public:
    enter image description here
  5. Select the URL to publish:
    enter image description here
  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.


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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.