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

learn more… | top users | synonyms (1)

1
vote
1answer
32 views

How can I use a single column as a normalized data point with multiple choices in Google Sheets?

I find I often want to have a column that is meant to be one or more choices from a fixed set. E.g. a Codebase field in a dev roadmap spreadsheet, which might have choices like {DB, API, JS, CSS, ...
1
vote
1answer
420 views

Having an issue with horizontal scrolling in Google Spreadsheets

When I try to scroll horizontally in Google Spreadsheets using the track pad, nothing happens. However, if I scroll vertically first, I can then scroll horizontally if I don't pick up my fingers from ...
2
votes
1answer
2k views

Google Spreadsheets Data Validation - Unique Values

I have a google sheets document which contains two sets of data in separate worksheets: Public IP addresses Private IP addresses In my private IPs worksheet I want to create a dropdown which ...
2
votes
2answers
155 views

Split text with Google spreadsheets

I have a Google spreadsheet with 1,500 cells containing items like: 1,300 users 2236 users, 12 companies 15000 users,153 companies <46,000 users, <200 companies I need to split this ...
2
votes
1answer
52 views

Display Columns For this weeks Data

I'm trying to create a to do list schedule like spreadsheet that would show only the data presented for the current week. I've been having some difficulty figuring out how to display the data of ...
3
votes
0answers
33 views

How to calculate geographic area in Google Sheets?

I have three columns of cells with geographic coordinates. For example: 40.614362,-73.974187 | 40.618654,-73.989636 | 40.629675,-73.979092 I want to calculate an area between these coordinates to ...
1
vote
1answer
11 views

Adding particular data to particular sheets within one document

I am a bit new at this and am having a tough time getting this to work... I have multiple sheets, one main one (Submissions) which receives data from a form, then I have the sheets: Level 1, Level 2, ...
7
votes
5answers
5k views

Shortcut to insert new row in Google Spreadsheets?

Is there a way to do this without using the menu? I have seen references to ctrl + space and ctrl + +, but this no longer works (zooms in and out in Google Chrome)
1
vote
0answers
7 views

How to directly view a Google Visualization API Query URL as a human-readable table or web page?

What is the correct syntax for the URL (see also a related question about documentation) to view a Google Visualization API Query result as a web page containing the tabulated results of the query? ...
1
vote
1answer
49 views

Button in column C in each row

I have a spreadsheet with three columns and lots of rows. Column A has a numerical ID Column B is empty Column C is empty I want to have a button in each row in column C. When pressed, it should ...
1
vote
1answer
107 views

Sorting by the value of the formula in a Google spreadsheet

I want to sort data by the value of the formula. The data is generated by a formula. I want to sort the data (and related rows) by the value of the formula output not the formula. I cannot do this. ...
1
vote
2answers
232 views

How can I make a Google spreadsheet Function reference one column's value and adjust it to a different Value?

I am trying to create a spreadsheet that will calculate varying sizes. I need it to reference a key where a letter is an established size such as H=1984, S=672, etc. so as that that column can be ...
2
votes
1answer
896 views

Is it possible to add conditional formatting when number changes?

This is probably not possible but... I'm looking to update cells in a Google spreadsheet using the conditional formatting tool.(Changes to SERPs rankings) So when the number in a cell is changed, ...
3
votes
1answer
447 views

Single Response Spreadsheet (with multiple sheets) from multiple forms

I have four surveys (google forms) from which I want responses to go to a single response spreadsheet (each on a different sheet). It appears in the form view that I can select to have the response ...
-1
votes
1answer
16 views

How to add some text value in cell in Sheet Google Drive

Everyone!! I am newbie in Google Drive Sheet . Actually i want to know how can i select some column with values and add in every selected cell some text, i.e . Is possible to perform via regex or ...
2
votes
2answers
34 views

Suming functions by relations between sheets (Google Sheets)

Table for counting items: ID COUNT 1 10 2 0 3 12 4 1 5 5 6 10 7 9 8 9 9 11 10 0 Table-pedia with info about items: ID NAME FEAT1 FEAT2 1 Nanan R 20 2 Meowth S ...
4
votes
2answers
4k views

Remove empty rows in Google Spreadsheets

Is there a way to in Google Spreadsheets to remove / delete empty rows? Ideally I'd like to be able to select the columns to check.. ie. Select columns D, E and remove all the empty rows from them or ...
3
votes
1answer
27 views

How do I print comments of a Google Spreadsheet?

Can I print the comments of a Google Drive spreadsheet? And if yes, how? I should mention that the print should not be on the same page.
2
votes
1answer
299 views

Grouping columns in Google spreadsheets (and summarize them)

Lets say I have a table like this: A | B | C 1 | 4 | 3 Is it possible to group these columns together so that I can expand and collapse them with a specific formula. For example with SUM I would ...
3
votes
1answer
492 views

Looping through the range of cells to test the dates

I am trying to create a function to check the dates in 'Dt' sheet and return Match or Not Match. It works fine with when I display my answer in MsgBox, but when I try to do it in one of the ...
0
votes
1answer
27 views

How Do You Replace a Formula With Its Result?

I've been searching and searching but haven't found what I think is the right answer. I'm not an advanced user of excel. At best, somewhere between beginner and advanced. I created a Google ...
0
votes
0answers
38 views

How do I sum cells according to cell or font color?

I would like to sum cells based on either the color of the cell or the color of the text contained therein. I guess there was a way to do this before the update, but it doesn't seem to work anymore. ...
1
vote
3answers
133 views

Google Spreadsheets: how to show the 10 most recent rows from another sheet's timestamp?

In one sheet A I have an ongoing number of rows where the 1st column is a timestamp in ascending order (more recent entries at the bottom). I'd like to have another sheet B where only the 10 most ...
3
votes
1answer
180 views

How to anchor all the cells on the page in Google Spreadsheet

To anchor cells in a Google spreadsheet so that you can drag the values/cells/formula, with one or more of the linked cells/values remaining constant you can follow these steps: ...
2
votes
1answer
475 views

Automatically create a new row each day, on top of older rows

I am looking for a way to automatically create a new row on top of older rows each day. Inside of this row should be the current date.
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
2answers
129 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 ?
1
vote
1answer
7 views

how to clean up table data in Google Sheet IMPORTHTML?

I want to import a table of nuclear power output from https://ru.wikipedia.org/wiki/Атомная_энергетика_по_странам. For some reason, the second col has the number duplicated, eg <td><span ...
0
votes
1answer
168 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 ...
1
vote
1answer
117 views

Get a list of items missing from array in google spreadsheet

I have a spreadsheet where I'm using the trailing set of columns as a kind of foreign key; I'm trying to throw an error if someone enters a value that doesn't exist. I'm thinking one way to do this ...
0
votes
1answer
45 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: ...
2
votes
1answer
38 views

How to make Google Spreadsheet editable only at certain times

I need to create a document (something like a Google Spreadsheet) where multiple users could insert their names in, but within a limited time span. They could edit the document only from Monday (8pm) ...
1
vote
1answer
103 views

Custom Actions in Google Drive Spreadsheet

I find that I often change specific cells from black on white to white on black when I'm making spreadsheets. It get's tedious to change the background color, then the foreground color over and over ...
1
vote
0answers
13 views

Google spreadsheets importrange() error: Loading Data

Is there any reliable alternative to ImportRange() in google spreadsheets? After some time the formula brakes, and shows "Error: Loading data... ", and it wouldn't work until I change anything in the ...
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
2answers
1k views

Create a dropdown list of options from VLOOKUP

What I'd like to do is get a dropdown list of options from a VLOOKUP type function where I can select the value for the next lookup. Example Here the data I'm using for reference. Notice "AAA" ...
0
votes
1answer
53 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 ...
2
votes
1answer
683 views

How to use a named column in a calculation based on a cell value in Google Spreadsheet

Playing with named ranges, I discovered it is possible to name a whole column (say "September") and use it in rows: =September*K4 What I'm trying to achieve now is that the value of the column ...
1
vote
1answer
140 views

onEdit only updates top row after pasting (editing) multiple rows

I'm using a Google Spreadsheet and have a script that updates the "last email" column with a date stamp when an employee enters an email address into the prior column. The problem occurs when my ...
48
votes
2answers
97k views

How can I create a fixed column header in Google Spreadsheet like the first sheet?

How can I create a fixed column header in Google Spreadsheet like the first sheet?
1
vote
1answer
70 views

Referencing a Range Name from a different spreadsheet

I would like to create a spreadsheet that contains name, phone number, address, email address of many individuals and I will define the data as a range name "Index". Then I would like to create a ...
1
vote
1answer
18 views

How can I sort all worksheets in my Google spreadsheet on open?

I have successfully been able to sort the first sheet in my Google Spreadsheet onOpen, but I'd like to sort all four spreadsheets onOpen and I can't make this work. I've tried quite a few variations ...
2
votes
2answers
2k views

Hot keys to switch between tabs?

Does anyone know if there´s a shortcut to switch between tabs in Google Spreadsheets? If you use CTRL+PgUp / CTRL+PgDown like in Excel you switch between Chrome or Firefox's tabs instead.
1
vote
2answers
242 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
1answer
54 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
46 views

Counting occurrences in Google Spreadsheet

I've been brought on last minute to sort out tent allocation for a festival of about 1500 pax. Their ticket sales are a spreadsheet on Google Drive. I have never done this kind of thing before (I'm ...
2
votes
1answer
51 views

How to make SQL JOIN of two tables with Google Spreadsheet?

I am just figuring out how to achieve an apparently simple problem. I use to have data as in database tables in my spreadsheets. It's simple data but I often need to use =QUERY function and would be ...
1
vote
1answer
46 views

How to parse a date and time in the format 2012-12-12T00:00:00+00:00?

I have a CSV file with dates in the following format: 2012-06-20T00:00:00+00:00 Is it possible to parse a date or date and time in this format? The goal is to turn it into a date and time that ...
1
vote
3answers
3k views

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

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 ...
0
votes
1answer
149 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 ...