# Tagged Questions

7 views

My Google spreadsheet created on my PC won't open on the Drive application on my tablet or phone. It opens in the browser but won't allow it to be edited. The error on Google Drive: Failed to open ...
55 views

My Google spreadsheet created on my PC won't open on the Drive application on my tablet or phone. It opens in the browser but won't allow it to be edited. The error on Google Drive: And my ...
71 views

### Google Drive spreadsheet - create chart with total for each score

I have a column within a google spreadsheet with values like this: 96 97 96 100 97 97 100 97 95 95 96 I'd like to add a bar chart where each bar represents one of the values and the height of the ...
2k 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 ...
750 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 ...
11k 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. ...
1k 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 ...
5k 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 ...
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 ...
6k 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".
10k 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 ...
2k 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 ...
600 views

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 ...
807 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 ...
2k 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, ...
135 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. ...