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

learn more… | top users | synonyms (2)

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
23 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
13 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
22 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
25 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
40 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
36 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
24 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
31 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
42 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
26 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
51 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
51 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
33 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
28 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
24 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
47 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
47 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
27 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
32 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
35 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
37 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
42 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
36 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 ...
0
votes
1answer
23 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
22 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
42 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 ...
1
vote
0answers
34 views

Adding columns automatically to Google Sheets

I am using Zaption and Socrative as assessment tools while teaching. After I download the CSV files, I import them to Google Sheets. I figured out a way of having the results sent to a PDF after ...
3
votes
1answer
18 views

Creating a copy of a sheet by copying values only?

I use the below script to basically duplicate an existing worksheet. The worksheet I am copying contains the ImportRange. I don't want the copy spreadsheet to have the formula just the value from the ...
1
vote
1answer
16 views

Using IF Formula to get data from another Cell

I am just trying to use the IF formula: COLUMN A COLUMN B COLUMN C Cats NULL Dogs Monkeys Kittens NULL ...
4
votes
1answer
93 views

Custom script “invoked too many times” error

Credit: Google Spreadsheets function to find distance between cities function getDirection(city1, city2, unit) { var directions = Maps.newDirectionFinder() ...
-1
votes
1answer
14 views

How do I block rows/columns/cells from certain users on the shared Google Spreadsheet?

I have a spreadsheet with sensitive data. How might I block a certain column from others users viewing it?
1
vote
1answer
33 views

Script to Create Copy (Backup) of entire spreadsheet onOpen

Is it possible to write a script or is there another method of backing up a spreadsheet when opened? The reason is: I have other users opening my spreadsheets and if they completely stuff everything ...
1
vote
1answer
72 views

How to change the size of a published Google Spreadsheet chart that has its own sheet?

Google Spreadsheet offers the option to put a chart on its own sheet (instead of inserting it in the current sheet). This looks like a good idea for large charts. However, I ran into an issue when ...
1
vote
1answer
52 views

Calculate compound interest rate in Google Spreadsheet

Assume the PV=100, FV=150, yearly IR=X, number of period = 60 (5 years of interest and compounding is monthly basis) Therefore: FV = PV * (1 + X / 12)^60 How can I calculate X easily? ...
2
votes
1answer
49 views

Highlight cells, which content can not be parsed as number

How can I highlight cells whose content is not parsable as number? thanks!
1
vote
1answer
119 views

Query(ImportRange) throws “Formula Parse Error”

I'm working with Google docs and I've run into a wall with a query(importrange) function. =Query((IMPORTRANGE("URL","Sheet Name!A2:P1000"),"select ...
2
votes
1answer
43 views

Script to create a new worksheet in Google Spreadsheet

I want to be able to have a button on a Google Spreadsheet. The user clicks on the button and a new worksheet is created based on a template (or blank existing worksheet). The new worksheet should ...
4
votes
2answers
59 views

How to sort a Google Sheets Query by a custom ordering

I have a table of choir members with a “name” and a “voice type” column. How can I write a query that orders them by decreasing pitch level of the voice type (i.e. soprano > contralto > tenor > bass)? ...
2
votes
1answer
23 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 ...
3
votes
1answer
26 views

Freeze columns in Google Sheets for multiple users

Is there any way for multiple users working on a Google Docs spreadsheet to freeze columns and rows the same way filter view works?
1
vote
1answer
34 views

If time is before 17.00 use 17.00 OR if time is after 17.00 use value in cell

Headline says it all. I'm trying to calculate worktime in minutes. Ex: https://docs.google.com/spreadsheets/d/1GmGyi4kQf8I2qvEJjfG3OZvm_n_kBbsw_doTi9J0KCk/edit?usp=sharing I have to state when ...
3
votes
1answer
27 views

Extending dget to a column in Google Spreadsheet

Given the following formula: =dget(Sheet2!$A:$C,Sheet2!B$1,{"USER ID";$A2}) Is there a way to alter this formula so that it fills all the values in a column? I've tried with arrayformula, changing ...
4
votes
1answer
63 views

Formula for smart, scale-aware number-formatting in Google Sheets? (e.g. 1,024 → 1k, 1,816,724 → 1.8M)

Any recipes out there for a "smart" number formatting formula for Google Sheets that's "scale-aware," a la Rails ActionView's distance_of_time_in_words method? I would expect to enter a number like: ...
1
vote
1answer
25 views

Trouble linking entries from two sheets for automatic update

How do I have text information from one column (Sheet 1, column C) automatically feed into Sheet 2 column A so that, when Sheet one is updated through the Google form it is linked to, the information ...
2
votes
2answers
59 views

How can I trace precedents in Google Sheet

In Excel we can trace precedents and dependents. Can some one help me with something similar for Google Sheets? I have got the code for dependents from http://webapps.stackexchange.com/a/50149/88163. ...