1
vote
0answers
7 views

How to automatically refresh date in google spreadsheet published to the web?

I am using google spreadsheet to maintain a register of all students in my school and track their monthly payments. Each student has a separate google spreadsheet maintained and in the spreadsheet I ...
0
votes
2answers
33 views

Rename Column in Google Spreadsheets

Does anyone know how to rename a column in google spreadsheets? Seems easy enough in excel. https://productforums.google.com/forum/#!topic/docs/ewnE52j57YU I was hoping that ideally I could see what ...
0
votes
1answer
29 views

How do I move a Google Spreadsheet document from one Google account to another?

I created a moderately complex Google Spreadsheet document in my personal account, which become popular amongst my colleagues and is now officially adopted by our team. Therefore, it would make sense ...
-1
votes
1answer
78 views

ImportHTML spreadsheet function to update every 5 mins

I have a Google spreadsheet fetching stock exchange data using an ImportHTML function: =ImportHtml("http://www.xxxx.xx.xx/xxxxxxxx/livefeedfull.aspx/?"& year(now()) & month(now()) & ...
0
votes
0answers
41 views

Transfer data from a form to a new spreadsheet

I have a simple form that inputs entries into a spreadsheet in Google Doc's. All I want to do is open a new sheet and import the data from the forms spreadsheet so I can manipulate it in my own way. ...
0
votes
0answers
24 views

How can I add new row value to mentioned column in the sheet which has multiple columns with unequal lenght?

I have three columns in spreadsheet with unequal row length. For example, Column A has 5 row, column B has 7 rows and column C has 2 rows. When I wanted to add for example column A with the AddRow ...
1
vote
0answers
81 views

Can I make a Google spreadsheet deploy as a web application?

Well, this is what I'm planning to do: my spreadsheet looks almost done to me (a few changes here and there of course, but that'll continue forever). I want to deploy it as a web-app and then who ...
1
vote
0answers
52 views

Way to automate collection of goo.gl data into Google Spreadsheet?

Is there a way to automatically collect analytics data from goo.gl into Google Spreadsheets or Excel? Specifically I am looking to automatically bring the total clicks from my links into a spreadsheet ...
1
vote
1answer
90 views

Make dynamic array blank based on adjacent values in Google Spreadsheets

I'm attempting to indicate certain months that fall between the end of one period and the beginning of another. I have the months of the year in column C: values 1 through 12. It's a running snapshot ...
1
vote
1answer
34 views

sharing only select rows

I'm trying to create a sheet with data compiled via application forms which are filled out by many people. I want to be able to edit that information and share portions of it with the people who fill ...
1
vote
0answers
184 views

Repeat an FILTER or ARRAYFORMULA n times in Google Spreadsheets?

I would like to repeat an ARRAYFORMULA or FILTER n times. Let's assume I have A 1 a 2 b 3 c Now I set =ARRAYFORMULA(A1:A3) and I get the same output. But now I want it to repeat n times, ...
1
vote
1answer
43 views

How to COUNTIF cells are years in Google Spreadsheet?

I have several dates in let's say A1:A with this syntax: dd/mm/yyyy and I would like to COUNTIF the cells are years. I had this first: =COUNTA(UNIQUE(YEAR(A1:A))). But that didn't work.
1
vote
0answers
450 views

Google Drive Form doesn't display on Google sites if not signed in on chrome

I have a site, hosted by google sites that includes a Spreadsheet Form from google drive. Normally, the page loads, then a second or so later the form loads. In the problem case the page loads, but ...
2
votes
1answer
1k views

Is it possible to use Google Spreadsheets to post to a web service?

I was wondering, as a thought experiment, if it were possible to use Google Spreadsheets to post to a web service. For example imagine you created a spreadsheet for guests attending a party with ...
7
votes
1answer
21k views

Create a column of date in Google Spreadsheet [duplicate]

Possible Duplicate: How to extend series of dates in Google Docs? Is there a way to create a column of date easily with google speadsheets like with Excel ? In Excel, enter a date, hold ...
0
votes
2answers
481 views

How can I link 2 cells in Google Docs in the same document, on the same spreadsheet?

How can I link 2 cells in Google Docs in the same document, on the same spreadsheet? I have a headings and every time I have to scroll down to the one I need. Can I create some kind of "header" on ...
0
votes
2answers
1k views

Editable google spreadsheet on Google site - assign username

So here is what I am trying to do: Have a Google site that has an embedded editable Google spreadsheet on that allows end users (if they have been given permission) to edit the spreadsheet. Here is ...
4
votes
1answer
1k views

Normalizing and grouping dates in Google Spreadsheet

I have a spreadsheet pulling together various readings taken of hours heater has run, electricity units use for that period, and outside temperature. For the last 3 months, the electricity usage and ...
3
votes
1answer
4k views

In Google Spreadshets, how can you loop through all available sheets not knowing the total count?

I'm keeping stats for my daughter's baseball team. I have a sheet for each game, each one identical in structure. I want to create a summary sheet that totals numbers from the other sheets. How ...
1
vote
2answers
6k views

How can I retrieve records from a Google Spreadsheet in JSON format?

I'm trying to retrieve data from Google Spreadsheets with no success. I've gone through this: http://code.google.com/apis/spreadsheets/data/3.0/developers_guide.html#RetrievingTables and this: ...