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 ...
0
votes
1answer
460 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 ...
1
vote
2answers
313 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 ...
3
votes
1answer
3k 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 ...
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 ...
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.
...
4
votes
2answers
5k 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:
...
2
votes
2answers
5k 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 |
...
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 ...
1
vote
1answer
3k 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 ...
2
votes
1answer
950 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 ...
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 ...
3
votes
2answers
809 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 ...
3
votes
1answer
504 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 ...
2
votes
2answers
655 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 ...
