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.

I have a form that gets filled. This obviously goes into Google Spreadsheets. I want a summery of this information to be publicly viewed. Kind of like the summery page in sheets but I want only certain columns from the spreadsheets to be in the summery.

Or if only certain columns can be visible publicly and not editable. Only fully visible and editable by the 2 admins (myself included).

Which ever way it gets done, I want the summery page to be live to whatever gets edited in sheets by the admins.

share|improve this question
    
So say, if the form would be a poll, you want to make visible only the results, right? –  Alex May 8 '12 at 21:46
    
Yes kind of. It's a beta form. I want 3 columns to be visible to the public. B,C,D. Now the information in C gets edited making it to reorganize the whole sheet, so I would want the results to shuffle for the 3 showing columns as well. Thanks –  drizzt09 May 9 '12 at 1:35
add comment

2 Answers 2

You cannot publish a part of the document. You have to publish the whole thing. But you can get a publish url that will show a part of the document, exactly like you want.

Once you Choose to publish the document, and click that "Start Publishing" button, you get this option -

enter image description here

share|improve this answer
    
Thanks for that. I was able to publish it as D1:E99 Question is though how would I get column B as well as the current D/E without column C? –  drizzt09 May 9 '12 at 13:16
    
That doesn't seem to be possible. If I find something, will update. In the meantime, you could try moving the not-to-publish columns to the left or right of other columns, if possible. –  Bibhas May 9 '12 at 13:56
    
Another option would be create a 2nd sheet. have the certain columns from sheet1 that I want to share update to sheet2. then publish all of sheet2. Is that possible? –  drizzt09 May 9 '12 at 17:19
    
Then you'll have to keep syncing the sheets. I think that would be another headache. Isn't that right? –  Bibhas May 9 '12 at 17:21
    
if you have to manually sync the 2 sheets.. yes. if there is something that made it autosync on change... then no –  drizzt09 May 10 '12 at 0:03
show 1 more comment

You can sync a portion of the 1st sheet on 2nd sheet automatically with this formula: ="[1st tab]!A1:C1000" This will, for example, sync first 1000 rows of columns A-C. Then, publish the 2nd sheet.

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.