A computer application that simulates a paper accounting worksheet.
9
votes
3answers
2k views
How do I Export Data to Excel
I am using Trello as the Scrum tool of choice but need a way of exporting data to populate my burn down charts.
We are using Google Chrome but have data security concerns, so exporting to Excel is ...
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 ...
5
votes
5answers
224 views
Replacement for Excel [closed]
We have a small team of 20 people who use basic spreadsheet functions to share daily reports between us for our clients. We'd like to switch to a web-based product vs using Excel.
What do you ...
5
votes
1answer
710 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 ...
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:
...
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.
...
3
votes
2answers
846 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
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 ...
3
votes
1answer
374 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 ...
3
votes
1answer
534 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 ...
3
votes
2answers
284 views
Is there an online spreadsheet app that can handle greater than 256 columns?
I have a CSV file with 1 column for each day of the year, obviously giving me greater than the 256 column limit that stops me from importing it into a Google Docs spreadsheet. Is there any online app ...
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".
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 |
...
2
votes
1answer
1k 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 ...
2
votes
2answers
673 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
2answers
693 views
type testing in Google spreadsheets
is it possible is test for ints or strings on google spreadsheet, and respond to each differently?
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 ...
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, ...
2
votes
1answer
864 views
How do you insert an Excel sheet as part of a new mail message?
How do you insert an Excel sheet as part of a new mail message? I tried inserting a MS Excel document directly / via a Microsoft document. But when I copied into a new Gmail message, the formatting ...
2
votes
0answers
115 views
Online editable comparison grid builder [closed]
Is there a site/service that allows to easily build and maintain an online comparison grid of items like products, software, etc. according to various characteristics and let visitors compare those ...
1
vote
2answers
404 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 ...
1
vote
1answer
1k 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
460 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
...
1
vote
2answers
225 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
461 views
Send Google spreadsheet with embedded HTML in Gmail
When I try to publish content from Google Spreadsheet, it puts it into an HTML iframe. This is found under File > Publish to Web.
How can I send this iframe content in a mail, sent over Gmail?
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 ...
1
vote
1answer
548 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 ...
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 ...
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. ...
0
votes
1answer
621 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 ...
0
votes
1answer
2k views
Applying two filter functions in Google Docs Spreadsheets
I am trying to apply two filter functions 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 ...
0
votes
1answer
46 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
2answers
164 views
Looking for a Webapp that combines the power of Smartsheets and Trello
I run a business that involves me managing client profiles and regularly performing actions associated with their accounts (i.e. taking care of forms, taxes, communications from different parties ...
0
votes
0answers
27 views
Referencing a cell for a formula by how many rows down the cell is from another
Hi I have a problem with a formula where I am trying to get a total flow per 24 hours.
My columns are referenced by date with data every two minutes with flow creating an increasing total over time.
...
-1
votes
0answers
26 views
CSV Web Interface
Is there a web app (preferably open source) which lets you upload CSV file and create CRUD presentation (preferably with users and permissions)? It may treat first row as header and rest as content. ...
-3
votes
0answers
34 views
Share a spreadsheet but protect it against copy [closed]
I'm looking for a web service that would let me upload a spreadsheet to share it with anyone. Viewers would be able to remove/hide unwanted columns/rows, change how information is sorted, but they ...
