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

learn more… | top users | synonyms (2)

1
vote
1answer
424 views

Google docs spreadsheet - limit values to other ranges

I'm trying to create a docs spreadsheet that defines various objects, and these objects sometimes reference each other (equivalent to SQL foreign key). Is there a way that I can limit the values of a ...
1
vote
0answers
26 views

Formula syntax to use a cell data as reference to another cell in a Google spreadsheet [duplicate]

Say I have the cell A1 which contains the number "13". I want to use that number to refer to a specific cell doing something like ='Items'!C"A1" which would mean ='Items'!C13. What is the proper way ...
1
vote
0answers
50 views

Adding and deleting sheets in Google Spreadsheets

How can I restrict users from adding new and deleting existing sheets in Google Spreadsheets? Only the owner of the spreadsheet should be able to do that. Other users should not be able to do that.
1
vote
0answers
17 views

Find out the folder path of the current doc in Google Docs [duplicate]

I am able to search a file and open it. But I am not able to locate the folder which has this file. There is not Properties in the File menu.
1
vote
1answer
486 views

Index-Match on Arrayformula

I'm making a database in google drive. In one column I have abbreviations of a number of departments someone is in, but people can be linked to multiple departments. The abbreviations are ...
1
vote
0answers
142 views

Importing only certain rows

I am attempting to create a spreadsheet based off another spreadsheet. I only wish to import certain rows based on the second column of the first spreadsheet. If that column contains certain users ...
1
vote
0answers
195 views

setDataValidation in google script not working

Have a problem with setting data validation rules in a google spreadsheet using apps script. Below are two functions, one is an onChange function which will be triggered whenever a user changes the ...
1
vote
1answer
74 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 ...
1
vote
0answers
192 views

Use of importdata with arrayformula

I’m using importdata to retrieve Yahoo stock information, which works fine on indivdual rows, but when combined with arrayformula to fill down the page when additional symbols are added does not ...
1
vote
1answer
152 views

ImportHTML and SUM the column

I am looking to use the importHTML function for loading a page and I would like to sum a particular column in Google Spreadsheets. But I am not having much success. This is the URL: ...
1
vote
1answer
62 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 ...
1
vote
0answers
62 views

Automating Google spreadsheet to transfer new info

I'm looking to setup a production line with Google Spreadsheets. Here's how I intend it to work: Our Sales Rep John has a spreadsheet specific to him only. He takes in sales leads, and inputs the ...
1
vote
1answer
1k views

Data Ranges in Custom Google Spreadsheets Function

I'm trying to create a custom Function in Google Spreadsheets that takes a range as input parameter. function Example(cells){ var values = ...
1
vote
2answers
684 views

Google Spreadsheet =ImportHTML #value error for specific URL

I'm trying to get the data from http://wodindex.wikispaces.com/ into my spreadsheets. Also from a different subdomain of wikispaces.com the grabbing doesn't work. Trying to get data from this site ...
1
vote
0answers
94 views

Automatic data sharing between Google Docs files [duplicate]

Is it possible to automatically update information on a Google Presentation or Document based on information in a Google spreadsheet? For example, I could create a presentation that contains a graph ...
1
vote
0answers
384 views

How can I get a cell to change it's value based on another cell's color?

So I have three colors in column F, green, grey and red. What I want is for column G to display a number (1, 2, 3) depending on the color value of F. Is there a way to do this? Here is a link to a ...
1
vote
1answer
277 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 ...
1
vote
0answers
108 views

Relative paths to other sheets inside a Google Spreadsheet

I'm trying to put our food recipe collection into a Google Spreadsheet. On the first page we have an index of all the foods. Each recipe is located on a separate sheet. We would like to be able to ...
1
vote
0answers
282 views

Google Sheets: Reference one sheet from another, where the user may not have view access to the referenced sheet

This is what I'd like to do: The public (even you!) would have view access to a particular Google sheet. It would draw data from another Google sheet, which you DO NOT have any access to. Using ...
1
vote
0answers
81 views

Auto paste formula on form submission

I have searched and tried various solutions elsewhere but none seems to work for both conditions. I would like to have the formula: =IF($A2="Elementary", VLOOKUP($B2,'ELEM PRINCIPAL'!$B:$AA,7,false), ...
1
vote
1answer
151 views

Inserting rows and adding a cell reference

I'm trying to automate adding new rows if I'm on the last few rows of my sheet. It works, but since I'm also adding a cell reference to it, and checking the amount of free rows left using ...
1
vote
1answer
257 views

Creating a class roster in Google Spreadsheets from a split result

A lecturer from the European School of Physiotherapy in Amsterdam stumbled on a particular script I prepared, hoping it would resolve a problem he had. After having had a little chit chat, it turned ...
1
vote
0answers
836 views

Google Apps Script UrlFetchApp and password protected pages

I'd like to be able to use Google Spreadsheets to login to my registart and automatically list into rows the current name server and email settings of all my sites, rather than use the heinously ...
1
vote
0answers
570 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 ...
1
vote
1answer
168 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 ...
1
vote
2answers
160 views

Auto sort a sheet so that entries remain in their categories

So I want to sort my Spreadsheet on Google but it remain in the Categories that it's laid out. I can get to it sort double columns but the categories get messed up as they move away from where they ...
1
vote
2answers
885 views

How to SUM() a column from one Google Spreadsheet in another spreadsheet

Has anyone been able to return the SUM() result of a column in one Google Spreadsheet to a different spreadsheet? I am trying the ImportRange(key, criteria) but I am not having any success. I am just ...
1
vote
0answers
492 views

ARRAYFORMULA Using Row Above - Google Spreadsheet

I would like to create a column that contains a running decrementing tally, but is decremented by an amount from a different column on the same spreadsheet. Also, I would like to be able to add rows, ...
1
vote
2answers
863 views

Problem QUERY function in Google Spreadsheets formula

I tried this formula: =concatenate(query('Scheda Intervento'!C2:K14;"select SUM (K) where (F>= date '2013-01-01' and F <= date '2013-01-31' and C = '" & A2 &"')";0)) The result is ...
1
vote
2answers
156 views

Share individual copies of a Google spreadsheet

I created a Google Spreadsheet file which I want to share with my coworkers so each one has his own copy. So far the only way I found is to share the file, however these doesn't work for me because ...
1
vote
0answers
357 views

How to tally entries by user, date

I am using a Google spreadsheet to track entries by several users. How do I measure their productivity per day? Or per hour? I have the timestamp field, a user field and other fields, but what I want ...
1
vote
0answers
492 views

How to protect table cells in Google Spreadsheets from myself (accidental edits)?

As in Microsoft Excel, I want to protect certain cells in Google Spreadsheet. This is possible, but asides from the fact that it is quite confusing to me, it doesn't seem possible to protect cells ...
1
vote
0answers
801 views

Sorting on a web-published Google Spreadsheet

I have a Google Spreadsheet that is published to the web and embedded in a website. This spreadsheet has data about hotel rooms, such as hotel name, number of rooms, date in and out, etc. I would ...
1
vote
0answers
110 views

In a Google Sheets chart how do I prevent “Other” in the legend?

When there are over 8 series in a chart (this is true at least for a pie chart) - Sheets combines all other series above the 8th into "Other" this is really counter productive when there are only 9 ...
1
vote
0answers
734 views

Google Docs capabilities

We've created a commission calculator to help our resellers work out what commissions they will receive on a deal. We built it in Excel 2010 but want to move it to a web based platform that will ...
1
vote
0answers
616 views

How to make a query with Google Spreadsheet, that returns rows if deadline is two weeks from today, one month from today, 2 months from today, etc

I have a spreadsheet that contains several columns with project information. I basically want to modify the following formula: =QUERY( 'Compilation'!A2:L; " select A, B, F, I, L order by A" ; 0 ) ...
1
vote
0answers
278 views

Google Sheet document using ImportXML doesn't Automatically Republish

I created a file that uses ImportXML to pull prices from a set of web pages, and bless me, it works! To stay updated with the changes in price, I ticked the "Automatically republish when changes are ...
1
vote
0answers
267 views

How to Create a Dynamic SubTables Based On Data From Another Sheet? (Google Spreadsheet)

I'm wondering if there is a way to create a sheet with dynamic subtables based on data from another sheet in google spreadsheets? Each student will use a form to enter data to sheet: "Entries" like ...
1
vote
0answers
86 views

Filtering Form Feedback using Google Docs

Does anyone know how to filter respondent feedback into different sheets on the spreadsheet? For example, each sheet collects information for separate classes and I want the form information to be ...
1
vote
0answers
1k views

Table of Contents in Google Spreadsheets

I'm curious to know if there's a way to create a table of contents within a Google Drive Spreadsheet. I would like to be able to set the active cell in the spreadsheet based on what cell (or contents ...
1
vote
0answers
115 views

How to insert empty row in Google Spreadsheets when two rows are not duplicate?

I have a number of rows in a Google spreadsheet. I want to insert an empty row only when two sequential rows are not duplicate. How can I do this?
1
vote
0answers
164 views

How to graph one column against another from multiple sheets in Google Spreadsheets?

I have a spreadsheet here: graph with one column against another from multiple sheets I want to graph the ascent columns against the distance for each of the three tabs on the graph. How can I make ...
1
vote
0answers
499 views

Can I precisely position charts in a Google Docs spreadsheet?

I am using Google Docs to create a "Monthly Report" spreadsheet for a product, and am attempting to make an attractive, compelling experience for the consumers of the report. In this spreadsheet I ...
1
vote
0answers
139 views

Is there a way to filter columns in Google Docs? [duplicate]

Possible Duplicate: Is there a way to filter columns in Google Docs? Is there a way to filter columns in Google Docs? Column (A) contains new data Column (B) contains filter data, i.e. ...
1
vote
4answers
8k views

How do I get linked Google spreadsheets to auto-update when 'I am not looking' [duplicate]

My question is similar to this one, for which no answer has yet been posted. How can I get Google Sheets to auto-update a reference to another sheet? I am filling one Google Spreadsheet with Zapier ...
1
vote
2answers
149 views

Date autofill increments year instead of day

Earlier, when I had dates in a column like: Monday, 21 April, 2014 Tuesday, 22 April, 2014 and I extended the last cell to lower cells I could expect them to be filled with following days: ...
0
votes
4answers
445 views

How to convert datetime interval to hours?

I have this spreadsheet: A B C D E 1 08/13/2013 02:10 4 2 08/13/2013 02:19 10 00:09:00 160 In D2, I have this formula : ...
0
votes
1answer
10k views

How to link two spreadsheet of Google Docs [duplicate]

Possible Duplicate: Can we do a link between two Google Docs spreadsheets? I'm trying to link two Google spreadsheets. I don't want to merge I would like to have a spreadsheet with the ...
0
votes
2answers
210 views

Calculating time worked per day

How do I add time like 8:20am-12:00pm and then after lunch break 12:30pm-5:02pm to end of day to get hours worked per day? I was using =(B2-A2*24)+(D2-A2*24) but that doesn't work
0
votes
1answer
2k views

Set the headers in a Google Drive spreadsheet to move on screen as I scroll down

How do I set the headers in a Google Drive spreadsheet to move on screen as I scroll down the spreadsheet?