Google Spreadsheet Post #1754
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Sep-07-2014
post by gbah:
(https://productforums.google.com/forum/#!mydiscussions/docs/badkFo_BXvk)
Query a closed NEW Google Spreadsheet
I am using New Google Spreadsheet, I have migrated my project over from the old sheet. The problem I have is that when i do a web query to the google sheets the spreadsheet shows nothing. if the spreadsheet is opened then all is fine. I am using query visualization (select A, B,) EXAMPLE
---
here it is again i hope is edit version
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Sep-07-2014
post by gbah:
(https://productforums.google.com/forum/#!mydiscussions/docs/badkFo_BXvk)
Query a closed NEW Google Spreadsheet
I am using New Google Spreadsheet, I have migrated my project over from the old sheet. The problem I have is that when i do a web query to the google sheets the spreadsheet shows nothing. if the spreadsheet is opened then all is fine. I am using query visualization (select A, B,) EXAMPLE
---
here it is again i hope is edit version
---
so i have been unable to find away to add week number function to a query url unless ip put it in manually. is there away to place the date in sheet1!N1 and have the query url reference that cell select A,B,C,D,E Where C="sheet1!N1" i have tried tjis approac and all i get is the headers of each selected columns
No comments:
Post a Comment