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

learn more… | top users | synonyms (2)

1
vote
0answers
7 views

How to calculate interest rate from start and end amounts in Google Sheets?

Google Sheets. What is the formula and result for working out the interest rate required for making £38106 into £73036 in 20 years? (As if you put £38106 into a bank account and left it for 20 ...
2
votes
1answer
27 views

Create a 7 day running total and running average using ARRAYFORMULA

There's a question on this forum that asks how to get a 7 day running total and running average. It's available here and it reads like this: I have a Google Spreadsheet tracking figures day by ...
-2
votes
0answers
7 views

categorising info from google form responses

staff will be filling in a google form on how many hours they have looked after a group at school for e.g. soccer for say 10 hours. I then need on a second sheet specific data to be categorised. I ...
5
votes
1answer
26 views

Conditional formatting of a row header based on the values in the column

I have a table I'm using to list recipes and their ingredients. Ingredients are rows, recipes are columns, with a column next to the ingredients denoting if that ingredient is in stock. Like so: ...
2
votes
1answer
38 views

How to automatically increase the exponent in Google Spreadsheet columns?

I have asked a similar question before How to automatically increase the exponent in Google Spreadsheet? But the new question is: In a Google Spreadsheet, I put in the following numbers in a ROW, ...
1
vote
1answer
9 views

Link in Google Sheets to either create a new document or link to the one that was previously created

I'd like to provide a column in a spreadsheet that allows the user to create a note for the column by clicking on a link. If the note has never been created, it will create the link to a new document ...
2
votes
1answer
19 views

SUMIF using NOT ISDATE

I want to sum across a range of fields, but only if the cell contains a number, not a Date. I would love to use something like SUMIF(A2:Z2,"!ISDATE()",A2:Z2) But the criteria in SUMIF is incredibly ...
1
vote
1answer
20 views

Google Sheets Count Unique value with multiple criteria

I am working on a Google spreadsheet as below: Walkin date | Name | Phone | Status | Remarks 01/06/15 | Client1 | 1001 | Open | Will join soon 03/06/15 | Client2 | 2002 | Sales | ...
3
votes
2answers
33 views

Replace chunks of HTML with double quotes using SUBSTITUTE

I want to replace the following chunks of html contained in a cell: Original <table class="generic"> Replacement <table class="data-table" id="product-attribute-specs-table"> ...
2
votes
1answer
34 views

Delete duplicate text within a cell

I've got cells in a column populated with data pulled from another tab using A1= Results_ES!C1 and A2= Results_ES!C2 etc. Some of the data is duplicated whithin the cell, e.g. Cell A1= Black Black ...
4
votes
1answer
67 views

How to access a gauge chart in Google Spreadsheets?

I have a gauge chart in my spreadsheet. I am looking for a line for accessing it. function myFunction() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getSheetByName("Gauge"); ...
1
vote
1answer
20 views

Relative Conditional Formatting with Google Sheets

I'm trying to use conditional formatting in the goals area. Currently the calorie goal (J10) turns green as long as I stay under it's number, and it's compared to the total calories for the day (J3). ...
3
votes
1answer
39 views

Create keyboard shortcut for Chrome OS to move to next sheet in Google Sheets

I really need to create a keyboard shortcut to move from one sheet to the next in Google Sheets in Chrome OS. In Mac this exists, but does not on Chrome OS. There is an extension called Shortcut ...
0
votes
0answers
13 views

SUMIF calculation by getting data from new spreadsheet

I'm creating monthly and yearly report in google sheet (google drive). i'm trying to perform calculation by matching specific case from another google sheet. i used the below function to link with the ...
3
votes
1answer
26 views

Attach image url then email using Google Sheets

What is the correct syntax for emailing an image url in a row as an attachment? I'm trying to loop through all rows within a Google Sheet and attach an image url as the image. I can send the correct ...
1
vote
1answer
15 views

Is it possible to filter columns in Google spreadsheets [closed]

Is it possible to filter columns in Google spreadsheets i.e. I want to see suppose only 4 out of the existing 20 coulmns.
1
vote
1answer
18 views

Auto-update a google form?

Is it possible to write code that automatically changes the questions on a Google Form? Would love to be able to automatically sync our signup form with a spreadsheet which lists the chapters around ...
2
votes
2answers
22 views

Can I automatically email the row contents I enter in Google Sheets?

I have a Google Spreadsheet where I enter a row of data with any changes to my office schedule for the day. Is there a way to automatically email this row of data (not a link to the spreadsheet, but ...
3
votes
1answer
36 views

How do I interleave two lists or data in Google Spreadsheets?

I want to combine two lists in Google Spreadsheet so that the cells interleave. Both lists have the same amount of elements. So that: 1 A 2 B 3 C becomes: 1 A 2 B 3 C ...
2
votes
1answer
22 views

Google Sheets: Format number as Mhz/kHz, or MB, kB etc

I want to make a spreadsheet with Google Sheets to compare microprocessor's specifications. One column will show processor speed, another will show program space, another for RAM space and so on. ...
3
votes
1answer
34 views

How to split multiple values in one cell into separate cells?

I'm using ImportHTML to pull in data scraped using another tool called Import.io, as you can see in the example spreadsheet here. However, when I pull in data using ImportHTML, it's pulling 3 years ...
2
votes
1answer
24 views

Concatenate inside ImportRange inside Query

I found this formula: =QUERY(IMPORTRANGE("key","A:Z"),"SELECT Col1, Col2, Col3 WHERE Col1 contains 'value' ORDER BY Col1") Here and I'd like to add a concatenate function where 'value' is taken ...
3
votes
1answer
57 views

How can I create a URL for a specific cell in Google Sheets?

I am a teacher who is trying to create QR codes for book reviews to be placed on books in the library. I have collected all of my students' book reviews via a Google Form, so that their answers are on ...
5
votes
1answer
31 views

How to refer to a cell in the same column at given row?

I would like to get a cell in a particular row above the current cell. This is to be used in conditional formatting, so I can't specify a particular cell, e.g. A$4—the reference would be the same for ...
2
votes
1answer
22 views

How to embed a Google spreadsheet (or any kind of tables) in Medium?

I tried to embed a Google spreadsheet in Medium without success. I could get the post the title but not the data. Knowing that I used the "publish" feature of Google spreadsheet. If not possible, is ...
2
votes
3answers
83 views

How to calculate difference in hours between two time fields which runs from one day to the next

I've found a formula that will calculate how many hours between 2 time perfectly well if they are in the same day, but as soon as the times go from one night to the next morning I end up with a minus ...
2
votes
1answer
14 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 ...
1
vote
1answer
18 views

Sum of cells within a given range of dates

I'd like to calculate my revenues in a given trimester, based on the invoice total and the date it was paid. Column B - invoices to add up Column E - date paid Here is my attempt (which comes up ...
2
votes
1answer
12 views

How to convert all numbers regardless of decimal separator into valid number of current locale in google sheet

I have a column with text looking like this: 123,123 123.123 123,123 123.123 I would like another column to parse this into decimal numbers, disregarding the different decimal separators (dot . and ...
3
votes
1answer
22 views

How to move a standalone chart back to an existing sheet

I regret moving my chart to a new spreadsheet in Google Spreadsheets. How do I move it back? Using the revision history to undo the edit is not an option, since it has been a while since the original ...
-1
votes
1answer
28 views

Automatically group data by month

I am using Google Sheets and I would like to display monthly in and out. date units unit cost cost 2015-01-05 200 0.24275 -48.55 2015-01-05 1 1.43 -1.43 2015-01-09 ...
2
votes
2answers
39 views

Google Spreadsheets: Insert new rows automatically

I have two columns, one with German texts segments (in rows) and the second one with the Spanish translations of these segments. The problem is that in many cases the segments are too long for my ...
2
votes
0answers
11 views

Google Sheets: how to custom number format based on value? [duplicate]

In Google Sheets, I want to format 1230000 as "1.23 M" and 1230 as "1.23 K". However, it seems I can only format either in terms of M, or K, not both. It's possible to set formatting conditions in ...
0
votes
0answers
19 views

Trying to send email from Google Sheets with image attachment

I'm trying to send an email from within Google Sheets and then format it via some joins to send to an address for my Blogger account. I need to attach the image file apparently as the image isn't ...
1
vote
1answer
11 views

Same x-axis for multiply graphs in same plot window

I am trying to do exactly what the answer in this link explains (I have several sets of data to be plotted in one graph with the same x-and y-axis); but with one difference: I don't have simply one ...
2
votes
1answer
19 views

Applying a Formula to All Cells in a Column (Even New Cells)

I'm using Google Spreadsheets and currently, this is what I have in J2: =iferror(H2/G2,0) I know I can double click the square in the bottom right and it will apply to every cell in the column but if ...
2
votes
1answer
22 views

Copying rows to another sheet based on column value

I have a sheet in a document with details of hundreds of signups for an event. As part of this event, there are roughly sixty 'centres'. People have signed up through one form, and now I want to ...
2
votes
1answer
35 views

How to make Google Sheet jump to today's row when opened?

I have a sheet that has many rows to put data. Since there are too many rows, I want to have the cursor jump to a particular row when the sheet is opened.
1
vote
1answer
34 views

How to create an auto updating Google spreadsheet with information from Steam?

How would I create an automatically updating Google spreadsheet containing information about Recently Played in Steam? Table must look like here: A2 taking information about account name from ...
3
votes
1answer
22 views

Capture Created Date from form that allows for editing

I've looked through the previous posts and can only find information where it looks like the responder assumes that the form is completed in one go, so the TimeStamp column is the obvious answer to ...
1
vote
1answer
29 views

How to create an automatically updating Google spreadsheet with information from Steam?

How would I create an automatically updating Google spreadsheet containing information about Recent Activity in Steam? Table must look like here: But the hours column must automatically updating ...
3
votes
2answers
40 views

How to add a link to Google Search in a range in Google Sheets

I have a google spreadsheet, where I want to link each cell in a range to the google search page, where the search term is the text in this particular cell. So if I have a cell with content 'Bikes' I ...
2
votes
1answer
25 views

Import key statistics without a header row

I'm interested in pulling a specific # from Yahoo Finance. I'm looking at American Airlines AAL I have found the table: =importhtml("https://finance.yahoo.com/q/ks?s=aal&ql=1","table",11) ...
-1
votes
0answers
11 views

Copy Date Modified from Finder into Google Docs Spreadsheet [migrated]

I'm on a Mac, looking at a list of files in Finder. I can copy the filename into a Google Spreadsheet by selecting all, copying, and pasting directly into the spreadsheet. The next column over in ...
0
votes
0answers
48 views

Custom functions: Keep getting “There was an error during calculation”

I'm using two custom functions but for some time now I keep getting the following error when I load my sheet: There was an error during calculation; some formulas may not calculate successfully. ...
0
votes
2answers
46 views

Universal formula for generating Google Spreadsheet hyperlinks from cell contents

I have a column of cells in a Google Spreadsheet with values such as: A ----- 37683 36583 38637 32391 I'm generating hyperlinks in column B for each cell in colum A: http://mywebsite.com?id=xxxxx ...
1
vote
0answers
11 views

Google spreadsheet: How to paste rows but not overwriting existing rows? [duplicate]

Here is what I want to do: I have rows 1,2 and rows 3,4. Now I would like to copy rows 3,4 before rows 1,2. I.e., after pasting the rows, I will have six rows. Rows 1,2 is the same as the previous ...
0
votes
1answer
9 views

Concatenating two columns using only filled cells in one of them

In my table, column A has row names and other columns have values: +------+---+ | M100 | D | | M130 | B | | M340 | | | P304 | F | | P400 | | | P499 | C | +------+---+ I'd like to join ...
1
vote
1answer
32 views

How do I change a string which encodes a date into a date?

I have some cells in the format 15/05/15. Here is an example. These are dates, but as I copied them into Google Spreadsheets, they are apparently treated as strings. How do I convert them into date ...
1
vote
1answer
26 views

Get the sum of every row in a table imported with Importhtml

I've figured out how to import HTML table into Google spreadsheets, but is there a way to sum a row? I want to get a sum of Total Revenue from Nasdaq. This allowed me to pull the quarterly data from ...