Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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?

share|improve this question
add comment

2 Answers 2

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.

share|improve this answer
add comment

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.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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