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

learn more… | top users | synonyms

0
votes
2answers
435 views

How can I link 2 cells in Google Docs in the same document, on the same spreadsheet?

How can I link 2 cells in Google Docs in the same document, on the same spreadsheet? I have a headings and every time I have to scroll down to the one I need. Can I create some kind of "header" on ...
0
votes
1answer
470 views

Referencing a cell range relative to the bottom of a sheet

I am developing a "Daily Personal Inventory" spreadsheet based off a related Lifehacker article. I've successfully made a few modifications based on my own circumstances/goals, but there is one ...
0
votes
2answers
905 views

Editable google spreadsheet on Google site - assign username

So here is what I am trying to do: Have a Google site that has an embedded editable Google spreadsheet on that allows end users (if they have been given permission) to edit the spreadsheet. Here is ...
0
votes
2answers
2k views

Sum of numerical values excluding formulas in a Google Spreadsheet

I have a long column of numbers in Google Spreadsheet, and occasionally there exists a cell that sums some of the cells below it. For example: =SUM(2:4) 5 10 30 =SUM(6:8) 40 10 10 ...
0
votes
1answer
324 views

Working with names in Google Docs Spreadsheet

I have created a spreadsheet to keep track of my players on my team, I would like to sum all of their individual times playing regardless of who they played (different players). Is this possible? ...
0
votes
1answer
2k views

Google Docs ImportXML can't scrape anymore?

ImportXML lets you get information from filetypes such as xml, html, csv, tsv, as well as RSS and Atom feeds. This example in Google Docs Help for importXml function - =importXml("toysrus.com";; ...
0
votes
1answer
1k views

Google docs spreadsheets: Copy data down into next set of blank cells, if any, for whole column?

I have some text that I've taken in from a pdf that isn't exactly synced up with the right lines as much as I'd like: I want to duplicate the column A and D values down into any empty spaces/rows. ...
0
votes
2answers
80 views

Create a formula based on the number of columns in Google Spreadsheets

I have two rows of data Row B = price of product Row C = quantity of producst I need to get the summary price: (B1xC1)+(B2xC2)+(B3xC3)+..+(Bn+Cn) I don't know n (quantity of columns) because n ...
0
votes
1answer
158 views

Entering Local Date on Google Doc Sheets

If I use the shortcut CTRL+;, the date that is pasted is the server date. I have changed the settings so my Time zone is selected to my local time. Shouldn't my Local time get pasted as opposed to ...
0
votes
0answers
20 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
43 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
12 views

“Object not found” error when saving a Google Apps spreadsheet in Box after edit

The corporate entity that I work for is rolling out Box.com, and since we like the collaborative features of Google Apps, I am experimenting with the Box.com integration with Google Apps. Using the ...
0
votes
0answers
11 views

Google Spreadsheet SQL subquery “where not in”

I'm attempting to perform the following SQL command concept, but with two sheets in the same google spreadsheet document: select * from table1 where column1 not in (select column1 from table2) How ...
0
votes
0answers
10 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
1answer
30 views

Google Form to Spreadsheet formula questions (index/match array and 24hr-12hr clock)

I need help with a Google Spreadsheet populated by a Google form. I cannot get the following formula to work correctly with my form submissions: =(ARRAYFORMULA(if(row(H:H)=1,"Language",(INDEX('INDEX ...
0
votes
1answer
21 views

How do I merge columns but preserve data Google spreadsheets

Column A is a list of every day from 1/1-12/31, Column B is a list of specific dates within the range of column A. Columns C-N are events that took place on the corresponding date in column B. How can ...
0
votes
0answers
16 views

google spreadsheet MAX SORT FILTER ROW

I have this kind of table Row| A | B | C | D 0 | Date | Code | Operation | Prev Row 1 | 2012-01-01 | IFF | 1000 | ?? Should be 2 2 | 2010-04-04 | IFF ...
0
votes
0answers
21 views

If statement to input the next integer

I have a row of values that sometimes returns a value, and sometimes doesn't. I want to input the first number that is actually a number. Sheet Value Indicators Column A Column b ...
0
votes
0answers
12 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
1answer
13 views

Query MAX group by

I'm trying to Query in only the most recent entries of each part number. I can usually figure this stuff out but cannot figure out why it only returns the (date) and not the (part number) and (most ...
0
votes
1answer
51 views

Why is data suddenly being pasted in Excel as a single cell when copying from Google Docs?

I have been using Google Docs for some time now and have been able to copy certain sections of columns of the spreadsheet and paste it into an Excel sheet and up until now it has transferred exactly ...
0
votes
0answers
98 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
0answers
34 views

How to Embed google map to your google spreadsheet

Suppose i have the following columns in my Spreadsheet Lat/Long | Tooltip [lat,long] | Some text goes here I know, it was possible to embed Google map (using gadget [deprecated]) to your ...
0
votes
1answer
35 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
26 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
1answer
74 views

Dynamic generation of cell list / array from range value in Google Spreadsheets

I want to create an array/ a list of cells (i don't know the exactly terminology), in rows or columns form, covering the range between 2 numbers Fox example, I have 2 cells, A1 = 3; B1 = 10 I want ...
0
votes
0answers
27 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
77 views

Help with conditional formatting in Google Spreadsheet

I have a Google Spreadsheet with several sheets. I have it set up to where orders auto populate 3 of these sheets when entered into the Order info page. I need to set up a function where only ...
0
votes
1answer
68 views

How does one filter pivot tables by date range in google spreadsheets?

I have a google spreadsheet that keeps track of time spent on graphic design projects. I am trying to run pivot table reports to understand where we can optimize projects. In these pivot tables I ...
0
votes
1answer
104 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
1answer
22 views

How to have charts include added rows in google docs

The problem is, it it's modifying my range selection. In the chart I select ranges Sheet2!A:A, Sheet2!B:B, but after clicking ok, and going back into the chart, it modified my range selection to ...
0
votes
0answers
47 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
64 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
19 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
1answer
41 views

Track/compare my inventory with my supplier

I'm trying to use Google Spreadsheets to track/compare my inventory with my supplier, but I'm having some issues. I'm able to download an up to the minute inventory log form my vendor, but I can't ...
0
votes
0answers
26 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
21 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
61 views

Custom field names in form linked to Google Spreadsheets

I would like to use Google Spreadsheets to store responses from a custom form. The name attributes of the input fields appear to be randomly generated (entry.<random num>). Is there anyway to ...
0
votes
1answer
29 views

SUMIF not working

I have values in column L and I'd like to SUM what is in column B IF the value in L is greater than 1600 Here is my formula: =SUMIF(L2:L,">1600",B2:B) I'm getting a result of 0 in the cell ...
0
votes
0answers
78 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
41 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
93 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
37 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 ...
0
votes
0answers
40 views

Why does my Spreadsheet keep automatically adding rows?

It probably has something to do with my Array formulas. I'm guessing but why does it seem like whenever I input a value in one of the column's cells, it would keep adding rows automatically? It also ...
0
votes
0answers
52 views

How do I sort forms individually based on individual events in Google Forms?

My purpose is to conduct 5 events, namely 1,2,3,4,5 say ... I'm using a Google form to accept responses from people. Emails are sent to people automatically and they can register for more than 1 ...
0
votes
1answer
320 views

Grouping Pivot Table Date Settings Into Weeks or Months in Google Spreadsheets

In Microsoft Excel, in a pivot table, you can right click on the dates - while within the pivot table, on a date and select 'group' (from the drop down menu) - then you can choose different groupings, ...
0
votes
1answer
27 views

Google Sheets, Suddenly decimalised some of my number entries

I've been using Google Sheets to create a record of car parts, entering: each part's serial number, the quantity of that particular part, the name of the part and the location where I'm ...
0
votes
1answer
55 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
29 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
1answer
186 views

Make first row in Google Spreadsheet column names

I cannot figure out how to turn the first row of a Google Spreadsheet into column names so that I can sort the spreadsheet by column without losing the variable names at the top of the spreadsheet. I ...