A productivity application from Google that allows you to create and edit worksheets

learn more… | top users | synonyms (2)

-1
votes
0answers
18 views

Monitor daily share prices with a Google Spreadsheet

I am trying to monitor a number of different stocks daily and would like to see the fluctuations of each stock in the day. I wouldn't mind either of the following ways by importing google finance ...
1
vote
1answer
15 views

ImportXML formula no longer working

Here is the formula: =ImportXML("http://www.bloomberg.com/quote/7501:JP", "//div[@class='price-container down']//div[@class='price']") As of several days ago, this formula stopped working. Why ...
1
vote
1answer
11 views

Defining a custom order in a Google Sheet query?

I'm using a Query in Google Sheets to pull data from another sheet. That query looks something like this: =QUERY('Raw Data'!A2:AB,"SELECT E, A, C, D, Y, R, S WHERE S = 'New York'",1 ) What I'd like ...
1
vote
1answer
11 views

Apply formatting and formulas to another sheet?

I have a template tab that contains all formulas and formatting. Then one tab for each user. I know how to reference cell content with =template!A1. How to reference formula that reference current ...
6
votes
3answers
2k views

Google Spreadsheets date and time format

I have lots of dates in the first column in the format August 23, 2010 at 11:01PM I was wondering if anyone knows a way to get them formatted in a way that I can then use for date and time ...
-1
votes
0answers
10 views

Tab in a table in Excel = ? In sheets [on hold]

In excel 'Tab' creates a new row within the table... all of the same functions are present, a date is entered in one column and the table auto populates the quarter and month into the next two ...
5
votes
1answer
46 views

Probability Density Function of a Chi Distribution

I'm trying to write an extension for Google Sheets to add the CHIDIST() function as in Microsoft Excel and LibreOffice Calc. My current attempt does not produce the same results as the LibreOffice ...
2
votes
1answer
10 views

A spreadsheet formula to assign letter grades based on numeric ranges

I'm trying to figure out how to write an IF statement that will be 'true' if a value is in-between two values. Example: If value is between 60 and 69.9 return "D" If value is between 70 and 79.9 ...
1
vote
0answers
10 views

Checking if a cell's contents matches an entry in a list of data

I have a Google Spreadsheet with one tab (countries) containing a table with a list of countries (e.g., France) and their associated IDs (e.g., 21). On a separate sheet (regions), I have a table ...
2
votes
2answers
38 views

Join several columns with a single formula returning an array

This is the opposite of my question Split a column of strings with a single formula returning an array. I have several columns, say, A-K, which I want to join into one comma-and-space separated column ...
2
votes
2answers
33 views

Truncating the Title in the HYPERLINK function in Google Spreadsheet

I have a number of URLs that I first convert from text to the HYPERLINK function and then want to edit the title-section of this function, so that only the domain is visible in the cells. I attached ...
5
votes
2answers
466 views

Insert image from Google Drive into Google Sheets

How do I insert/link to images existing in a folder in Google Drive into a Google Sheets spreadsheet? There is the image() function, I imagine using it something like this: ...
5
votes
3answers
16k views

How to Fill a Column with Sequential Dates in Google Sheets

In Excel you can right-click drag a date downwards to fill a column with the next dates in the sequence. For example if you enter 9/1/2014, select that cell, then right-click drag down over the cells ...
3
votes
1answer
23 views

Finding the average of top 10 smallest values in Google Sheets

I'm looking for a formula to find the average of the top 10 smallest values within a dataset. It works in Excel but not in Google Sheets. E.g. (that works in Excel): ...
2
votes
1answer
21 views

How to add bulleted list in Google Sheets

I am unable to add bullet in front of any sentence. See below example, I need circle bullets in front of every sentence written in one cell. First Sentence Second Sentence Third Sentence How can ...
8
votes
1answer
125 views

Google Sheets - Script to change individual text color within a cell

I have a Google spreadsheet with hundreds of employee names for a schedule. Each cell has multiple names within that cell that look like this: First Last First Last First Last First Last First Last ...
1
vote
1answer
211 views

Download list of contact information and check if Google Account

I'm looking for a way I could: retrieve a list of all my contacts and their email's and In order to retrieve a list of all of my contacts into a Google spreadsheet, I exported them as a Google CSV ...
6
votes
5answers
9k views

How to group data by month in Google Spreadsheets

I have a Google spreadsheet which contains various metrics for each day. Each day has it's own row like this: day | cost | impressions | clicks | conversions 2014-02-01 | $45 | 3,540 | ...
2
votes
1answer
20 views

Parse out column with commas in it into separate rows

I have data in the following 2 column format in my google spreadsheet: 3M 701 A.W. Sperry DSA-2002 Accusplit 725MX, 705X, Magnum XL I would like to be able to parse out the 2nd ...
-1
votes
1answer
189 views

Creating a document (e.g,, MS Word) attachment in Gmail from a spreadsheet script

I've created a document file in the spreadsheet script. What I want to do is, from the script, create an email message with the document file (NOT a PDF) as a Gmail attachment. I spent about 2 days ...
-2
votes
1answer
22 views

Lock a column based on the date

I have an Employee attendance register in Google Sheets, wherein I want to lock the particular column/s after the date is passed over. This feature is required for the clerk to enter the date on the ...
1
vote
1answer
17 views

Google Sheets - Conditional Formatting Based on Date Formula

I'm trying to highlight the contents of a Date cell if the following conditions are met: Value of another cell = "No"; and Value of target cell + 7 days > Today The formula that I have right now ...
1
vote
1answer
25 views

Using a query to pull data for today

I am trying to pull the data from sheet 1, using the following formula: =query(Sheet1!A1:V1850,"select I,A,D,E,F,H,R,S,L, M,O where I = 'TODAY()'") So I do not have to enter todays date every time. ...
2
votes
1answer
38 views

Filter rows by a set of numbers from another row

I have row of six digit numbers where I want to filter rows containing exact numbers set. For example: orderid 154934 154935 154936 154937 154938 154939 154940 I want to filter 154935,154937 these ...
3
votes
2answers
10k views

Create a function for an entire column in Google Spreadsheets

I'd like to set a function for an entire column in Google Spreadsheets, and I'd like for that function to get applied whenever I add new rows to the spreadsheet. I know that I can set a function for ...
3
votes
1answer
663 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 ...
0
votes
0answers
10 views

Bound Scripts in Google Sheets on iPad and Android Apps [duplicate]

I created a Google Sheet with a bound app script on my desktop but the scripts do not run on the iPad or Android apps for Google Sheets. Does anyone know if this can be done?
3
votes
1answer
114 views

The default number of rows for “Add more rows” at the bottom of Google Sheets

At the bottom of Google Sheet web application, there is an 'Add' button and '1000' is the default number of rows to be added. Can I change this default number?
4
votes
1answer
287 views

Google Spreadsheets showing “shared with xxx” count greater than actual?

For every one of my Google Spreadsheets, the sharing settings is on "Specific people can access", and each sheet is shared with 3 people I know. Their names are listed when I click on the blue "Share" ...
2
votes
1answer
53 views

Sum columns based on conditions

I am working for a webhosting company and we are tracking our efforts with Google Sheets. I was trying to find a solution for the following problem: We track our efforts by clients per day, so that ...
2
votes
2answers
40 views

Suppress time part of the datetime values on a chart axis

I have a line chart based on the following data, capturing the Close Queue size every four hours: +---+-------------------+-------------+ | | A | B | ...
3
votes
1answer
18 views

Union of two lists of key-value pairs

In a spreadsheet I have two lists (key-value pairs basically) that look like this: [A] [B] [D] [E] a 23 b hello b 42 d world c 11 f good f 17 g bye h ...
2
votes
1answer
55 views

Print several non-consecutive columns of a Google Spreadsheet using a script

I have script for print. I need print range without some column (e.g. print just B,C,D,E,G and miss F) and without all notes in sheet. The script below prints all the columns. function printPdf() { ...
1
vote
2answers
43 views

Extract the link text and URL from a hyperlinked cell

Suppose I have a hyperlink in cell A1: =hyperlink("stackexchange.com", "Stack Exchange") Elsewhere in the sheet, I'd like to have formulas that get the link text and URL from A1, separately. I found ...
3
votes
2answers
32 views

Pick the first value in every row that has not been picked yet

In the example I am giving below, I would like the result in Column G to be what is in Column C, unless it already exists in Column G in rows above it. These rows represent students' choices for ...
0
votes
1answer
24 views

Can I cut and paste projects from a Google sheet using a script?

I want an automated method of cutting and pasting completed projects from one sheet to another sheet. I want to have a column where users can go in and type "DONE" at the end of a row to state that ...
3
votes
1answer
41 views

How do I create a data validation function to print the values of a specified column across all pages?

I have a specific task that I believe might require some kind of custom script. Here is (a copy) of the spreadsheet in question: ...
3
votes
1answer
38 views

Show URL used to edit responses from a Google Form in a Google spreadsheet by using a script

I'm trying to make the edit URL for a google form automatically populate in the response google sheet that it's attached to. I've seen this already and want to use it, but i'm having issues trying to ...
18
votes
3answers
30k views

Display Sheet Name in Google Spreadsheet

Is there any way to display a sheet name as the result of a function in a google doc spreadsheet (exactly like this question, except in gspread)?
0
votes
1answer
16 views

Copy and paste information once a day form a Google spreadsheet

I have a Google spreadsheet that is being modified during the day, and need to copy and paste the final information (at 8 pm) in a different tab, each day, pasting the new information under the old ...
3
votes
1answer
35 views

Timestamp in two columns

As a teacher, I am trying to create a Google sheet for the students to use as they sign in and out of class. I have successfully used code to auto insert a time stamp into column A if Column C is ...
3
votes
1answer
18 views

How to shrink column when wider than the window?

I double clicked the column border so it expanded wider than the window. When I scroll to the left it jumps, so I can't see the previous column. How do I shrink it down?
1
vote
1answer
12 views

How can I get the halfway date of two dates in Google Sheets?

I have two date columns in mm-yy format and I need to know the halfway date of these two. What formula do I use? I tried simple subtraction of the two dates and then divided it by two but it didn't ...
1
vote
1answer
186 views

Is there a way to generate edit response url for google form

I have a Google Form With a Google spreadsheet to store responses. In my spread sheet I have 4 column: name, email, revenue, and a fourth column Id which is used to identify the particular recipient. ...
1
vote
2answers
26 views

Create an OR conditional statement from a list of options

I want this: input in A1 and output in A2. input: 0 output: AND (A=0) input: 0,1 output: AND (A=0 OR A=1) input: 0,1,2 output: AND (A=0 OR A=1 OR A=2) etc... I've tried a few things with the REPT ...
18
votes
6answers
34k views

Can I add an autoincrement field to a Google Spreadsheet based on a Google Form?

Is it possible in Google Forms to give a unique value to each row it inserts into the spreadsheet as well as the timestamp?
1
vote
0answers
15 views

Sum the same cell in a range of sheets [duplicate]

I have an Excel spreadsheet that has this formula: =IF(ISBLANK(B6),"",SUM(Sheet1:Sheet10!O6)+Sheet11!P6+Sheet12!T6) I would like to use this spreadsheet in Google Sheets so I can get it on other ...
1
vote
1answer
20 views

How can I force a Google Spreadsheet to have column in one tab have the same width as the same column in a different tab?

Is there any way to force a Google Spreadsheet to have column i in tab j of same width as column i in tab k? In other words, can I configure Google Spreadsheet so that a column width change is always ...
2
votes
1answer
53 views

Creating duplicate linked Google spreadsheets that share copy and formatting

I'm looking to create a content calendar on one Google Drive and then have that exact content calendar (copy, formatting, and any new rows that get added) shared as a tab in a spreadsheet on another ...
1
vote
1answer
15 views

Time stamp on last row of column for changes in predetermined range

I am looking for a way to add a time stamp to the last row of a column of figures any time there is a change in the above range. I have been able to find a number of examples where you can timestamp ...