# Tagged Questions

0answers
7 views

### Google spreadsheet won't open in Google Drive app [duplicate]

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 ...
0answers
74 views

### Google spreadsheet won't open in Google Drive app & won't allow edit in the browser

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 ...
0answers
10 views

### In Google Spead sheets how do I find the average amount spent in a month?

I've been keeping track of purchases and would like to do some statistical calculations. In column B there is the price in the form \$X.YY and column C has the date in the form mm/dd/yy. How can I find ...
2answers
73 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 ...
2answers
47 views

### Split text with Google spreadsheets

I have a Google spreadsheet with 1,500 cells containing items like: 1,300 users 2236 users, 12 companies 15000 users,153 companies <46,000 users, <200 companies I need to split this ...
1answer
31 views

### How do I split multiple rows / insert a row below every existing row, in any spreadsheet program?

I use a spreadsheet to keep track of journeys in a lift-club. Each day has its own row, and the number of lifts given to a person will be 0, 1 or 2. I realized that the algorithm for the lift scheme ...
1answer
17 views

### How do I merge cell data into a new column?

A | B ----- 1 | a 2 | b 3 | c and I'd like to have a third column that merges the data like this: A | B | --------- 1 | 1, a 2 | 2, b 3 | 3, c currently I can kind of do this one row at a time ...
0answers
50 views

### Entering time data quickly using code for a specific range of cells

What API code do I use if I want to quickly enter 24 hour times (without entering the colon and still retaining time formatting) for a certain range of cells? I know the following code works for ...
1answer
51 views

### Spreadsheet: function to watch row for changes

Is there a spreadsheet function (Google, Excel, Numbers, or otherwise) that can watch a row and update a cell with the current date when any cell in that row changes? If not for the entire row then ...
0answers
72 views

### How to anchor all the cells on the page in Google Spreadsheet

To anchor cells in a Google spreadsheet so that you can drag the values/cells/formula, with one or more of the linked cells/values remaining constant you can follow these steps: ...
1answer
77 views

### Google Sheets: Find the maximum occurrence across sheets

This is kinda difficult to explain... Is it possible to let Google Sheets tell me what the maximum value is from some chosen coloumns in MORE THAN ONE sheet (in the same document)? I namely need to ...
1answer
315 views

### Drag Autofill of a Multi-Column Pattern in Google Spreadsheet

I'm trying to drag copy some cells, which are on top row for headers, they get their values from a VLOOKUP formula (Basicaly all group names are in column B and I want them as column headers). Before ...
1answer
1k views

### Password protected online database or spreadsheet

I have a client that wants a simple online database or spreadsheet solution. Requirements Custom fields and field types (text, images) CRUD contents through a web GUI Password protected (single ...
2answers
1k views

### Spreadsheets: Is there any cloud-based spreadsheet that can give user-based access to edit a column?

We're looking at a way to share inventory information across multiple users: sales, customer service, production, etc. Is there a way to lock the 'Price' column so that it can be edited only specific ...
1answer
5k views

### Multiple Conditions on a CountIF?

I have a spreadsheet that is essentially a todo list for different groups. I have a column for Group and Status. Both have data validation drop downs so I can reliably match the text content. I have ...
1answer
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 ...
3answers
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. ...
3answers
9k views

### How to sum ​​values ​​in a range of dates in Google Docs Spreadsheets?

I have a Google Docs spreadsheet in the format below — here's an example. Column A → Dates Column B → Numbers I'd like to sum values ​​in column B in a range of dates in column A. Example: ...
2answers
9k views

### Sum column only if another column has an empty value

I am trying to get a sum of column values in a Google Spreadsheet only if there is no value in the adjacent column. Consider the following example: A | B ---------- 40 | 50 20 | 20 30 | 10 | ...
4answers
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 ...
1answer
4k views

### Google Spreadsheet Apply Formula to Newly Inserted Row

I have a spreadsheet that keeps a running balance of a credit card with the newest transactions at the top (just like credit card web sites). An example of the formula for each cell in the Balance ...
1answer
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 ...
1answer
809 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 ...
2answers
1k views

### Google Spreadsheets - How do I populate a cell in WorksheetA with aggregate data from WorksheetB?

I'm working on a spread sheet that allows some basic collaborative hour tracking. WorksheetA contains an entity called Blocks where each block has a BlockID. WorksheetB contains line items. Each ...
1answer
716 views

### Google Spreadsheet Formula Applied To New Row

If I have a formula (of any kind) spanning A1:A30 (just as an example), when I right click and insert a new row, it doesn't have the same formula. Numbers (and I believe Excel) allows this, is there a ...
2answers
1k views

### type testing in Google spreadsheets

is it possible is test for ints or strings on google spreadsheet, and respond to each differently?
1answer
1k 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 ...