A computer application that simulates a paper accounting worksheet.

learn more… | top users | synonyms

1
vote
0answers
20 views

Setting multiple protected ranges with one range value inputted

Id like to set protected ranges over several sheets and ranges of the same spreadsheet in a Google spreadsheet. The normal way to do a range is 'Sheet One'!A:L What id like to do is be able to ...
1
vote
0answers
23 views

Go to changes in Google Spreadsheet (or Docs)

When I see that somebody has changed a document I am working on in Google Drive, I normally want to see where exactly the change happened. Using File > See Revision History... is not really helpful ...
0
votes
2answers
17 views

Formatting Duration Values in Google Spreadsheet

I have a Google Spreadsheet. In that spreadsheet, I have the following: Date | Start | End | Duration -------------+-------------+-------------+------------------------- ...
-1
votes
1answer
30 views

How to add some text value in cell in Sheet Google Drive

Everyone!! I am newbie in Google Drive Sheet . Actually i want to know how can i select some column with values and add in every selected cell some text, i.e . Is possible to perform via regex or ...
2
votes
1answer
74 views

How to count occurrences of number in a column, group and total

I have a spreadsheet for a festival. Unique identifier is ticket number. I want to query the column with tent number, to automatically generate two columns. First column has tent number. Second column ...
0
votes
2answers
80 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 ...
1
vote
1answer
106 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 ...
0
votes
3answers
521 views

Looking for a Webapp that combines the power of Smartsheets and Trello [closed]

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
1answer
1k views

Password protected online database or spreadsheet [closed]

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 ...
2
votes
2answers
2k 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 ...
4
votes
3answers
492 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 ...
4
votes
2answers
2k 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
137 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
5answers
297 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 ...