One of productivity apps in Google Drive, that allows you to create and edit worksheets

learn more… | top users | synonyms (1)

6
votes
2answers
56 views

How to Turn Leftover Minutes into Hours

I have a spreadsheet with two columns that count hours and minutes, respectively, with sums to totals at the bottom. I would like to make it so when the minutes reach sixty, it automatically subtracts ...
1
vote
0answers
12 views

Pull data from a cell in one Google Sheet to another cell in a separate Google Sheet [duplicate]

I have a Google Spreadsheet with quite a few sheets in it. I am trying to pull information from that sheet and put that info into another sheet in a different Google Spreadsheet. I have googled this ...
0
votes
1answer
50 views

Counting occurrences in Google Spreadsheet

I've been brought on last minute to sort out tent allocation for a festival of about 1500 pax. Their ticket sales are a spreadsheet on Google Drive. I have never done this kind of thing before (I'm ...
1
vote
0answers
42 views

Auto import CSV into existing Google Sheet

I understand how to upload and convert CSV files to Google Sheets -- but how can I set up an automatic upload of all new data from a CSV file into an existing sheet? I have a CSV file that lives on ...
2
votes
1answer
21 views

Duplicate then concatenate in Google Spreadsheets

How do I join a to both sides of : to result in a:a? I could use something like =join(":","a","a"), but in this case, my "a" is another formula and it is very long. I'm trying to find a way so I ...
0
votes
0answers
24 views

Listing live stock prices with 15 minute intervals in Google sheets

I use google Sheets to keep an eye on stocks. Their live data is all I need. I would like to have a sheet that adds a new row with the stock price and time every 15 minutes. Is this possible with the ...
4
votes
2answers
87 views

How to move sheets in Google Sheets with the keyboard?

I want to rearrange the sheets in my workbook. I have many sheets and moving the last one to the front is very slow with drag and drop. Ideally I want a command that will select a sheet and move it to ...
3
votes
1answer
54 views

What is -Ls 1000 in Google sheets

I've been working with inventory spreadsheets in Google sheets. I have many SKU's in my inventory and when pasting or typing them in, the are interpreted as text and are left justified in general ...
3
votes
1answer
63 views

Can you link directly to a new copy of a Google Doc or Spreadsheet?

Is it possible to craft a URL (or bookmarklet) so that when clicked it opens a fresh "copy" of an existing Google doc or spreadsheet? Apparently it used to be possible by appending &newcopy=true ...
1
vote
1answer
40 views

How to extract IP address of the host into a row?

It seems it's possible to How to extract website title into a row?, but how to extract IP address of the host into a row? So for given any hostname (e.g. webapps.stackexchange.com) it should return ...
1
vote
1answer
9 views

Change background color of a cell when another cell is filled in

Let's say I have a Google Sheet where A1 needs to be filled green when B1 till B7 has been filled in with no matter what; and A1 needs to be red when 1 or more cells from B1 till B7 are not filled in ...
0
votes
0answers
56 views

Complex Index and Match with three criteria

I need to create a formula that will match three criteria in a range on another sheet, and where they match, return the value in an adjacent cell. The problem I have is that one of the criteria is a ...
7
votes
2answers
706 views

Which formula extracts the domain name from an email address (bob@example.com -> example.com)?

Which Google Spreadsheets formula do I use to get the domain part from an email address? Example: bob@example.com → example.com
1
vote
2answers
93 views

How do I apply formatting to a cell based on comparison with another cell?

I'm working with Google's spreadsheets to keep a record of how many dragons of each breed/gender I have in a game I play. I have five columns: A (Breed) | B (Male) | C (Male Goal) | D (Female) | E ...
2
votes
1answer
41 views

Create a public spreadsheet which requires users click the “edit” button to mutate it?

How do I customize a public Google Spreadsheet like this? It needs users to click the "Edit" button so that they can edit:
1
vote
1answer
60 views

COUNTIF in Google Sheets that checks 'if' a string is in one column before counting in another column

I'm trying to use the COUNTIF function in Google Sheets. The Goal I want the 'dashboard' sheet to display the count of items in column F submitted to the responses sheet 'if' a specific string ...
2
votes
0answers
58 views

Batch Hiding Function in Google Script

I wrote a function that iterates through every non-blank row in the sheet, checks the value of a certain cell, and then if that cell matches my criteria its row number is added to an array. I then ...
3
votes
1answer
53 views

Conditional Formatting: Minimum Value in Row

The goal Apply conditional formatting to the minimum value in a row of a Google Spreadsheet. What I've tried Under Conditional Formatting, using "Custom Formula Is" =MIN(D3:L3). The result ...
2
votes
1answer
32 views

Complex Formula in Google Spreadsheet

I have a 'dashboard' sheet and a 'log' sheet. I'm trying to pull data from the 'log' sheet and perform calculations on the data before displaying it in the 'dashboard' sheet. The 'log' sheet will have ...
2
votes
2answers
68 views

How can I filter a full table based on only unique values in a single column?

How can I deduplicate a table (all rows and columns) based on the values in column A? Example: What I want after deduplicating: Basically, I only want unique values in column A, but I want all ...
1
vote
1answer
49 views

Filter columns in Google Spreadsheets based on fill colour

I've got a long list of items that I need to check. I use a traffic light system to track where I change the cell colour of the cells in the progress column: red = haven't done yellow = in progress ...
3
votes
1answer
47 views

Update Random value only on page refresh

I am using =RANDBETWEEN(1,100)function to generate a two digit random integer. But I want these values to refresh only on the page refresh, whereas currently they are changing whenever any cell is ...
2
votes
0answers
27 views

Automatically adjust corresponding cells when using “=query”

I just learned how to use the =query function in Google Sheets, pulling information from one sheet to the next when a specific condition is met. =query('Sheet1'!A:Z, "select B, D, E, F, G, I, L where ...
1
vote
1answer
44 views

How to get more than 1 question to populate the same field/column in the Spreadsheet?

I am looking for some way to get the submitted answers to 2 or more questions to populate in the same column in the response spreadsheet, but on the next row. e.g. When gathering data from ...
4
votes
1answer
50 views

How to get the +1's of a website?

I've a spreadsheet with a lot of contact information. In order to sort the data, I want to rank them according to the +1's given on their website. Is it possible to get the +1 count of a website ...
2
votes
1answer
43 views

How to make Google Spreadsheet editable only at certain times

I need to create a document (something like a Google Spreadsheet) where multiple users could insert their names in, but within a limited time span. They could edit the document only from Monday (8pm) ...
1
vote
0answers
44 views

How to prevent user from downloading my Google Sheets

I have made a few useful spreadsheets for my company. I want to put them on Google Sheets, so my colleagues can use it online to make inputs and get results. But I do not want them to know the ...
1
vote
2answers
52 views

Show cell value on click

I have a formula in a cell to calculate a value. But I want the value to be shown only when the user clicks on the cell. I looked around but there seems to be nothing by default.
1
vote
1answer
53 views

Circular Dependency Error, Blank when 0

I have tried both of these in Google Spreadsheets and continue to get circular dependency errors. I am trying to show blank when the result is 0. New values are entered daily and want to have the ...
0
votes
1answer
48 views

How to turn cell yellow if date in cell is between 180 and 365 days in the past

In Google Spreadsheets how do I use conditional formatting to turn a cell yellow if the date is between 180 and 365 days in the past?
1
vote
1answer
72 views

A more complicated Countif (Google docs)

I have a simple countif:= Countif(A1:A5,"statement"). And I want it to count the statement n times if it appears n times in my cell A1 (plus of course the number of times it appears on the other ...
0
votes
1answer
28 views

Auto Insert Address on adjacent cell

I am trying to create a spreadsheet which enters address automatically on adjacent cell when I type in the company name. The script will be as I type in company name in cell A1, it will search for ...
1
vote
2answers
33 views

Lock formulas in Google Spreadsheets

I'm creating a table for a friend to input information but he is not very good at computers. I had him work on a table in Excel and locked the page and this worked great but now I want to check his ...
0
votes
1answer
1k views

Error: Circular dependency detected

I am very beginner to google scripting. Here I need to count the number of times the word "FREE" occurred in my sheet. But my function Returns me an error "Error: Circular dependency detected" Please ...
0
votes
1answer
225 views

Copy cell from cell to another sheet if row contains x

I'm new to sheets, I have a sheet with 10 pages. I need to auto fill sheet Report if sheet David contains "1" in column "i". I need to copy cells C14 - C34, J14 - J34 and L14 - L34 only if there is ...
0
votes
1answer
60 views

Wildcard in Google spreadsheet

How do I convert the following formula to do wildcard for "Florida"? =Sumproduct((Sheet1!B:B="Florida"),Sheet1!A:A) Ideally, I like the formula to do this: ...
1
vote
1answer
33 views

How to lock formula when adding column in Google Spreadsheets

I’m trying to keep an average of the 5 newest values of a data set: Average($d$1:$h$1). If I add a new column to the left of D for new data, the formula changes to ($e$1:$i$1). How do I prevent the ...
1
vote
1answer
26 views

Lookup using a key from a dropdown cell

I have a dropdown that selects from several text "keys," like so: List of items: Pathetic,Untrained,Novice,Adept,Master,Amazing I'm trying to use these keys to run a lookup on a separate sheet, with ...
1
vote
1answer
18 views

List all records with certain criteria

Help. I just cannot get this going even after 2 hours of searching Google. I have a Google Spreadsheet that has a "List" sheet and an "Outstanding" sheet. I want to see what's outstanding from a ...
2
votes
1answer
40 views

Problem with SUBSTITUTE function in Google Spreadsheets

I'm having problems using the SUBSTITUTE function as part of a formula. On it's own, SUBSTITUTE returns the desired output (i.e. in cell O3), but when combined in a formula, 0 is outputted (i.e. cell ...
0
votes
1answer
72 views

Import a CSV file to Google Spreadsheets

I am trying to upload a CSV file and importing it to Google Spreadsheets. The file contains the following: hi,hello\r\nwelcome,to\r\npeaceful,world What I expect in the Google spreadsheet is: ...
0
votes
2answers
50 views

How to sum values by month

I'm trying to have my spreadsheet to sum up values by month. Note that the dates are not organised chronologically. I've tried the solutions showing here but they are not working for me. I'm not ...
0
votes
0answers
35 views

Equivalent of Google's ImportXML in Excel Online

I wonder what is the equivalent of Google's ImportXML in Excel Online? I basically need my workbook to get an external XML data, and refresh it every X minutes.
1
vote
1answer
25 views

Counting Instances in Google Sheets

At my school, we have a Google Form for recording classroom discipline. The form generates the standard spreadsheet. I want a list of how many times each unique student has received a disciplinary ...
3
votes
1answer
88 views

How to extract website title into row?

How to extract title (or other meta descriptions) of the website into row using Google Docs? E.g. www.google.com
1
vote
2answers
111 views

Issue with Custom number format in Google Spreadsheet

I have a number cell formatted in this way: #,#" days";. Nevertheless, if I write 1.5the output is 1 days even if the content is still 1.5. Otherwise, if I write 1,5 the output will be as it is ...
2
votes
1answer
71 views

Can I subtract a cell value in another cell that already have one in Google Spreadsheets?

Let's say that I have two cells A1 (time needed) and B1 (time spent). I want that when I enter a value in B1 the value of A1 will be reduced automatically. I want that in some way I could enter in ...
3
votes
0answers
34 views

Track changes in read only shared Google Docs

I have shared a spreadsheet, anyone having the link can see it. Since it is a spreadsheet I update daily, I want to facilitate the others recognizing the last changes. However, revision history is ...
0
votes
1answer
59 views

Show all hidden rows and columns when I open a Google Spreadsheet

I want to un-hide all the hidden rows and columns when I open the spreadsheet. How can I do that for all sheets?
0
votes
1answer
76 views

Is there any way to use a formula in a Google Sheets filter view?

I have a sheet with a column of numbers. I'd like to create a filter view that only shows rows with a value greater than 500, but I can't find any way to do that. There are lots of different numbers, ...