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

learn more… | top users | synonyms (2)

0
votes
2answers
1k views

Sum until empty line function in Google Spreadsheet

I'm using this data layout a lot: A B C 1 Name1 Count Total 2 A 1 =SUM(B2:B4) 3 B 2 4 C 1 5 6 Name2 Count Total 7 D 1 =SUM(B7:B8) 8 E 2 It is ...
0
votes
1answer
2k views

Reseting responses in a GoogleDocs Form

I want to reuse a GoogleDocs Form, with (almost) the same Form, but with fresh Responses. I did copy it, but I don't know how to reset responses (not reseting the form itself, i.e. Form/Delete Form). ...
0
votes
1answer
1k views

Change all values of a column at once in Google Docs

How can I change all values of column A (currently empty) to be 5? In Excel, I could do Paste Special > Multiply. Is it possible in Google Docs?
0
votes
2answers
4k views

Parse HTML through Google Spreadsheet using scripting

I'm trying to speed up the process of getting values from an HTML page to a Google Docs Spreadsheet through scripting. I remember Microsoft Excel had the import data function, but I don't own a copy ...
0
votes
2answers
680 views

not getting sub date granularity in google docs trend lines?

Anyone have an idea what I might have broken that prevents me from getting sub date granularity on google doc's spreadsheet's trend line graphs? My data is in variable increments, anywhere from 6 to ...
0
votes
1answer
19 views

Multiply cell value depending on keyword

I would like to apply a transformation to a table which basically looks like this: If there is a certain keyword in column A, then the number in column B should be multiplied by 2. Is that possible ...
0
votes
1answer
37 views

Applying formula to lookup value in array of cells in Google Form Responses

I have a Google Form response sheet, part of which contains several columns (say B:G) that will only have a single value between them. The form asks respondents for their county of residence and then ...
0
votes
1answer
13 views

What's causing / how to get rid of long web calls in Google Spreadsheets

I have a google spreadsheet that's running into performance problems. It will make really long calls and occasionally freezes up the UI. Here's an example of the type of call that's being made ...
0
votes
3answers
22 views

Update formula ranges when adding new rows to a spreadsheet

I have a Google Spreadsheet in which I keep a list of expenses. I add a new expense by inserting a new row above the last expense. On the first row of the spreadsheet, I keep a sum of all expenses: ...
0
votes
1answer
41 views

Formula help for mileage calculation/constant

I need to create a spreadsheet in Google Drive that will let me calculate mileage for my employees. I know the exact mileage to the locations they'd have to drive to. What I need to do is have a ...
0
votes
1answer
19 views

Google spreadsheet into email

I created a spreadsheet to track clients contact information. For convenience, I entered their email addresses as a hyperlink. When I click on the link, a blank 'untitled' page opens. I'm not sure why ...
0
votes
1answer
30 views

How do I make one cell correspond with another for google spreadsheet?

A B C D 1|Male | 5 |Male avg| 8 | 2|Female| 4 | | | 3|Female| 8 | | | 4|Male | 9 | | | 5|Male | 10 | | ...
0
votes
1answer
44 views

How do I do simple time calculation in Google Spreadsheets?

I have a really simple question, I have searched online and for the life of me, cannot work out how to do this: Calculate the total hours and minutes from a start time to a finish time? Calculate ...
0
votes
1answer
46 views

Is there an online spreadsheet where I can share individual columns?

I sometimes use a spreadsheet when grading student assignments, where the leftmost columns describe the different parts of the assignments and possible points, and there is a column for each student. ...
0
votes
1answer
38 views

Google spreadsheet thinks Chrome is Firefox

I am an Ubuntu user with Google Chrome 39.0 and whenever I enter a Google Spreadsheet-document (with Chrome), I get a warning header saying that "This version of Firefox is no longer supported, please ...
0
votes
3answers
150 views

Can Google Forms & Sheets serve as a kind of DB?

Pardon the naive way I am expressing this question. I'm a teacher trying to create a database of grades. I'm trying to figure out if Google Sheets and Google Forms is sufficient for my task or if I ...
0
votes
1answer
156 views

Google spreadsheet query reference to several sheets

I have this formula: =ArrayFormula({query(query({A3:D,value(B3:B)}, "select Col1, sum(Col5), count(Col4), sum(Col3) where Col1<>'' group by Col1 format sum(Col5) 'h:mm:ss'"),"select* offset ...
0
votes
1answer
45 views

Eliminate empty cells from a sort

I have a spreadsheet where club members scores are added from competitions during the year. I accumulate the data to a sheet with a name column and a value column I then sort these to another sheet by ...
0
votes
1answer
93 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
1answer
93 views

Using SUMPRODUCT with ARRAYFORMULA

I have the following random data in sheet one A orange D yellow C yellow B orange B orange C blue A yellow D blue C orange C blue In sheet two I use the following query function: ...
0
votes
1answer
51 views

How do I have the choice made in an in-cell drop down menu affect the cells next to it?

I have a contact sheet with names going down the list and contact info in the cells to the right of each name. On a separate signup sheet, I used data validation to create a drop down menu with the ...
0
votes
1answer
83 views

Moving from one Sheet to another in Google Sheets

I am using a Google sheets to organize an upcoming project. On the first tab I have every task listed, and who the actor should be for that task. I plan on sharing this sheet with my team... Is it ...
0
votes
1answer
49 views

Show only own record to Google Spreadsheet user and hide data from other users

I'm organizing an event, so I set up a table for people to sign up using Google spreadsheet. For concern of personal information privacy, I'd like to make it only be able to add a new record, for ...
0
votes
1answer
86 views

How to turn cell yellow if date in cell is between 180 and 365 days in the past

In Google Spreadsheets how do I use conditional formatting to turn a cell yellow if the date is between 180 and 365 days in the past?
0
votes
1answer
86 views

Wildcard in Google spreadsheet

How do I convert the following formula to do wildcard for "Florida"? =Sumproduct((Sheet1!B:B="Florida"),Sheet1!A:A) Ideally, I like the formula to do this: ...
0
votes
1answer
123 views

Import a CSV file to Google Spreadsheets

I am trying to upload a CSV file and importing it to Google Spreadsheets. The file contains the following: hi,hello\r\nwelcome,to\r\npeaceful,world What I expect in the Google spreadsheet is: ...
0
votes
1answer
491 views

Is there any way to use a formula in a Google Sheets filter view?

I have a sheet with a column of numbers. I'd like to create a filter view that only shows rows with a value greater than 500, but I can't find any way to do that. There are lots of different numbers, ...
0
votes
1answer
168 views

Return value in column A in preceding cells in column B using an Array Formula

I've been looking for a solution to this for days now. How do you fill cells in column B (using an array formula) that are preceding the cell in column A with the value of column A only when cell in ...
0
votes
1answer
32 views

Counting specific words

I want to count how many times in a column certain words from a predefined set appear. In this example those specific words will be days of the week. For example: Mon =3 Tues ...
0
votes
1answer
80 views

Script that adds new row to multiple sheets in Google Spreadsheets

I want to add a script in Google Spreadsheets that adds new row on the second line of every sheet within a Google Spreadsheet that contains multiple spreadsheets. This will need to happen every day.
0
votes
1answer
79 views

Format day of the week

In Google Docs, what would a script look like that would identify days of the week (i.e., monday, wednesday, friday) and then change the background color of the corresponding cells?
0
votes
1answer
69 views

How do I accomplish a vlookup if my key range is discontinuous?

So, I've got a chart (an EXP chart for an RPG) with several break points in it. One column is how many EXP is required to get to a level, the other column is what level you get to be given that EXP ...
0
votes
1answer
96 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
1answer
111 views

Google Docs Spreadsheet and Zapier

My client has a Wordpress site that uses Gravity forms. I'm using Zapier so that each time a new submission is entered into the form, it adds this information to as a new row in a Google Spreadsheet ...
0
votes
1answer
204 views

How do you refresh a filter view in Google Sheets?

Right now it seems like the easiest way to refresh a filter view in google sheets is to remove the filter view and then apply it again. What is the fastest way to refresh a filter view in Google ...
0
votes
2answers
35 views

Add cell from multiple spreadsheets in Google Spreadsheets

I have a Google spreadsheet that contains 30 sheets (each day for the month of September). I want to add cell K36 from each sheet, but I don’t know how. How can I do this?
0
votes
1answer
56 views

How do I sort several columns by a list of values?

In Google Sheets, I have several columns: Industry | Company | Country | Date Last Visited And I want to order them by Country, then by Date Last Visited, then by Industry, then by Company so that ...
0
votes
1answer
121 views

Using VLOOKUP with dynamic range array

I have a sheet with a list of email address that is being auto-updated (more email addresses being added on a daily basis). I have a second sheet with a list of email addresses that have been ...
0
votes
1answer
2k 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
2answers
81 views

Conditional Formatting for Google Spreadsheets

I have created a Google spreadsheet. It has actual values and calculated values. I want the background to be green if the calculated value is less than the actual value and red if it is more. ...
0
votes
1answer
108 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
70 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
1answer
44 views

How to match info between tabs in a Google spreadsheet

How can I take info from one tab and add it to another? For example, I have Tab 1 with column A—call it “cat breeds”—and I have Tab 2 with column A—call it “cat breeds”—as well. They need to match so ...
0
votes
2answers
127 views

Google spreadsheets - How to calculate a value based on the row/col number of another cell value

I am trying to build a spreadsheet that one sheet holds a list of names divided into groups. The second sheet, should list all the names, sorted, with a number next to each name according to a ...
0
votes
1answer
85 views

Query to copy from Sheet A to B based on true/false

I'm trying to copy data from Sheet A to Sheet B based on if one of the columns has True or False. I'm trying to use: =QUERY( 'A'!A1:I200 , "select * where I = 'True'" ) but this only gives me ...
0
votes
1answer
56 views

How do I merge columns but preserve data Google spreadsheets [closed]

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
1answer
1k views

Where are the conditional formatting custom formulas?

I would like to use custom formulas in the conditional formatting panel on Google Spreadsheets, such as indicated in that link: https://support.google.com/drive/answer/78413#formulas The problem is ...
0
votes
1answer
225 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
1answer
85 views

How can I copy all the data from certain colored cells in a Google Spreadsheet to a single cell? [duplicate]

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
250 views

Google Spreadsheet Formula: Check cell value then subtract based on outcome

I have two columns - they look like the following: YESNO | AMOUNT ________________ N | 13 N | 22 Y | 13 The AMOUNT column is a value output from a condition, ...