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

learn more… | top users | synonyms (2)

4
votes
1answer
60 views

Save daily to my Gmail in Google Sheets

Right now what I have is this in a Google sheet for my company daily lunch program: function sendLunchPerkSummery() { var d = Date(); var file = ...
4
votes
1answer
69 views

Embedding a Google Visualization Chart inside a Google Spreadsheet

Unfortunately, the embedded charts in Google Spreadsheets do not have the customization I want. I would like to use a Google Visualization Chart instead. The documentation discusses how to use a ...
4
votes
1answer
200 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" ...
4
votes
1answer
365 views

Monitor webpage changes using Google Spreadsheets

I want to monitor a web page. The best solution I found was Google Spreadsheets (apart from feed43 which has limitations). I'm using the importHTML function in Google Spreadsheet which will update ...
4
votes
1answer
1k views

Normalizing and grouping dates in Google Spreadsheet

I have a spreadsheet pulling together various readings taken of hours heater has run, electricity units use for that period, and outside temperature. For the last 3 months, the electricity usage and ...
3
votes
1answer
33 views

How to merge multiple spreadsheet content having the list of keys to them?

Input: column of Google keys for spreadsheet that contains tables with some data, eg: date | refNum | Name | Description Require: a sheet that will contain a merged table with data from ...
3
votes
1answer
248 views

Preventing Paste Overwriting Cell Formatting in Google Sheets

I have a spreadsheet used for booking employees onto training sessions. It's very simple to use; the person booking simply enters their employee number into column A and column B, C & D ...
3
votes
1answer
253 views

How can I create a Google Spreadsheet whose name and cells auto-complete with cells completed on another sheet?

I'm using Google Spreadsheets to manage projects, and I'm not familiar with scripts or macros (though I'd really like to learn how to use it, so if you have any good tutorials or tips, let me know). ...
3
votes
1answer
182 views

Make dynamic array blank based on adjacent values in Google Spreadsheets

I'm attempting to indicate certain months that fall between the end of one period and the beginning of another. I have the months of the year in column C: values 1 through 12. It's a running snapshot ...
3
votes
1answer
2k views

Google Spreadsheets Data Validation - Unique Values

I have a google sheets document which contains two sets of data in separate worksheets: Public IP addresses Private IP addresses In my private IPs worksheet I want to create a dropdown which ...
2
votes
1answer
33 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
1answer
20 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 ...
2
votes
1answer
39 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.
2
votes
1answer
26 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 = ...
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
37 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 ...
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 ...
2
votes
1answer
20 views

Google Sheets Problem with Chart Axis

I have a Google Sheet with a some data that I need to chart. The horizontal axis should be a list of dates. When I plot the chart, though, it's inserting dates that aren't part of the data set. For ...
2
votes
1answer
96 views

Generate a formatted Google document from spreadsheet

As the title says, I have data (Q & A grouped by subject) that I have to export to a document file. As shown above, the source data on the left should be formatted like the example on the right ...
2
votes
1answer
18 views

Adding an overtime column to a Google Sheets template that includes the overtime rate in the total

I would like to use this template to log bi-weekly hours. It is almost perfect except that there is no column for overtime hours. How would I add an overtime hours logging column that would add the ...
2
votes
1answer
68 views

Calling IMPORTRANGE inside of REGEXMATCH function?

I'm interested to know whether (and how) can i call IMPORTRANGE function inside of REGEXMATCH function. I want to get root domains from list of URL's and use REGEXMATCH to do this but want to get ...
2
votes
1answer
403 views

How to set Custom data validation in Google Sheets (A really simple step-by-step guide needed)

I'm trying to figure out how to create custom data validation in Google Sheets what are the steps I need to follow to achieve this? For example if I wanted the following validation: // Set the data ...
2
votes
1answer
407 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 ...
2
votes
1answer
3k views

Import Google Spreadsheet range if a column contains a particular value

I want to import a range of data from one Google Spreadsheet (1) into another (2), but only when Column J in spreadsheet 1 contains a 'yes'. I'm using the following formula: ...
2
votes
1answer
84 views

Is there another way to click on the hyperlink in a Google Spreadsheet?

I am aware of the process to click a link on the spreadsheet. However, is there a way where the user of the sheet can directly click on the link? I am trying to prepare a decision tree where, once a ...
2
votes
1answer
417 views

Google form to spreadsheet, create new column

I created a Google form and a spreadsheet associated that form. On the spreadsheet there are two columns by default. A is Timestamp and B is Untitled question. Now I want to create another column in C ...
2
votes
1answer
327 views

How to do a date formula in Google Spreadsheets

I have to do a query that increments automatically the date year by year. For example I use this formula: =INDEX(query('Scheda Intervento'!C3:K14;"select sum (K) where (F >= date '2013-01-01' ...
2
votes
1answer
2k views

Google spreadsheet: named range built upon formula

I have a list of items (cells A1 to A7) that are counted in cell B2 (whose value is currently 7), B2's formula is something like =COUNTA(A1:A10000). That way if I add some value in cell A8, the count ...
2
votes
1answer
670 views

Copy one Google Spreadsheet to another

I am developing a Google spreadsheet that I want to make publicly accessible to a community. I've released the first version of it, and now everybody in the community has that first version's link ...
1
vote
1answer
6 views

How to compute the maximum of Column B after having filtered by the contents of Column A?

I have data in two columns (say A2:B20). To get what I want, I have to filter by the first column, and then get the maximum value in the second column of the filtered array. Can this be done without a ...
1
vote
1answer
9 views

Sort randomly in a Google Script

I found this script to sort a Google Spreadsheet but I need to sort everything randomly instead of alphabetically, is there a way to sort it randomly every time this script runs? > // LinkBack to ...
1
vote
1answer
10 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 ...
0
votes
0answers
46 views

Delete a q​uestion in a Google Form

I want to delete a row in the Google Form, and it disappears well enough in the spreadsheet, but it is still in the presentation. I also want to modify the contents of the investigation, but it does ...
0
votes
0answers
102 views

Pull data from one sheet (has a locked cell) to another sheet (has a locked cell) every day automatically?

I have a dynamic Google spreadsheet to which I add one more sheet every day. I want to take the data from sheet1 cell D96 (a protect cell) to sheet2 cell D3 (a protect cell) every day. I found a ...
0
votes
0answers
75 views

Sort all sheets by column 1 in first sheet

I’m trying to sort or autosort an extensive Google spreadsheet with various codepending sheets. I have tried to use the sort function but that is to blunt to use in this case. I’m hoping to get some ...
0
votes
0answers
107 views

How to create a simple dialog form in Google Spreadsheets with GAS

The functionality that I am going for is this: Click on a menu option Interactive box comes up with 6 textboxes that correspond with a label each In two of those boxes, at most three, a number is ...
0
votes
0answers
105 views

Google Spreadsheet Sub Columns/ Multidimensional data

So, I'm trying to create a spreadsheet to track and graph a rifle team's performance. One page with data, and the rest with the graphs. The data needs to be organized by the date of the practice, ...
0
votes
0answers
45 views

How does Google know that I am not a human?

Over on stackoverflow I asked a question regarding accessing google spreadsheets with curl, which doesn't seem to be possible any more, even when setting a valid user agent string. My question arising ...
0
votes
0answers
89 views

How do I allow a user to edit a specific column only?

I have a protected range but I want to do the opposite of its function. I only want a user to be edit that specific range. So, how can I have them "view only" for the whole spreadsheet but edit one ...
0
votes
0answers
75 views

Google Docs update values on a 2nd spreadsheet and automatically links and updates values in the 1st spreadsheet

I have 2 spreadsheets. Spreadsheet 1, the initial data is entered manually. I do an importrange into spreadsheet 2 with a order by Col2. This is what I get when I perform importrange (sort on ID) ...
0
votes
0answers
714 views

Create a checkbox-type function that works on the Android Drive app for Google Spreadsheet?

How can I create a checkbox-type function that works on the Android Google Drive app for a Google Spreadsheet? I want to make a to-do list (groceries, trip prep, etc.) that the user can check "done" ...
0
votes
0answers
558 views

Prefilled Google Forms with Google Spreadsheet Data

I'm looking for a way to 'pre-fill' a Google Form with specific data from a Google Spreadsheet. The form will have the same 'standard' questions for everyone, but the data in the first two question ...
0
votes
0answers
43 views

How to set hot keys to a customized menu item in a Google Spreadsheet?

I am working with Google Spreadsheet APIs, and found that customized menu item is highly useful. I created some but am now wondering whether I can specify a hot key for each?
0
votes
0answers
161 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 ...
0
votes
0answers
492 views

Copying cells in Google Spreadsheets and pasting into text file adds quotes around each cell

Copying cells in Google Spreadsheets and pasting into text file (tried with XCode, Notes, Text Edit - the below applies to all) adds quotes around each cell. How can I avoid those extra quotes? Also, ...
0
votes
0answers
291 views

Query google spreadsheet and display single column?

I am working on using Google Spreadsheets as a gradebook. I am attempting to display only a student's grade, not an entire classes. I am integrating this into my wordpress site. The function I want to ...
0
votes
0answers
417 views

Google spreadsheet revision history — too much detail

For word processing, Google Docs revision history is great. However, for some of my spreadsheets, something isn't working right: Revisions are not grouped together, multiple for each minute. "Show ...
0
votes
0answers
529 views

Google spreadsheets - “=ImportHtml DIV” how to?

I play Runescape and I want to make a tool that people can use to make profit in the game. My problem is that I am not sure exactly how do use a command to pull data text from a div element. The ...
0
votes
0answers
2k views

Change value in one cell through a formula in another cell

I am trying to capture a timestamp for when a spreadsheet is first edited, and ONLY keep that first timestamp. However, NOW() updates each time a spreadsheet is edited. I found a working formula ...
-2
votes
0answers
8 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 ...