A computer application that simulates a paper accounting worksheet.

learn more… | top users | synonyms

4
votes
1answer
19 views

Is there a quick way to see when a cell in a Google Sheet was last edited?

Google Sheets has a revision history accessible from File / See revision history. However, it doesn't appear to easily allow you to see when a particular part of the sheet (e.g. a cell) was changed? ...
1
vote
1answer
10 views

How do I concatenate a string literal of my cell to a string of another cell?

I am trying to make life easier for myself by organising my teaching materials for private tutees of mine from various subjects/educational levels in google spreadsheets. I want to know how I can ...
1
vote
1answer
30 views

Can I use ArrayFormula with CountBlank or IsBlank if so how?

=IF( OR(COUNTBLANK($F3)>0, COUNTBLANK($G3)>0, COUNTBLANK($H3)>0, COUNTBLANK($I3)>0), "Missing Values", $E3+(index(LSI_Index!$B$4:$B$40,MATCH(VLOOKUP($G3, ...
2
votes
0answers
26 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 ...
2
votes
1answer
77 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
82 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 ...
0
votes
3answers
536 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
498 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
138 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
298 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 ...