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

learn more… | top users | synonyms (1)

0
votes
1answer
55 views

Trying to query one sheet to inform another

Someone at the google+ apps script forum suggested I ask you guys about this project I'm working on. See the whole (pretty short) thread here: ...
0
votes
0answers
84 views

How do you refresh a filter view in Google Sheets?

Right now it seems like the easiest way to refresh a filter view in google sheets is to remove the filter view and then apply it again. What is the fastest way to refresh a filter view in Google ...
0
votes
0answers
6 views

How do show the sum of the values of a column of one sheet on another sheet in google spreadsheet? [duplicate]

I need show the sum of values in a column of one sheet on another sheet. How do I do this?
0
votes
0answers
22 views

Embed Google Sheet in website force default

I want to embed a Google Sheet in my website and want it to return to the "clean" state once I leave the page. If anyone has an idea how to implement this, be it a setting in Sheets or making some ...
0
votes
0answers
126 views

Case insensitive character string filter for multiple individual columns (dynamic input for each)

I'm looking for an efficient way to filter a data set by multiple individual, case insensitive character strings for multiple columns in a Google docs spreadsheet. I can already achieve this by ...
0
votes
2answers
88 views

New Google Sheet has different download URL? and errors?

I've been downloading the first sheet old Google Spreadsheets as a TSV file using urls like: https://docs.google.com/feeds/download/spreadsheets/Export?key=ID&exportFormat=tsv&gid=0 After ...
0
votes
0answers
96 views

Google Forms: Add numeric values and use them for billing in paypal on form submission

I am using a google form to let people signup for a conference that lasts 3 days. A user has options to pay for a day, 2 days or the full conference. He/she has the option whether or not to pay for ...
0
votes
0answers
9 views

Google Spreadsheet to open another Google Spreadsheet populated

What I would like is to click on a name in a cell in one spreadsheet and it will populate a new spreadsheet giving the title in ascending order such as A001 next time you click it it will populate a ...
0
votes
1answer
305 views

How to format the date in this Google Docs script

I've come across this rank checking script. I'm not sure exactly where I found it but it's built on Google Docs and a script which automates the rank checking process. I understand a bit of coding ...
0
votes
0answers
110 views

How would I use Google App Script to create a ListBox based on a spreadsheet entry?

Every month I receive a spreadsheet with tickets available with its code, expiration date and type. Code | Expiration Date | Type (3d or normal) ... ... ... ... ...
0
votes
1answer
29 views

List of range from another spreadsheet

I have two spreadsheets, The first sheet has a list of data companies company A company B comapny C In the second sheet i need to create a drop down menu to fetch the companies from the first ...
0
votes
0answers
31 views

Can't figure out how to import data from particular website

I want to import the top 25 QQQ holdings from the following page into Google spreadsheet. I want to import both the "Equity View and Equity Price" tabs. Im not sure the info is listed in a table as I ...
0
votes
0answers
70 views

Google Sheet Script: “=ImportFeed” does not run if spreadsheet opened by a background script (time-driven trigger)

I have a "History" sheet which will forever store anything that has ever been in the feed and a "Feed" sheet for the current imported feed (i.e. it just contains =ImportFeed) This Google Script runs ...
0
votes
1answer
70 views

Retrieve last entry via ImportXML

Looking for help pulling specific cells from a web site into a Google Spreadsheet. I want to pull "last" price from this page but only a few specific ones. Such as Dow, Nasdaq 100, S&P 500, ...
0
votes
1answer
61 views

Conditional counts based on dates

I am creating a master tracker for all the technology in my school and it is pulling data from many sheets and placing it in to blocks and I am having trouble figuring out the following ...
0
votes
0answers
216 views

Google spreadsheet disappearing text

Whenever I enter text into a box and press enter the text disappears. I can only view the text by clicking on the box it's in. What am i doing wrong? Windows 8, Firefox 29. It only occurs in firefox. ...
0
votes
1answer
67 views

Transfer data from a form to a new spreadsheet

I have a simple form that inputs entries into a spreadsheet in Google Doc's. All I want to do is open a new sheet and import the data from the forms spreadsheet so I can manipulate it in my own way. ...
0
votes
0answers
67 views

Getting error while using a Google Forms/Spreadsheets Auto-Increment Script

Similar to Kelly's problem here: Can I add an autoincrement field to a Google Spreadsheet based on a Google Form? I need to create a unique ID upon submission of a form which will be used as a case ...
0
votes
0answers
22 views

Create email with google script with google fonts

I've created various scripts to automatically send email to users who submit a form. no I'd like to touch them up a bit by using a specific Google Font (Philosopher). Here is the script I tried ...
0
votes
0answers
46 views

Google Spreadsheet not refreshing correctly

I have a single sheet (see the sheet Data: AEX) that loads data using the importdata function (4 columns). All following columns contain formulas based on the imported data, some formulas share a ...
0
votes
0answers
28 views

Dynamic drop down in case of multiple cells for looking specific list of subsequent cells and choosing

How to use a dropdown in case of multiple cells in case of large data which I have posted at > https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/O5oKD2Afkp0 And Spreadsheet > ...
0
votes
0answers
38 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
2answers
38 views

Add two variables to a Hyperlink

I know this works: = hyperlink( "https://www.google.com/search?q=" & B2 ) But I can't get two variables to work so the link would look like: https://www.google.com?var1=[insert cell ...
0
votes
0answers
62 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
65 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
68 views

Use a combination of the ARRAYFORMULA, SUM and arithmetic operations with wildcard characters

This is in further addition to the existing question at How can I refer to two different columns in a COUNTIF function? . The accepted answer worked like a charm. However, I have a requirement of ...
0
votes
0answers
50 views

Unique ID in Google Sheets to persist so it's not updated when row is updated via the form?

I'm using this: function onFormSubmit(e) { var sheet = SpreadsheetApp.getActiveSheet(); var row = SpreadsheetApp.getActiveSheet().getLastRow(); var bugCount = ...
0
votes
0answers
102 views

How can I synchronise the rows of a Google spreadsheet with Asana tasks?

My startup uses a Google spreadsheet for its client database (linked to a Google form, so that clients can fill their own data in if needs be). We also use Asana for our tasks and would like client ...
0
votes
0answers
55 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
2answers
131 views

Reflect changes in on sheet to another on Google spreadsheet

I have two sheets on a Google Spreadsheet. One of which is the copy of the other. Now what I want is, when I edit one sheet, the same edit must reflect on the other. How can I do that ?
0
votes
0answers
63 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
20 views

Charts does not follow page flow when printing

I'm trying to print a sheet with a bunch of charts. When printing it seems like the charts doesn't count as part of the page as the formatting of the pdf og printed page does not at all reflect how ...
0
votes
0answers
18 views

Why don't the Google Spreadsheet notes line up after several sorts?

I inserted notes into my Google spreadsheet to add comments. For several weeks no problem. Now I've discovered that after several sorts in various ways, e.g., date, name, city, etc., the ...
0
votes
0answers
41 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
110 views

How do I use a script to reference multiple cells in relation to the host cell? [duplicate]

I'm trying to make a script for a custom function in Google Spreadsheet to work out the hours worked in a day. My problem is after searching I can't work out how to reference cells relative to the ...
0
votes
1answer
360 views

How to paste a comma separated string over multiple cells in Google Spreadsheets

Say I have a string of: l,f,x,a,s,f I would want to paste this every comma separated value over 6 adjacent cells. How would I do it?
0
votes
1answer
67 views

How can I copy all the data from certain colored cells in a Google Spreadsheet to a single cell?

I've only just started using a spreadsheet and I'm wondering how to take all the data from cells of a certain color, then place that data in a single cell?
0
votes
0answers
43 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
1answer
240 views

Google Drive Spreadsheets: how to take form responses from one sheet to update the next?

References: Identifier number is the key field which we are wanting to use to link the two sheets together (this will also be referred to as "id") First sheet is the full list of identifiers and ...
0
votes
0answers
54 views

Import info from multi tabs in a spread sheet to one sheet

I'm looking to move data from "sub sheets" to the main sheet. I know I've done this before but it's been 5 years since. So here's what I'm looking for: ...
0
votes
0answers
74 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
1answer
349 views

How do I reference a cell string to use as a note in another cell?

I'm simply looking for how to link one cell's data into another cell as a note. What I have here simply errors telling me I do not have permission to setNote. :/ function noteSetter() { var ss = ...
0
votes
0answers
135 views

Continue formula on Form submission

I want the following formula to be continued on form submission: =ARRAYFORMULA(D2:D*E2:E+L2:L*M2:M+Q2:Q*R2:R) I came across =ARRAYFORMULA(FILTER(D2:D;D2:D<>""*1.2)) this formula works perfect ...
0
votes
0answers
25 views

Assistance with my 1st Script to run inside Google Spreadsheet

I need a simple script to run in a Google spreadsheet that takes the text in cell A7 (which is a formula but without the equals sign in front of it, so the sheet treats it as text. And puts it in ...
0
votes
0answers
76 views

Data validation from other Google Spreadsheet

My scenario : Google Spreadsheet A Google Spreadsheet B I want a Data Validation in one cell in Spreadsheet A that it's criteria is based from a list from a range on the SpreadSheet B. I know ...
0
votes
0answers
38 views

Count occurrence of names separated by quarter

I'm building a quarterly count sheet from a log sheet ('2014 Sanction Log') in the same spreadsheet where L:L is where the names exist that I want to count the occurrence of and A2 is the name on the ...
0
votes
0answers
109 views

Pass range in Google Apps script custom color sum function without using A1 notation

I want to sum up lines with Google Spreadsheets where the cells have a certain color. Since it needs to be copied down I want to have a function that doesn't use the A1 notation. There is already a ...
0
votes
0answers
82 views

Merging two lists with common entries in Google Spreadsheet

We're populating two separate worksheets in a Google Spreadsheet, through 3rd party integration. In essence, we're collecting customer information through a Wufoo form and their payment information ...
0
votes
1answer
171 views

Google spreadsheets Conditional Formating Formula

I am having trouble highlighting all cells in a column that do not contain the same text that is found in the first cell at the top of the column. I would like to accomplish this with a conditional ...
0
votes
1answer
53 views

Merging spreadsheets

I have three Google spreadsheets that I want to merge into a master spreadsheet, so that each new entry in any one of the three spreadsheets will automatically update the master. How can I do that ...