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

learn more… | top users | synonyms (1)

0
votes
1answer
55 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
41 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
59 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
70 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
89 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
120 views

Show all hidden rows and columns when I open a Google Spreadsheet

I want to un-hide all the hidden rows and columns when I open the spreadsheet. How can I do that for all sheets?
0
votes
1answer
201 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
139 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
28 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
57 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
50 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
54 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
93 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
153 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
36 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
82 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
2answers
76 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
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
1answer
118 views

Publish single google spreadsheet to the web

I have many sheets in one spreadsheet, how do I publish single spreadsheet to the web? When I attempt to publish, it doesn't show any option to pick the sheets I want to publish.
0
votes
2answers
105 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
75 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
54 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
163 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
80 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
215 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, ...
0
votes
1answer
61 views

A function opposed to SUMIF?

I have a huge list of matches between clubs and I want to calculate the goals for and the goals against. I could find a way to calculate the goals for, using: =SUMIF (A35:A46, "Liverpool", B35:B46) ...
0
votes
1answer
33 views

Compare two rows of a sheet to another and show characteristics

I'll try to be clear although english is not my first language. I have a first spreadsheet (let's name it PRODUCTS) containing, in different columns, characteristics of different products ...
0
votes
1answer
52 views

Google spreadsheet, sort adds a bunch of rows

I have a function that sorts a table, unfortunately when I call my function it adds a bunch of empty rows at the bottom that I don't like. var kotlijst = SpreadsheetApp.getActiveSpreadsheet() ...
0
votes
2answers
918 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 ...
0
votes
1answer
103 views

How to merge multiple rows in Google Docs?

I've got a Google Sheet with columns along the lines of: URL | Pageviews | Time on Page The same URL is sometimes on multiple rows and I'd like to merge the two other columns together so that the ...
0
votes
1answer
166 views

How do I split multiple rows / insert a row below every existing row, in any spreadsheet program?

I use a spreadsheet to keep track of journeys in a lift-club. Each day has its own row, and the number of lifts given to a person will be 0, 1 or 2. I realized that the algorithm for the lift scheme ...
0
votes
1answer
91 views

google spreadsheet filter, string equivalent

Columns D, E, and F store names that represent 2-3 person teams assigned to the name in column A. The teams are assigned to multiple names and thus appear in multiple rows. The teams' composition ...
0
votes
1answer
144 views

Creating a document (e.g,, MS Word) attachment in Gmail from a spreadsheet script

I've created a document file in the spreadsheet script. What I want to do is, from the script, create an email message with the document file (NOT a PDF) as a Gmail attachment. I spent about 2 days ...
0
votes
1answer
791 views

How to apply formulas, validation to newly added row (using add more rows at the bottom not using insert)?

I have formulas and validation in columns D, E, L, M and N. I want these formulas and validation to be automatic whenever I add rows using the option "Add more rows at the bottom". Not using insert ...
0
votes
1answer
583 views

How can I record the date/time when a new row is added?

I want to add a date value when a new row is added in Google spreadsheet. I have seen the script on Add a 'creation date' value when a new line is edited, but I was not able to modify the code to my ...
0
votes
1answer
27 views

IF Formula where X = an unidentified (but stable) #

I really think this should be simple - but I am stumped. Please see image. All I want is that my clients be able to put an "x" in the tasks they want performed. Each has an associated cost, which I ...
0
votes
1answer
297 views

List of Dates of Current & Previous Month in Google Spreadsheets

I want to have the dates of the current month and the previous month automatically get populated. So I'm using =MONTH(NOW()) to get the current month and =MONTH(NOW())-1 to get the previous month. ...
0
votes
1answer
64 views

Can't figure out SUM formula

This is the formula I am trying to do: =SUM(D9:D14)*2.55, (D16:D23)*3.90, (D25:D32)*6.40, (D34:D41)*10.60, (D43:D46)*10.50, (D48:D51)*6, (D53:D59)*3, ...
0
votes
3answers
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
144 views

Making a header row in a Google spreadsheet

Is there a way to put text in a row at the top of a spreadsheet, like a header? So it is separate and fixed from the columns below it? In other words, I want a header row at the top and the columns ...
0
votes
1answer
51 views

How to restrict the number of entries for a particular column in shared spreadsheet using Google Drive

I want to create a spreadsheed using Google Drive in which some columns entries should be retricted based on given value. E.g.: I have some columns named users, item1, item2. In columns item1 & ...
0
votes
1answer
161 views

Help with a conditional formatting script in Google Spreadsheets

I'm having the following problem: If text values are similar in Column B then gather $$ values found in Column M and display the mean of those fields in Column N.
0
votes
2answers
394 views

How do I link two Google Doc spreadsheets so that entering a numerical value in one cell of Sheet 1 produces an 'x' in the same cell of Sheet 2?

I know about the importRange function to link two sheets, but I wonder if there's a way so that when a cell's contents are imported to the second sheet, the second sheet will autopopulate the ...
0
votes
1answer
74 views

How do I reference a second sheet column across a row of numbers in sheet 1

I'm trying to look-up a value in sheet 2 from a number on a row in sheet one: it looks like this: Sheet 1: Row4 Number of units 0 5 25 10 15 And sheet 2: column a column b 1 2 3 ...
0
votes
1answer
361 views

How to GROUP and ORDER data in a Google Spreadsheets?

I want to group and sort a particular data set. I've prepared the data using a QUERY function and using other functions. Can I order by sum? This is an example file I created: order by sum
0
votes
1answer
132 views

How do I select a range programatically in Google Spreadsheets?

I have a spreadsheet like this: active date name 1 1-Jun-2013 Paul 1 4-Jun-2013 Sheela 1 8-Jun-2013 Paul 1 2-Jul-2013 Henrik 3-Jul-2013 Henrik ...
0
votes
1answer
76 views

Copying data, based on the value in a cell

I've been trying to work out how to copy data from cells on a worksheet into another based upon the value in a cell. We have weekly data so for arguments sake Week 1 Week 2 Week 3 Week 4 ...
0
votes
2answers
45 views

Google Spreedsheets Maths Date [closed]

In column A, I have today's date 18/06/2013 and I want to add 25 days to it, but because I have a list of 100 dates (all different) I need to do the same thing that =DATE(2013,06,18)+25 would do but ...