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

learn more… | top users | synonyms (1)

0
votes
0answers
22 views

Trying to convert “=importhtml” to UrlFetchApp.js

I'm trying to replace my cell which is =importhtml into a .js for Google App Script. The current function in Google Sheets now is =importhtml("http://www.gurufocus.com/financials/"&'Raw ...
0
votes
0answers
53 views

How can I stop Google Spreadsheet Now() function from auto updating?

I'm using the now() function as a shortcut to insert the current timestamp. However, the value of the time in the cell changes whenever the spreadsheet is modified. How can I stop the value in the ...
0
votes
0answers
22 views

Fill-down in Google Spreadsheets

I'm looking for something in Google Spreadsheets that provides fill-down functionality. Equivalent to Ctrl-D in Excel. I am selecting a range of cells for the fill using named ranges. The range is ...
0
votes
0answers
8 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
1answer
32 views

How to get the count of the current sheet?

I have a spreadsheet that I have spread out over many sheets. However, I could automate the filling out of some simple data by doing some simple calculations. I could program something simple like ...
0
votes
1answer
92 views

Relative copy conditional formatting that references other worksheet

I have a group of worksheets, one of which has 'default' values while the others should only have values if they differs from the default worksheet. To facilitate this, I want to use conditional ...
0
votes
0answers
57 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
1answer
41 views

How to add some text value in cell

I am newbie in Google Spreadsheets, but I would like to know how I can select a column with values and add in every selected cell some text, i.e <KB> . Is possible to perform via Regex ...
0
votes
0answers
39 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
19 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
28 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
1answer
55 views

Counting occurrences in Google Spreadsheet

I've been brought on last minute to sort out tent allocation for a festival of about 1500 pax. Their ticket sales are a spreadsheet on Google Drive. I have never done this kind of thing before (I'm ...
0
votes
0answers
161 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
1answer
33 views

Auto Insert Address on adjacent cell

I am trying to create a spreadsheet which enters address automatically on adjacent cell when I type in the company name. The script will be as I type in company name in cell A1, it will search for ...
0
votes
1answer
2k views

Error: Circular dependency detected

I am very beginner to google scripting. Here I need to count the number of times the word "FREE" occurred in my sheet. But my function Returns me an error "Error: Circular dependency detected" Please ...
0
votes
1answer
462 views

Copy cell from cell to another sheet if row contains x

I'm new to sheets, I have a sheet with 10 pages. I need to auto fill sheet Report if sheet David contains "1" in column "i". I need to copy cells C14 - C34, J14 - J34 and L14 - L34 only if there is ...
0
votes
0answers
42 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
99 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
17 views

OR function doesn't work inside FILTER [duplicate]

When I use FILTER(A2:A; OR(C2:C >0; D2:D >0)) I get different range intervals error, but when I remove the OR it doesn't return an error. So why OR function can't be used with FILTER function?
0
votes
0answers
186 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
18 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
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
1answer
40 views

Search for multiple variables in multiples rows at the same time in Google Sheets/Drive

I'm using Google Sheets (only option, sorry, know this should be a database). Sheet 1: List of 200 employee names, and up to 10 location codes they are frequently assigned to. Sheet 2: List of 50 ...
0
votes
0answers
33 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
1answer
54 views

Google Sheets: Evaluating each cell in a row based on the cell adjacent to it [duplicate]

I'm trying to set up a spreadsheet the will color the background of a cell based on the text within another cell. This would have to be set up in a row so that if (for example) B2: contained "done", ...
0
votes
1answer
33 views

Average with parametric cell in Google Spreadsheet

I'm desperately looking for a way to write a function like this: =SUM(A1:CELL(B1))/COUNT(A1:CELL(B1)) where CELL(B1) contains a text, for example "A37". In this way, I can do the average only in ...
0
votes
0answers
32 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
1answer
124 views

How do I add a counter value into a cell once a row is added

I work for a small company that monitors all service calls in an old database. I recently moved this database into a Google Spreadsheet and a Google Form. Once a user submits a ticket, I would like ...
0
votes
0answers
31 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
14 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
138 views

How to choose custom colors for Google Spreadsheet charts?

When selecting the color for a line in a chart, I see 80 choices of colors. Is there a way to add new colors or set a color using RGB, HSV or HTML colors?
0
votes
0answers
35 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
31 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
1answer
68 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
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
24 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
209 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
120 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
142 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
891 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
125 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
30 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
34 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
85 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
87 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
64 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
302 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
72 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. ...