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

learn more… | top users | synonyms (1)

0
votes
1answer
68 views

Importing Columns of Data

I'm trying to import columns of data from different sheets. Examples SEARS -- (sheet one) (I'm entering the prices manually) 1/2013 $8 2/2013 $5 3/2013 $14 Here is sheet two: (I'm entering ...
0
votes
0answers
40 views

Add Drop Down Boxes into total

I'm trying to style this sheet better so a user can select items from Everquest Next Landmark and get a total of all the items needed to craft it all. Basically if they want to add up a copper ...
0
votes
0answers
234 views

Populate Google Form field from spreadsheet to generate unique url

I have a customer satisfaction form that I am going to send out to multiple people. I'd like to link that survey to a unique incident number. Each person can fill out a survey multiple times for ...
0
votes
1answer
775 views

How can I use Google Spreadsheet to format Date in DD/MM/YYYY format?

First thing's first: my spreadsheet's locale is properly set to UK: If I paste in the following date: 30/09/2013 21:15 Then click Format > Number > Date time Nothing changes. I also can't ...
0
votes
0answers
58 views

Work around app script for notifications on new google spreadsheet

I need a work around app script for notifications on new google spreadsheet. I would like to have an e-mail notification sent to me if someone makes changes or additions to column D.
0
votes
0answers
527 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
33 views

Google Spreadsheet print column-wise

I want my Google spreadsheet to import data from another Google spreadsheet. And I have successfully done that. But now I want to design a game in which I need the data to be imported and written ...
0
votes
1answer
89 views

Use sort function but filter results

I'm looking to use the =SORT function on some data, but I only want the first result with that name. Column A contains a Name, column B contains a level, and column C contains a date. I'm currently ...
0
votes
0answers
96 views

“ImportXML” function in Google spreadsheet for “answers.yahoo” site

Please help me understand why this formula =importXML("http://answers.yahoo.com/search/search_result?fr=uh3_answers_vert_gs&type=2button&p=cloud","//ul[@id='yan-questions']") is not ...
0
votes
0answers
33 views

forms automatically generate individual sheets

Is there a function which will allow data submitted via forms to create an individual sheet within my master file, in addition to being incorporated into the master list. For example, in the data ...
0
votes
0answers
38 views

Google Sheets Custom Sort

I need help creating a script to select only rows 15 to 630 (a15:z630) of my "DASHBOARD" page and sort these rows by column A (date). The first 14 rows are frozen and must never be sorted. ...
0
votes
1answer
147 views

Create a master sheet for formatting in a Google Spreadsheet [on hold]

I have a sheet for each month's personal expenses with a chart and all. I am still changing formatting and have to change everything for every sheet individually. What I would like to have is: An ...
0
votes
1answer
155 views

Time Triggered Script to Change Cell Contents

What I want to do is for example: A time will be manually entered into a cell say D3, when it is 20 minutes before this I want cell D1 to change to "20 MIN", WHEN IT IS 5 minutes before I want to ...
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
58 views

Error in Query function with aggregate function in two column & Pivot

I have an error while using query function which I have used in “Solution” Sheet. Below is the function that I have used: =QUERY(Problem!A6:G3493,"Select C,sum(F),Sum(G) group by C Pivot D label C ...
0
votes
0answers
56 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
1answer
304 views

Google Spreadsheets Query( “where a matches '/[A-Z+]/' ”) condition

According to Google Query documentation: matches - A (preg) regular expression match. haystack matches needle is true if the regular expression in needle matches haystack. Examples: where ...
0
votes
0answers
119 views

Formatting a Google Docs spreadsheet (sorting multiple entries, linking tabs, incrementing numbers)

So, I'm trying to work with this spreadsheet I've created. I was wondering … is there a way to add a button of some kind, so that people can choose how each group is sorted? So they could sort by ...
0
votes
0answers
54 views

Import Google SpreadSheet data into Google Adwords via a script

Google Adwords data can be exported to a Google SpreadSheet, by using a script. How can I import Google SpreadSheet data into Google Adwards, with the usage of a script? I've gone through the API ...
0
votes
0answers
51 views

Google Sheets Function to have a button take you to a specific sheet

So I followed the instructions to make a function as found here. But when I click the button I made, it takes me to the correct sheet but all the data is hidden. In this example I clicked the ...
0
votes
0answers
289 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
109 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
1answer
629 views

Generating charts from Google Form Data via Google Spreadsheets

I have two colums that are generated from a google form: I would like to create two pie charts, one for City A and one for City B, showing the percentages of male and females from those cities. I ...
0
votes
0answers
61 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
1answer
901 views

Script error trying to populate form drop down menu from spreadsheet

We are trying to link a list on a Google Spreadsheet to a drop down menu on a Google Form. The twist is that this Google Spreadsheet list will be continuously updated and needs to automatically ...
0
votes
2answers
2k views

Counting unique values based on multiple columns

I am working in Google Spreadsheets and trying to do some counting that takes into consideration cell values across multiple cells in each row. Here's my table: |AUTHOR| |ARTICLE| ...
0
votes
1answer
39 views

Prevent the cell from expanding to the size of cell contents in a Google Docs spreadsheet every time I open the doc?

I know how to "Wrap text" to make this happen, but my issue is I am having to do this EVERY time I open a spreadsheet in Google Docs. It is a quick couple of clicks, but it adds up. Is there a way to ...
0
votes
0answers
49 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
144 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 ...
0
votes
2answers
596 views

Show data from one sheet on another if date is today

I have a list of people responsible for data verification that are changing every day. The schedule is on one sheet. And data verification is on another. What I need is to show only responsible ...
0
votes
0answers
52 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
27 views

How to have function input row/cell automatically update in response to new data? [duplicate]

I apply a function, such as SUM(A10:A20) to a set of data. When I give A21 a value I would like SUM(A10:A20) to automatically update to SUM(A11:A21), "following" the last X number of cells in a ...
0
votes
0answers
300 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 ...
0
votes
0answers
210 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
1answer
907 views

Getting SUM function to work in Google Spreadsheets

I'm trying to get something like this. These are all in minutes I guess it goes that way when I type them like this. Number Time After Work TOTAL 1 1:52 2:00 ...
0
votes
0answers
25 views

How to return the latest date in Google Docs Spreadsheets? [duplicate]

I would like to return the latest date from a number of dates in Google Docs Spreadsheets. In Excel MAX(E2:L2) would give me the latest date, but Google Docs just gives me a number: 40505 instead ...
0
votes
1answer
209 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 ...
0
votes
1answer
241 views

Google spreadsheet cell outcome dependent on another cell’s range

Example: column A1 is $35.00. I want column B1 to be a percentage markup value dependent on the value in A1 (i.e.: 75%). So if A1 is between $1 and $10, B1 = 75%; if between $11 and $20, B1 = 60% and ...
0
votes
0answers
463 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
39 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
1answer
123 views

How do I populate a cell in one spreadsheet to a cell in another spreadsheet in the same workbook in google docs?

In Google Spreadsheet, I have created a master spreadsheet that I complete with the amounts of the items needed. I would like those numbers to auto populate in each individual spreadsheet in the ...
0
votes
0answers
147 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
1answer
209 views

Google spreadsheet multiple auto-sorting

In a Google Spreadsheet I have different group of cells to auto-sort ascending i.e. table range a3:c16 columntosortby = 2 table range d18:f31 columntosortby = 5 table range g33:i46 columntosortby = ...
0
votes
1answer
136 views

Google Spreedsheet, Auto sort in 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 ...
0
votes
0answers
765 views

How to make Google Spreadsheets recognize data as numeric

I have the opposite of a fairly standard problem -- how do I force Google Spreadsheet to understand that a value is numeric? It seemed like using Format > Number should do the right thing, but it did ...
0
votes
0answers
359 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
2answers
2k views

Google Spreadsheets formula question: do not include cell in a formula if blank

I am a music teacher and I use the following formula to calculate my students performance grades: =100-SUM(F3-5)*-7 How can I change the formula so it only calculates a grade if there is data in ...
0
votes
0answers
277 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
155 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
342 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 ...