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

learn more… | top users | synonyms (2)

0
votes
0answers
27 views

How do I improve this encodeURL Google Sheet custom function so that it no longer invokes too many times per second?

Here is my Google Sheet function encodeURL: function encodeURL ( r ) { if ( r.constructor == Array ) { var out = r.slice(); for ( i=0; i< r.length; i++){ for ( j=0; j< ...
0
votes
0answers
88 views

How do I sum cells according to cell or font color?

I would like to sum cells based on either the color of the cell or the color of the text contained therein. I guess there was a way to do this before the update, but it doesn't seem to work anymore. ...
0
votes
0answers
50 views

How to make my Excel formula work when transferring it to Google Spreadsheets

I am trying to convert an Excel program that tracks repairs inputed by staff and updates a master file. I had the formula working and once I had transferred it to Google Spreadsheets it stopped ...
0
votes
0answers
23 views

Where is the official comprehensive reference page Google spreadsheet URLs

Google Spreadsheets URL Syntax and Display Options? was a question that was answered by referring to an old page: http://code.google.com/apis/spreadsheets/data/2.0/reference.html#Parameters ...
0
votes
0answers
35 views

Listing live stock prices with 15 minute intervals in Google sheets

I use google Sheets to keep an eye on stocks. Their live data is all I need. I would like to have a sheet that adds a new row with the stock price and time every 15 minutes. Is this possible with the ...
0
votes
0answers
473 views

Complex Index and Match with three criteria

I need to create a formula that will match three criteria in a range on another sheet, and where they match, return the value in an adjacent cell. The problem I have is that one of the criteria is a ...
0
votes
0answers
68 views

Equivalent of Google's ImportXML in Excel Online

I wonder what is the equivalent of Google's ImportXML in Excel Online? I basically need my workbook to get an external XML data, and refresh it every X minutes.
0
votes
0answers
235 views

How to get Google Spreadsheets to auto-update a reference to another sheet

Referencing: How can I get Google Sheets to auto-update a reference to another sheet? I am trying to do the EXACT same thing for the EXACT same reason. I assume this is a VERY clever work around but ...
0
votes
0answers
375 views

Countdown timer list

Can someone check the javascript code and see what can be done. I am struggling to add B2 time to the start time I think i need to convert B2 time to milliseconds and them sum with the start time to ...
0
votes
0answers
8 views

Keep track of printing in Google Sheets

In Google Sheets is there a function that will record and update a field every time a file is printed? Couldn't find anything in the docs. I'm trying to automate a version number for printed hard ...
0
votes
0answers
19 views

Spreadsheet not sorting properlty

When I attempt to Sort a spreadsheet by the information in a column I am greeted with the result: "This operation is not permitted because it would alter the structure of this table. More ...
0
votes
0answers
37 views

How do I avoid cells being printed as “Loading…”?

When I print (or export to PDF), some cells has value Loading... instead of actual value. It looks like Google Spreadsheet was still calculating values when it converted document to a PDF, although ...
0
votes
0answers
40 views

Google Docs equation for adding rolling dates and two different column

I'm a pilot that sometimes flies a plane with a single engine and other times I fly a plane with more the one engine. What I would like to do is have an equation that will take these two columns and ...
0
votes
0answers
19 views

Saving Certain Columns in Google Spreadsheets

Good morning! I am trying to organize a Google-Spreadsheet to enable "territories" to be viewed in the Filter View. I would like the user to be able to edit the data, but I would like certain ...
0
votes
0answers
39 views

Strange wrong result in Google Sheet using ImportHTML

Please consider the following formula: =IMPORTHTML("http://www.cvr.dk/Site/Forms/PublicService/DisplayCompany.aspx?cvrnr=30436709";"table") Strangely I get this value While on the web pages I ...
0
votes
0answers
16 views

Don't show current users in embedded Google doc

Is there a way to hide current users from an embedded Google spreadsheet (simple iframe)? A cursory Google search doesn't seem to bring up anything.
0
votes
0answers
51 views

Display Sheet Name in Google Sheet

How can the current sheet's name be displayed as the result of a function in a Google Drive Sheet? I know this seems like a duplicate of Display Sheet Name in Google Spreadsheet but the answer to ...
0
votes
0answers
34 views

Break line in Google spreadsheet automatically

I have a document in Google Spreadsheets and I want when I enter a bigger text for it to fill the cell and after jump on the second cell and so on. Is there a way to do that?
0
votes
0answers
27 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
168 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
10 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
0answers
169 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
0answers
51 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
115 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
0answers
486 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
0answers
45 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
99 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
72 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
91 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
96 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
43 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
78 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
680 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
32 views

'New Row' Spreadsheet List function

I have set up a Google Docs Spreadsheet to use as a job booking in system for my design agency. I'd like to have this where the newest jobs are at the top, but at the very top is a blank row, where a ...
0
votes
0answers
62 views

Auto receipt filler

I have a spreadsheet that has two sheets, in which I pull data from for making printable receipts. At this point, I am doing it manually by copying the data from the first and second sheet and putting ...
0
votes
0answers
521 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
137 views

Google Spreadsheets formula error

I have the following formula in a sheet that works in Excel but comes up with an error in Google Spreadsheets. =(IF(A6<=TODAY(), INDEX($AS$2:$AU$12,MATCH(A6,$AS$2:$AS$12,1), ...
0
votes
0answers
74 views

Spreadsheet Data into a Form

I am building a simulation (a "create your own adventure") for my students in which they use a Google Form to select into which of 5 groups they would place 25 first graders (Round 1). I get the ...
0
votes
0answers
61 views

Using a dynamic OFFSET & ISBLANK() function

I have a spreadsheet I'm working on that we use to run large corporate events. Each segment length has a length as well as corresponding start time. I want each cell in the time column to look above ...
0
votes
0answers
53 views

A simple spreadsheet sorting

In a Google Spreadsheet I have different groups of cells in one column to auto-sort. All cells in this column have same pattern of data, all datum have it's own cell and it's needed to be sorted into ...
0
votes
0answers
255 views

How do I reference only the elements of a multi-column range that meet particular conditions?

I have a spreadsheet made up of several individual sheets: one sheet for each category of product and one sheet designed to be a "global view." In each sheet is a 3-column range of variable length ...
0
votes
0answers
544 views

How to use Google Scripts w/ spreadsheet and jotform to auto sort so the newest entry is always listed on the top row?

I'm trying to setup a form and spreadsheet database to track inventory on a daily basis at a remote location. The idea is that the person at the remote location can update our stock via a simple ...
0
votes
0answers
40 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
158 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
471 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
287 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
159 views

Create new document within spreadsheet and link

I would like to create a spreadsheet script that allows me to create a new document every time I click on a new cell or row and then have that document links back to that cell.
0
votes
0answers
408 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
514 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 ...