0
votes
0answers
21 views

If statement to input the next integer

I have a row of values that sometimes returns a value, and sometimes doesn't. I want to input the first number that is actually a number. Sheet Value Indicators Column A Column b ...
1
vote
0answers
53 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 ...
2
votes
0answers
25 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
67 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 ...
1
vote
1answer
32 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
149 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
34 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
414 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
935 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 ...
6
votes
1answer
18k 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
435 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
905 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: ...