People who code: we want your input. Take the Survey

Questions tagged [google-sheets]

For questions about Google's web application to create and edit spreadsheets on a web browser or app. Don't use it for the Google Drive Excel files editor. Please consider adding a demo spreadsheet to your question; this will greatly increase the chance that you get a satisfactory answer.

Filter by
Sorted by
Tagged with
6
votes
2answers
19k views

Keep a variable while copy/paste cell [duplicate]

Possible Duplicate: 'Lock' part of formula when copying from one cell to another I am using in one of my spreadsheets a formula referencing the column title (matching how many times it is ...
3
votes
3answers
2k views

Can I avoid references to cells in other sheets from breaking if I remove/add a row?

I have a Spreadsheets that has two sheets. One takes entries and a second manipulates content from the first and displays results. If I remove or add a row, the references in sheet two change, ...
20
votes
1answer
125k views

Create a column of date in Google Spreadsheets [duplicate]

Possible Duplicate: How to extend series of dates in Google Docs? In Excel, when you enter a date and hold right click button + shift and move the mouse, it will create dates. Is there a way to ...
1
vote
1answer
2k views

Embed only cells from Google Spreadsheet and not application header

When I embed a Google spreadsheet, I get cells in my page (and this is good). But I get also the application header with toolbars (and this is bad for me). See a test here: http://www.lucagiorcelli.it/...
4
votes
1answer
3k views

Qualtrics + Google Spreadsheet integration

I'm looking for a way to use a Qualtrics survey as a data source for a Google spreadsheet. My client wants a google spreadsheet that automatically updates based on the latest survey results. I've ...
4
votes
2answers
2k views

Partial sum of columns based on row identifier

I have a spreadsheet with list of persons ("players"), and for a each person I have following values: ID number (unique) Name (just text) Score from round 1 Score from round 2 ... Score from round 16 ...
6
votes
3answers
9k views

How do I sum different currencies in Google Spreadsheets

I have a spreadsheet where some columns are formatted in EUR, and some in USD. I would like to be able to sum them by taking into consideration the exchange rate. Example: A1 = $10, A2 = €10 A3 = A1 ...
5
votes
5answers
12k views

Paste numbers as string

I have one spreadsheet in Google Sheets with data like: 0012 0234 0065 I want to paste this in another Google Sheets but when I use ctrl+c ctrl+v the data is formatted like numbers: 12 234 65 I ...
10
votes
7answers
12k views

Keyboard shortcut to open a drop-down list for cell values in Google Docs spreadsheets

I'm working in a Google Docs spreadsheet where I've set up validation lists for a column. When I tab into that column as I'm editing a row, the drop-down handle appears: In order to access values ...
6
votes
3answers
50k views

Google Spreadsheet column limit

I'm working on a Google Spreadsheet and I keep getting this message: This spreadsheet is about to reach the following limits: Number of Columns Google Docs Help says that the columns limit is of ...
2
votes
4answers
5k views

Protect entire column of a Google Docs spreadsheet

I select a column (e.g. Sheet1!A:A) to be protected, then in the right pane I edit the settings (name, permissions), and finally I click Done What happens: The protected range then switches to Sheet1!...
13
votes
2answers
33k views

Format cells as plain text [duplicate]

I'm gathering some data in a Google Spreadsheet, there's a column for phone numbers and when trying to enter a phone number (e.g., +54 11 4785 7992) the spreadsheet automatically tries to make a ...
21
votes
2answers
39k views

Repeat last action in Google Spreadsheets

I want to know if there is a shortcut in Google Docs Spreadsheets for repeating the last action, like F4 in MS Office. I found that there was no shortcut for this on Google Forums but the post were ...
3
votes
1answer
1k 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, ...
2
votes
1answer
2k views

How to search an embedded Google Spreadsheet in Google Sites?

I would like to know how I can make embedded spreadsheets searchable in Google Sites.
2
votes
2answers
2k views

Avoiding duplicates when adding cells in column one by one

How can I have a kind warning if I am adding a text to the cell which was already added somewhere in previous cells of the same column?
-1
votes
1answer
2k views

Google spreadsheet validation data empty cell

So I'm struggling with the following: I have this formula (I know it's huge but it works so far) =IF(AND(COUNTIF(basictier1;"*"&A4&"*"));"T1 Basic"; IF (AND(COUNTIF(basictier2;"*"&A4&...
4
votes
1answer
10k views

Cell row reference coming from another cell [duplicate]

I need to make Google Sheets evoke the row number for a cell reference by pointing to another cell. I have a form with different cells that point to another sheet (Sheet1!). All the cells always point ...
3
votes
4answers
10k views

Insert copied cells in Google Spreadsheets

I'd like to shift a set of cells downward from a selection in Google Spreadsheets. Ideally "insert copied cells" from Excel, but I can live with just the shift part, i.e. insert blank cells, shifting ...
3
votes
3answers
8k views

Parsing timestamp in Google Sheets with script

I have a spreadsheet with a form that timestamps every time the form is submitted. I'm writing a script to change the background color of the timestamped cell if it is more than seven minutes after a ...
0
votes
2answers
593 views

How can I link to a cell in Google Spreadsheets?

I have a headings and every time I have to scroll down to the cell I need. Can I create some kind of "header" on the top of the page and just click on the header I want and it will automatically ...
4
votes
2answers
3k views

Is it possible to share a Google Sheets between computers with no internet?

I need to create a Google Sheets and share it with a set of computers connected to each other via a local network. Those computers are not connected to the internet. I need a solution in which all ...
8
votes
2answers
17k views

SUMIF date range and filter by value on Google Spreadsheet

How do I SUMIF two date ranges and filter with a value? The date range formula I've been using is: =sumif($A:$A,"<="&D$5,$C:$C)-sumif($A:$A,"<"&D$4,$C:$C) Which works great for ...
3
votes
1answer
5k views

How to select weekdays only in a Google Sheets?

I have a table with two columns: column A has dates, column B has data. I want to compute the average of the data in B that corresponds to only week (work) days. How can I write it as a formula?
9
votes
1answer
26k views

How do I make a cell highlighted if the date in the cell is today? [duplicate]

Possible Duplicate: Advanced date logic in Google Spreadsheets I have a spreadsheet with many consecutive days. So Cell1 = 7/30/2012, Cell2 = 7/31/2012 etc. I want Cell1 to be highlighted if ...
2
votes
1answer
7k views

Transfer cell value to another cell by clicking on a button in Google Spreadsheet

I want a user to be able to click on a button and have the value of one cell go into another cell. How can I do this?
3
votes
1answer
8k views

How to Send Html Emails in Google Spreadsheet

Here's an example of a Google Docs Spreadsheet script that sends emails using Google spreadsheets. I want the email Sent in HTML not plain text. Can someone help me out? function sendEmails() { var ...
10
votes
2answers
58k views

How to Refresh a cell in Google Spreadsheet?

I have a column in Google Spreadsheet that calls an outside webservice using URLFetch in a Google Script. The cell uses two parameters in that cell's row. After a change occurs where those two ...
2
votes
1answer
2k views

Daily calculation and record insertion in Google Spreadsheet

I have a Google Spreadsheet that I am using to checkout last prices or levels of certain stock indices's. I have two worksheets in the workbook, one contains the indices's and a calculation I am ...
1
vote
2answers
1k 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 ...
3
votes
3answers
3k 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" ...
2
votes
1answer
6k views

How can I comment several dozen cells using data from cells?

I want to turn some long-winded strings into comments on nine sets of 96 cells so they're just visible on mouse-over. How can I do this without manually going to Insert Comment and copy-pasting 864 ...
2
votes
3answers
2k views

A formula that does Excel “countifs” function involving dates

I have a Google spreadsheet in which multiple users are tracking a list of dates and class names (math, reading, writing, etc). On a separate sheet in the same document, I want to be able to give a ...
37
votes
4answers
75k views

Add 3 hours to Date value (DD/MM/YYYY 00:00:00)

I have cells with dates in this format: DD/MM/YYYY 00:00:00 and I want to add 3 hours because I'm in a different GMT zone. Is possible to use dates in a formula? Something like: 30/12/2012 22:15:00 ...
1
vote
1answer
2k views

Make new responses appear as a row at the top of a Google Spreadsheet

I made a web form based off of a Google spreadsheet. New responses currently manifest as new rows on the bottom of the spreadsheet. There is a "Timestamp" column marking the time of submission. How ...
1
vote
1answer
2k views

Nested IF statement on Google Spreadsheet, second part same as the first

I have a spreadsheet for my budget. Payments are either drawn from my bank or my Amex card and then my Amex card is drawn from my bank as well. So I add up all my monthly total like this: =sumif(I3:...
13
votes
3answers
26k views

How can I alphabetize a unique result in Google Spreadsheets?

I'm generating a list based on using the UNIQUE function. How can I get the output to be alphabetized automatically?
7
votes
2answers
37k views

How easily to select multiple cells in Google Sheets?

How do I select multiple cells in Google Sheets (non related cells, other cells between them)? In MS Excel I just press Ctrl and click on all the cells, in Google Sheets it doesn't work. Is it ...
2
votes
1answer
2k views

Want to email specific spreadsheet row data on event

Scenario Basic support ticket clone: Users submit a form (e.g. answering fault reporting questions) Data is obviously stored as rows in the corresponding spreadsheet I've added an onEvent trigger to ...
6
votes
10answers
29k views

Importing data into a Google Forms response sheet

I have some Google Forms and would like to import legacy survey data into the responses spreadsheet, so as to benefit from the data presentation features (having the combined data set) but I've been ...
6
votes
1answer
13k views

Add average line to scatter graph

I have the following scatter plot in Google Sheets and I would like to add a line that averages all my points. Can I do that and if yes, how?
43
votes
7answers
67k views

Alternating colors for lines in Google docs spreadsheet

I have a shared Google spreadsheet where several users have already filled out parts. It would be useful to have alternately colored lines to facilitate correct placement of additional data. Is ...
6
votes
1answer
30k views

How can I highlight selected text in a cell and not the whole cell? [duplicate]

In my Google Spreadsheet, I have a lot of text in a cell and want to highlight a small portion of this text with a particular colour. But, whenever I try to do this, the formatting gets applied to ...
1
vote
2answers
3k 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 ...
34
votes
2answers
135k views

'Lock' part of formula when copying from one cell to another

I have the following formula in a Google Spreadsheet: =IF(I11="VSS";G11;IF(I11="MCS";0;G11*Totais!C30)) I would like to freeze Totais!C30 when I click on bottom right of cell and drag down. ...
3
votes
2answers
3k views

Can we link two Google Sheets?

I want to make a link between two spreadsheets, like if I click on a code in a cell, it opens the spreadsheet which the code refers/links to.
0
votes
2answers
4k 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 I'...
7
votes
2answers
3k views

Let users only change their own data in Google Spreadsheets

I have a Google Spreadsheet in Google Drive. Users can change everything and anything in the spreadsheet. Now, I want them to be able to change empty fields or their own fields only. Is this ...
14
votes
8answers
51k views

Pasting text with line breaks into Google Sheets populates multiple cells

If I copy text with a line break in it, like this: 1st line 2nd line and then paste in into a Google Sheets cell, then it pastes '2nd line' into the cell below. What are the ways to avoid this?
2
votes
2answers
627 views

Allow users to use my online spreadsheet without saving their edits

I made an online spreadsheet to calculate grades. I want my users to use it without Google Sheets showing it real-time to other users. How do I do this? It seems if I allow people to edit the ...

1
133 134
135
136 137
140