Sunday, March 2, 2014

yogi_Display Value From A Range Withourt Spreadsheet Title Or Sheet Name Using Google Old Sheet

                                         Google Spreadsheet   Post  #1550
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI 
post by Abby Rudakov (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/-4p1vG4tGbQ)
Help displaying value from Google Spreadsheet online
Hi,

I've got a Google Form setup which takes people's details. In the Google Spreadsheet, I am calculating the total number of entries (via a count of the timestamps) and I would like to be able to display the total number online, specifically on a Blogger blog post. I have been able to figure out how to show the tab from my spreadsheet with the number, but it looks super ugly and I'm only really after the number not the headers and page tabs too. Any suggestions? TIA

---------------------------------------------------------------------------------------------------
in the following I present the iframe code to publish value from a range without spreadsheet title or sheet name using Google Old Sheets. You will have to adjust the width of the range to be published, the font color and background color to suit your need and/or preference.

to publish cell B2 with spreadsheet name and sheet name the iframe code is
<iframe width='500' height='300' frameborder='0' src='https://docs.google.com/spreadsheet/pub?key=0AkHBcyclu11AdGJZM2tRUjdlVFJVaXFJemhUUzZxcUE&single=true&gid=3&range=B1&output=html&widget=false'></iframe>
formula in cell B1
="so far over "&count('Form Responses 1'!A:A)&" people have taken the pledge"






I  am also posting here all the sheets from Abby's spreadsheet