# Tagged Questions

A computer application that simulates a paper accounting worksheet.

23 views

### New Libre user needs assistance [migrated]

I get the feeling this is going to be a little long winded so, please bare with me... I have a column which has hours in it, which are totalled at the bottom, for anything that has more than 2:29 ...
192 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 = SpreadsheetApp....
35 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 ...
18 views

### Google Spreadsheet/Excel formula for calculating shipping expenses of my orders [closed]

I have Website form that is entering data in Google Spreadsheet and I need to calculate automatically by Google Spreadsheet formula Shipping Cost for all orders. Data consists of: Name Email Online ...
50 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 ...
13 views

### Automate calculations when adding new services [closed]

With the little knowledge I have with spreadsheets and with lots of help from Google, I've managed to create this little project management spreadsheet to help me tracking stuff and it works pretty ...
17 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, ...
28 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 ...
27 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 ...
61 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 ...
22 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, ...
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 ...
61 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 ...
458 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 ...
44 views

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 | ...
20 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 ...
80 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 ...
234 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 ...
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 ...
36 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 ...
14 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 ...
39 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 | | | |...
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 ...
54 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 ...
96 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 ...
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 ...
69 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 ...
89 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. ...
236 views

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: =...
107 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 ...
2k views

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 ...
114 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 ...
341 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? ...
540 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 (...
747 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 ...
2k views

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 ...
349 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 ...