A computer application that simulates a paper accounting worksheet.

learn more… | top users | synonyms

4
votes
5answers
345 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 ...
4
votes
3answers
538 views

Is there an online spreadsheet app that can handle greater than 256 columns? [closed]

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
3answers
4k 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 ...
4
votes
1answer
272 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? ...
3
votes
3answers
2k views

Spreadsheets: Is there any cloud-based spreadsheet that can give user-based access to edit a column? [closed]

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
51 views

What's the formula to select a range excluding a sub-range?

I want to say A1:A60 excluding A20:A30. Is there a minus operator for use with ranges, in Google Sheets? I know that you can take the union of two ranges, like {A1:A19;A31:A60}. I would like to know ...
3
votes
1answer
43 views

Can I set the number format to show exactly 2 decimals only when needed in Google Spreadsheet?

I want to set the number format as below: If the number have more than 2 decimals, round it to 2 only (e.g. 12.3456 -> 12.35). If the number is whole number, just let it be (e.g. 12 -> 12).
3
votes
1answer
88 views

Calling importRange from within another function

I have a bunch of separate spreadsheets and I'm creating an overview spreadsheet which pulls data from each of the others. I also need to apply the COUNTUNIQUE formula to that data. If I simply type ...
3
votes
1answer
33 views

How to order category by numerical order with text in cell

I want to arrange my C column by numerical order, however the cells themself have text in something like "503 in Kitchen & Home", I want it to detect the number but ignore the string. Is ...
3
votes
0answers
23 views

Is it possible to set up conditional formatted using Excel online?

As per the title really, is it possible to set up conditional formatted using Excel online? The cell's context menu doesn't have the option, and I can't find it in the ribbon either. Am I missing ...
2
votes
2answers
19 views

Set a formula for all cells in a column

I would like to use a same formula for cells in a column. Instead of writing it for all cells, is there a way to set it in a cell and tell to apply this formula to all cells in a column (or any set of ...
2
votes
2answers
27 views

Formula to use to add up all rows that returned a value of 1 for several cells that meet a specific crtieria

This is the spreadsheet I need help with: spreadsheet I need cell B21 in the 'Reports' sheet to add up all rows that meet this criteria: return a value of 1 if columns M, O, T, U, W, X, Z, AA, AB, AC ...
2
votes
1answer
188 views

In Google Sheets' filter views, can I filter columns non-cumulatively?

I have been putting together a spreadsheet in Google Sheets that includes various data/information relating to the hundreds of characters in a novel I am reading. Two of the columns relate to the ...
2
votes
1answer
343 views

In a Google Spreadsheet, show all combinations for a selection of columns

I have a sequence of letters, in a Google Spreadsheet: | A B C D E F --|---------------------- 1 | U Y 0 4 X N 2 | H X Y 3 | W The first row contains a ...
2
votes
2answers
48 views

Sum all expenses of a given type given a list of expense types in a separate sheet

I use Google Sheets to keep track of my expenses. The file currently consists of: Sheet 1: "Expense Types" Sheet 2: "2015 Details". The first column of Sheet 1 contains the list of admissible ...
2
votes
1answer
173 views

Auto Sort data in Google sheet, but by sheet not range

I have found this script from this question to auto sort a column: How can I apply a script to only one specific sheet within a spreadsheet function onEdit(){ var sh0 = ...
2
votes
1answer
96 views

Calculate total based on drop down criteria

I am creating a budget that has different expenses on one worksheet (Expense_Overview). On another worksheet, I have a list of expenses (Expense_Detail) I am entering that are categorized based on a ...
2
votes
1answer
20 views

Easily switch between seeing only lines affecting a running total and all lines

Background: I have a spreadsheet with one row per date. Each row has a current total A, there are different ways to either add or subtract an value from that total. No other column except G (for A, ...
2
votes
0answers
74 views

Running inventory list that references a product key [closed]

So I'm trying to create a rudimentary inventory management system in Google Sheets. I want this inventory guide to keep track of my product inventory, as well as my packaging inventory. So if a ...
1
vote
2answers
44 views

Function name to add rows in Google Sheets

Is it possible to add rows with a built-in function (such as MIN() or INDIRECT()) in Google Sheets? I would like to fill rows in the main sheet such as +---+----+--------+ | A | 18 | Atext1 | | A | ...
1
vote
1answer
33 views

Get unique rows and their count in Spreadsheet

I have a sheet as below, | A | B | C | ------------- |abc|123|Yes| |jkl|123|No | |abc|123|Yes| |abc|567|Yes| I want to get the output like, | A | B | C |Count| ------------------- |abc|123|Yes| 2 ...
1
vote
2answers
65 views

Average two numbers IF the second number exists

I have 2 columns (Google sheets) of numbers similar to: 10.453 12.178 12.654 0 The third column is: if number higher than 0 exists in both columns, display an average of the two else just ...
1
vote
2answers
45 views

How to check if a cell contains any of an array of values?

TL;DR: Using SEARCH(search_for, text_to_search), "search_for" is a variable-length array, pls halp On Google Sheets, I have four cells, E1:E4. The values in each cell are as follows: | E ...
1
vote
1answer
17 views

How to get the name of the row which is the mode in Google Spreadsheets?

Example: A B 1 john 6 2 ryan 5 3 kate 8 4 paul 1 I want the formula that returns the text "kate" in A3, because the value in B3 is the highest in the range B1:B4. I would like to know also the ...
1
vote
1answer
36 views

Cross referencing 2 sheets and pulling in values in Google Sheets

I have a Google sheet with multiple sheets in a single document. A generalized version of what I have is something like this: Sheet 1: A B C | AA | | | | BB | | | ...
1
vote
1answer
98 views

How do I put the timestamp in the “check in” or “check out” column based on the user's response in the Google form?

I created a Google form that allows users to clock in/out. The form asks two questions, their pin number and whether they want to check in or out. When the user clicks on "check in" and submits, the ...
1
vote
1answer
82 views

Is there an online spreadsheet where I can share individual columns?

I sometimes use a spreadsheet when grading student assignments, where the leftmost columns describe the different parts of the assignments and possible points, and there is a column for each student. ...
1
vote
0answers
13 views

How to use dot as splitter in currency format with Russian locale

I want to write currency in the format: ₽ 3 812.23 But if I select Russia as region in the table settings and format the string ₽ 0.00 result formatted number like ₽ 3 812,23 with a comma, ...
1
vote
0answers
12 views

Drag to change referenced cell in Google Sheets as Libre Office Calc does?

In LOC when double clicking cell A1 that has the formula '=B1*C1', both B1 and C1 have a coloured border that is drag-able. Dragging B1's border to D1 now makes the formula in A1 '=D1*C1'. In Sheets ...
0
votes
3answers
176 views

Update formula ranges when adding new rows to a spreadsheet

I have a Google Spreadsheet in which I keep a list of expenses. I add a new expense by inserting a new row above the last expense. On the first row of the spreadsheet, I keep a sum of all expenses: ...
0
votes
1answer
2k 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 ...
0
votes
0answers
22 views

How to freeze a row until a similar row shows up on Google sheets?

I would like to make an effect similar to how for example iOS apps persist a table's row until someone has scrolled beside it. example This behavior happens all the time in iOS apps. You can see ...
0
votes
1answer
11 views

Is there an easy way to undo changes to a cell, column or sheet within a spreadsheet?

In Google Sheets, I may sometimes edit a cell, then edit another cell, and then decide that I want to undo the first edit. Is that possible? This also goes for rows, columns, sheets with a ...
0
votes
3answers
726 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
2answers
30 views

How to sum cells in Google sheets that contain numbers and text

This has already been addressed in Excel but I was wondering how to do the same in Google Sheets. So suppose the B cell has this formula: ="frontend (days) total: "&sum(B2,B10,B14,B20) and the ...