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

learn more… | top users | synonyms (2)

1
vote
1answer
51 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
46 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 ...
3
votes
1answer
44 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 ...
0
votes
1answer
17 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
25 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
44 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
45 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
47 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
81 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
45 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
125 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
38 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
40 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
113 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
35 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
18 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
38 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
31 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
51 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
40 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
22 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
27 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
143 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
75 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
72 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
30 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
44 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
47 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
39 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) ...
0
votes
0answers
84 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
62 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 ...
1
vote
1answer
16 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
2answers
67 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
43 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 ...
4
votes
1answer
30 views

How do I use a time stamp from a Google Form in a Google finance function?

I have students enter a value in a form which determines which currency they want to buy. I want the Google Spreadsheet to look up and record the price when the form is submitted. Since I want to ...
1
vote
1answer
82 views

Cell formatting in Google Spreadsheets does not get preserved

My Google Spreadsheet does not preserve some formatting. Every time I set, for example font size to 12, for the whole sheet, newly copied data uses a smaller font size. This only started being an ...
1
vote
1answer
81 views

Triggering timestamp on formula input

I'd like to have a timestamp which triggers its input depending on a cell containing a formula like =IF(ISBLANK(cell),"", time ), and not upon manual input. My script is the following and is working ...
2
votes
1answer
53 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 = ...
3
votes
1answer
43 views

How can I transpose multiple rows into a column with multiple matched outcomes?

I have this data set: and I want to transpose it where the Date is in a Column then A is in the next Column and B on the next I used this formula = ...
0
votes
0answers
12 views

Clipping text (with newlines) vertically in Google Spreadsheets [duplicate]

I would like to have each row to have a height of one row of text but I would like cells to contain text with newlines (i.e., addresses) while still retaining that minimal height. Is that even ...
2
votes
1answer
75 views

Google Spreadsheet Timestamp on Edit?

I got the major part of answer on this link: Google Spreadsheet Timestamp? The code on this link is below: function onEdit() { var s = SpreadsheetApp.getActiveSheet(); if( s.getName() == "Sheet1" ...
4
votes
1answer
49 views

Multi-column Conditional Formatting and Row Export in Google Sheets

I need to (a) indicate and (b) export several columns of data into a separate sheet, but only the rows that satisfy a certain condition: three columns (which are not exported) must be after today's ...
2
votes
1answer
51 views

Importing columns across two Google Sheets in same spreadsheet

I have one spreadsheet which houses the database of my members. In the same spreadsheet, I have another sheet where I will track attendance for the events for each of these members. First issue: ...
1
vote
1answer
53 views

Method to filter based on dropdown list of months

I'm trying to convert an Excel spreadsheet into Google Sheets. I have the entire year on a sheet and would like to filter the list based on a selected month from a dropdown. For example, selecting ...
-1
votes
1answer
26 views

Multiply cell value depending on keyword

I would like to apply a transformation to a table which basically looks like this: If there is a certain keyword in column A, then the number in column B should be multiplied by 2. Is that possible ...
2
votes
1answer
34 views

How to split then combine data to rows

I have a Google Spreadsheet that receives data from a Quickbooks invoice entry. The data from item description has the quantity of each item separated by commas, then the items which are also ...
2
votes
1answer
76 views

Trigger Script in Spreadsheet in Similar Fashion to a Link

I currently have a button on my spreadsheet (a text box image that triggers the script). Unfortunately this button doesn't work when using a tablet. Is there a way of triggering a script to run via a ...