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

learn more… | top users | synonyms (1)

1
vote
1answer
11 views

Adding particular data to particular sheets within one document

I am a bit new at this and am having a tough time getting this to work... I have multiple sheets, one main one (Submissions) which receives data from a form, then I have the sheets: Level 1, Level 2, ...
3
votes
0answers
33 views

How to calculate geographic area in Google Sheets?

I have three columns of cells with geographic coordinates. For example: 40.614362,-73.974187 | 40.618654,-73.989636 | 40.629675,-73.979092 I want to calculate an area between these coordinates to ...
2
votes
2answers
34 views

Suming functions by relations between sheets (Google Sheets)

Table for counting items: ID COUNT 1 10 2 0 3 12 4 1 5 5 6 10 7 9 8 9 9 11 10 0 Table-pedia with info about items: ID NAME FEAT1 FEAT2 1 Nanan R 20 2 Meowth S ...
0
votes
0answers
38 views

How do I sum cells according to cell or font color?

I would like to sum cells based on either the color of the cell or the color of the text contained therein. I guess there was a way to do this before the update, but it doesn't seem to work anymore. ...
3
votes
1answer
27 views

How do I print comments of a Google Spreadsheet?

Can I print the comments of a Google Drive spreadsheet? And if yes, how? I should mention that the print should not be on the same page.
0
votes
1answer
27 views

How Do You Replace a Formula With Its Result?

I've been searching and searching but haven't found what I think is the right answer. I'm not an advanced user of excel. At best, somewhere between beginner and advanced. I created a Google ...
-1
votes
1answer
16 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 ...
1
vote
0answers
13 views

Google spreadsheets importrange() error: Loading Data

Is there any reliable alternative to ImportRange() in google spreadsheets? After some time the formula brakes, and shows "Error: Loading data... ", and it wouldn't work until I change anything in the ...
1
vote
1answer
18 views

How can I sort all worksheets in my Google spreadsheet on open?

I have successfully been able to sort the first sheet in my Google Spreadsheet onOpen, but I'd like to sort all four spreadsheets onOpen and I can't make this work. I've tried quite a few variations ...
1
vote
0answers
7 views

How to directly view a Google Visualization API Query URL as a human-readable table or web page?

What is the correct syntax for the URL (see also a related question about documentation) to view a Google Visualization API Query result as a web page containing the tabulated results of the query? ...
0
votes
1answer
45 views

Using SUMPRODUCT with ARRAYFORMULA

I have the following random data in sheet one A orange D yellow C yellow B orange B orange C blue A yellow D blue C orange C blue In sheet two I use the following query function: ...
1
vote
1answer
7 views

how to clean up table data in Google Sheet IMPORTHTML?

I want to import a table of nuclear power output from https://ru.wikipedia.org/wiki/Атомная_энергетика_по_странам. For some reason, the second col has the number duplicated, eg <td><span ...
0
votes
0answers
27 views

How to make my Excel formula work when transferring it to Google Spreadsheets

I am trying to convert an Excel program that tracks repairs inputed by staff and updates a master file. I had the formula working and once I had transferred it to Google Spreadsheets it stopped ...
0
votes
1answer
13 views

How do I have the choice made in an in-cell drop down menu affect the cells next to it?

I have a contact sheet with names going down the list and contact info in the cells to the right of each name. On a separate signup sheet, I used data validation to create a drop down menu with the ...
2
votes
1answer
51 views

How to make SQL JOIN of two tables with Google Spreadsheet?

I am just figuring out how to achieve an apparently simple problem. I use to have data as in database tables in my spreadsheets. It's simple data but I often need to use =QUERY function and would be ...
1
vote
1answer
17 views

Problem adding Image to hyperlink in Google Sheets

I want an image to be my hyperlink in Google sheets. Here is my code: =HYPERLINK("google.com/de", IMAGE("http://s5.favim.com/orig/69/hi-love-quote-start-Favim.com-658946.jpg")) The image shows up ...
0
votes
1answer
31 views

Sum cells according to cell colour

I want to sum cells only with a specific cell colour. I'm using this code: function sumWhereBackgroundColorIs(color, rangeSpecification) { var sheet = SpreadsheetApp.getActiveSpreadsheet(); ...
0
votes
0answers
14 views

Where is the official comprehensive reference page Google spreadsheet URLs

Google Spreadsheets URL Syntax and Display Options? was a question that was answered by referring to an old page: http://code.google.com/apis/spreadsheets/data/2.0/reference.html#Parameters ...
0
votes
1answer
24 views

Moving from one Sheet to another in Google Sheets

I am using a Google sheets to organize an upcoming project. On the first tab I have every task listed, and who the actor should be for that task. I plan on sharing this sheet with my team... Is it ...
0
votes
1answer
22 views

How to merge 2 tables into one?

I have in my Google Spreadsheet two separate tabs containing each one a table as showed hereafter: Tab 1 Tab 2 ______________________________ ...
1
vote
0answers
16 views

Disable Drag & Drop Google Sheets

DEFINING DRAG & DROP: In google sheets if you have a cell or cells currently selected you can perform an operation on them. One such option is to move your cursor to the edge of the selection ...
0
votes
1answer
20 views

Show only own record to Google Spreadsheet user and hide data from other users

I'm organizing an event, so I set up a table for people to sign up using Google spreadsheet. For concern of personal information privacy, I'd like to make it only be able to add a new record, for ...
2
votes
0answers
25 views

Appearance of Forms I never created in Google Drive

I have some Google Sheets file which I copy and change monthly. I never used Forms, but they are appearing all the time in the Drive and are related to this G.Sheets file as you can see on the ...
2
votes
1answer
25 views

Collect data from dropdown list

I'm making an expense spreadsheet, to keep track of all my expenses. I have made a dropdown-list with different category (Rent, Food, Others etc.) these are put into C2 to CXX, in the next cell D2 to ...
1
vote
1answer
14 views

Add FILTER condition if parameter is present

I have on the top of the page some filtering parameters (see $H$1 below). They may be left blank, and if so, they should not be used. How to use then conditionally in FILTER?? The following don't ...
1
vote
1answer
25 views

ArrayFormula to compute Running Average for groups of rows

Is it possible to write an Array Formula which calculates the running average of the Amount column for each of the Name groups in the following sheet? The rows are sorted by Name. In Column C, I ...
2
votes
2answers
49 views

Find the closest value (equal or greater) in a range in Google Spreadsheets

I have a range with a list of values (depths). I'd like to be able to select the row where the depth matches a value in a cell I provide. If no value matches, the greater value should be selected. ...
2
votes
0answers
43 views

How do I refresh script results when a cell color is changed?

I have a Google Spreadsheet that contains a script to count a number of cells by color. The script works perfectly but seems like when ever I change the color of the cell, the count is not updated. ...
6
votes
2answers
52 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
46 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
33 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
19 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
20 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
83 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
52 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
51 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
35 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 ...
0
votes
0answers
46 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
673 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
71 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
40 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
53 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
55 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
35 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
29 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
50 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
38 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
43 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
26 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 ...