Tagged Questions

0
votes
0answers
26 views

Google Docs spreadsheets: how to specify entire sheet as range?

The best workaround I have found so far is: worksheet_name!$A$1:$YY but ideally I would like to be able to simply write, e.g.: worksheet_name! So, does anyone know: is there a syntax for ...
1
vote
2answers
135 views

Conditional formatting color gradient in Google Spreadsheet

A few friends and myself have created a Google Spreadsheet document where we are keeping track of virtual item sales. One column has costs, one column has income one has profit, and a fourth has a ...
1
vote
1answer
981 views

In Google Spreadsheets, how do i remove the '0' from a field with an equation?

I have a spreadsheet that i enter in new values everyday and want to have the equation run down the entire column so i don't have to drag the previous day's box down to copy the info. It would work ...
1
vote
2answers
442 views

How to write a logical function that checks several columns and rows

I have three columns in my Google Spreadsheet: C (Dialog) - D (Declined) - E(Answered) All the columns are dates. Example: C D E 14/02/2012 28/02/2012 ...
4
votes
3answers
6k views

How to make a query with Google Spreadsheet, that checks for a date

I have a range that goes from B4:H124. All the cells in column B are dates. I would like to retrieve the data from a row (B:H), where the DATE equals to the content of a specific cell, lets say Q4. ...
2
votes
2answers
622 views

How to count how many cells in a column are below a certain date, AND check if other cells in the current row are empty?

I need to count how many cells in a specific column are below a certain date. Also, at the same time, the counter should only be increased, if some other cells next to each cell being counted are ...
2
votes
3answers
2k views

How to export a filtered set of rows from Google Docs spreadsheet?

Is it possible, when exporting a Google Docs spreadsheet into CSV, to apply this operation only to filtered set of rows? I need to get in CSV exactly the rows which are visible on the sheet after a ...
1
vote
0answers
1k views

Change value in one cell through a formula in another cell

I am trying to capture a timestamp for when a spreadsheet is first edited, and ONLY keep that first timestamp. However, NOW() updates each time a spreadsheet is edited. I found a working formula ...
2
votes
2answers
3k views

How can I calculate how often one string appears in a column compared to another string?

I have a column in my Google Docs spreadsheet which contains either "OK" or "NOK" (acceptance testing). How can I calculate the percentage for how often "OK" appears compared to "NOK".
5
votes
4answers
6k views

In a Google spreadsheet, how can I refer to two different columns in a COUNTIF function?

I'll try my best to explain. Say I've got a sheet that looks like this (in this contrived example, let's say I'm sending marketing emails to various people, I know their ages and zip codes, and I ...
2
votes
1answer
952 views

How to freeze a row height or prevent line breaks in Google Spreadsheets?

My question is very similar to a previous question here, but I don't want the scroll bars. When I paste a link in a cell it usually breaks the cell in multiple lines, increasing the row height. Even ...
3
votes
1answer
362 views

Can I auto archive my Google Docs spreadsheet?

We are using Google Docs spreadsheet for call logs, which is shared with more than 20 users and we all add entries simultaneously. I would like to know if there is any feature to automatically ...
1
vote
1answer
522 views

Create a 7 Day Running Total and Running Average

I have a google spreadsheet tracking figures day by day. I want to add a column with a 7 day running total (sum of last 6 rows plus current row) and a column with a 7 day running average (average of ...
2
votes
1answer
1k views

Is there a way to filter columns in Google Docs?

Is there a way to filter columns in Google Docs? Column (A) contains new data Column (B) contains filter data, i.e. cells with text that should not be included in column C Column (C) is the outcome, ...
1
vote
0answers
132 views

Is there a way to filter columns in Google Docs? [duplicate]

Possible Duplicate: Is there a way to filter columns in Google Docs? Is there a way to filter columns in Google Docs? Column (A) contains new data Column (B) contains filter data, i.e. ...
2
votes
2answers
658 views

type testing in Google spreadsheets

is it possible is test for ints or strings on google spreadsheet, and respond to each differently?
5
votes
1answer
670 views

How to label points in a scatter plot in Google Docs

I've tried using the built-in scatter plot chart, and the Google scatter plot gadget. I haven't been able to figure out how to get either one to allow me to label the points in the chart. I have data ...
2
votes
1answer
2k views

Google Docs question: How do I specify “everything except the top row” as a range?

I have Sheet1, which is automatically being updated via form entries. I'm making Sheet2, which is a self-sorting version of Sheet1 (it intended to be a copy of Sheet1 but sorted by a column). Ideally ...