A computer application that simulates a paper accounting worksheet.
-3
votes
0answers
28 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 ...
0
votes
0answers
22 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
117 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 ...
0
votes
2answers
115 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
23 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.
...
0
votes
1answer
436 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
301 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 ...
8
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 ...
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
2answers
264 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 ...
1
vote
1answer
964 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 ...
2
votes
1answer
834 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 ...
1
vote
1answer
456 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
2answers
438 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
619 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 ...
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:
...
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
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
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
5k 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
941 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
357 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
515 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
799 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
497 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 ...
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 ...
2
votes
1answer
995 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
131 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
649 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
0answers
112 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 ...
5
votes
1answer
664 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 ...
5
votes
5answers
217 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 ...
