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
1
vote
2answers
108 views

Filtering Forms feedback

Does anyone know how to filter respondent feedback into different sheets on the spreadsheet? For example, each sheet collects information for separate classes and I want the form information to be ...
6
votes
2answers
11k views

How to sumif with multiple criteria

My sheet looks like this: 1|A | B 2|amount | source 3|173.00 | bank1 4|173.00 | cc 5|173.00 | cash 6|173.00 | bank2 7|173.00 | cc 8|SUM This is simplified but what I want to do is Sumif A3:A7 ...
1
vote
1answer
2k views

Stop lines in GDocs chart overlapping/obscuring other lines

How can I stop lines in GDocs chart overlapping/obscuring other lines? See for example the green line in the graph below, which starts up high, butthen goes behind other lines such as the yellow one.
3
votes
1answer
341 views

Google Spreadsheets Calculation/Reinput Automation?

I have a little basketball stats sheet, and a cell that has a total of a specific player's statistic they have accumulated throughout the season. But there is no way I know of to update this cell ...
3
votes
1answer
164 views

Published Google Docs spreadsheet: one data set with 3 sheets each sorted differently

Is it possible on a published Google Docs spreadsheet to have 3 individual sheets, each sorted differently from the common data, and only update the common data?
3
votes
2answers
2k views

Table of Contents in Google Sheets

I'm curious to know if there's a way to create a Table of Contents within a Google Sheets. I would like to be able to set the active cell in the spreadsheet based on what cell (or contents of the cell ...
2
votes
2answers
328 views

Javascript string() function in Google AdWords

Is there a simple way to implement the Javascript string() function in the basic Google AdWords interface? I want to pass some variables returned from a campaign management script to a spreadsheet (...
0
votes
1answer
2k views

How can I prepare a sparkline graph (line/bar)?

How can I prepare a SPARKLINE graph (line/bar) in a Google Sheets? With the Google Drive help it doesn't work for me. Reference: Google Drive Help.
1
vote
2answers
6k views

How to use LEFT function in COUNTIF

I have a column that sometimes has B and sometimes B - somecomment. I want to count all instances of B. I expected it to be something like =COUNTIF(B14:B943, LEFT(B14:B943,1) = "B") But no dice. ...
8
votes
3answers
18k views

How do I mix formats in one cell?

I've got a string like ="Daily Avg: " &AVERAGE(C3:C13) I'd like to be able to apply number formats within my cell's formula. Is this possible without custom scripts? I've searched Google's ...
39
votes
6answers
172k views

Google Spreadsheets automatically removes leading zeroes

I have a column comprised exclusively of numbers. Whenever I add 050, the sheet automatically changes it to 50. I have tried prepending a space, but it makes no difference. What can I do to avoid ...
12
votes
6answers
29k views

Summing up spreadsheet data when a column contains “#N/A”

I am using Goggle Spreadsheet to work up some historical stock data and I use a Google function (=googlefinance=…) to import the historical closing prices for a stock, then I work with that data ...
2
votes
1answer
916 views

Pre-populate Google Docs form field with incremental value

I have a Google Docs spreadsheet that I use to track my jobs by job number. Is it possible to have the "job number" field pre-populated with the next job number? Currently I have to open the ...
2
votes
2answers
2k views

How do I restrict input when the number of entries for a condition is met?

I am using a Google spreadsheet to gather the Registration form entries for our tournament. We can only have ten teams per age group. How do I "close" the Registration when the number of entries for ...
-1
votes
1answer
1k views

IMPORTXML is not working properly [closed]

In my Google Spreadsheets I tried to pull out the data from booking.com. I retrieved Hotel name in column but does not work with every column. I referenced the formula correctly but it automatically ...
6
votes
3answers
1k views

Sorting data in Google Spreadsheet by cell entry

I have a Google Spreadsheet that lists various events. Students have entered their name next to events that they would like to sign up for. It looks like this: Each student may sign up for more than ...
5
votes
4answers
5k views

Google Spreadsheets equivalent of Excel CLEAN() formula

I've created an Excel file where a non-technical co-worker of mine organizes a bunch of data into rows and columns. I then have formulas concatenate across those rows and columns and add some HTML ...
2
votes
2answers
19k views

Can I sum based on a specific cell text value?

I have a spreadsheet for tracking sales leads. Each row is a lead. One of the columns is called "Status" and the options under this column are limited to a list of 4 options, i.e. Prospect, Proposal, ...
1
vote
1answer
5k views

How do you add a date created to Google Forms / Google Spreadsheets

We have a Google Spreadsheet It has a few columns Issue Raised By Date Raised We've turned this into a Google Forms which we want anyone in the business to be able to answer. The problem is that ...
11
votes
4answers
10k views

Is there a way to insert a bookmark into a Google Spreadsheet?

I know you can do this with a Google Doc, but how about a Google Spreadsheet? I'd like to have a bookmark and then link into that cell of the spreadsheet from an HTML document.
10
votes
4answers
8k views

Is it possible to use named ranges in Google spreadsheet queries so that the columns references are kept up to date?

Using Google Spreadsheets, you can write queries. However, if you have column letters in quotes, then they aren't updated as column order changes. Is there a way to write these queries so they don't ...
-1
votes
1answer
12k views

How to link two spreadsheet of Google Docs [duplicate]

Possible Duplicate: Can we do a link between two Google Docs spreadsheets? I'm trying to link two Google spreadsheets. I don't want to merge I would like to have a spreadsheet with the data of ...
2
votes
1answer
563 views

Text conditionals in Google Spreadsheets

I want to write a formula where I can add values to a cell whether another cell states approves the "transaction". It will be easier to explain with an example. Consider a spreadsheet containing the ...
5
votes
1answer
21k views

Auto create and name new sheet in Google Spreadsheet

How can I automatically create and name new sheets in a google spreadsheet from a list of names, such as a student roll sheet? I would like each new sheet to be created when I add corresponding names ...
4
votes
1answer
1k 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 ("...
7
votes
2answers
8k views

How can I dynamically format the diagonal cells in Google Spreadsheet?

I want all of the diagonal cells (A1, B2, C3, D4, E5, etc) of a Sheet to be formatted as Black Background, White Foreground. Is there any way to do this for a Sheet that constantly increases in size? ...
20
votes
5answers
97k views

Is it possible to refer to a whole column in Google Spreadsheets using R1C1 format?

In Google Spreadsheets I often use A1 notation to refer to a whole column: A1:A For reasons I explain below, I'd like to use R1C1 format, to refer to a whole column, something like: R1C1:C1 It's ...
31
votes
6answers
125k views

How can I automatically set “last updated” cell in row Google Docs Spreadsheets?

How can I automatically set "last updated" cell in row Google Docs Spreadsheets ? I want to create a column where the cells' value will be automatically set to when that row was last amended. Is this ...
0
votes
1answer
5k 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
2answers
906 views

Store form data to Google Docs

I have a webpage where i am having a textbox preferbaly for storing email address. I need to create an email intake database where i need a simple database built to store emails of users “signing up”...
29
votes
3answers
92k views

How can I copy cell values rather than references from one sheet to another in Google Sheets

How can I copy cell values rather than references from one sheet to another? Right now using Filter, Query and ArrayFormula creates references which create empty cells and disallow sorting of the ...
53
votes
13answers
144k views

How to set a Google Docs Spreadsheet cell format to bare text?

I am to store international standard phone numbers (starting with a plus sign followed, usually, by plain numbers) in a Google spreadsheet column. An example of such a phone is +420123456789 When I ...
3
votes
1answer
4k views

Is it possible to use Google Spreadsheets to post to a web service?

I was wondering, as a thought experiment, if it were possible to use Google Spreadsheets to post to a web service. For example imagine you created a spreadsheet for guests attending a party with ...
1
vote
3answers
17k views

Google Docs Spreadsheet ImportHtml() with Basic Auth

Within a Google Docs spreadsheet, I need to access external data that requires basic authentication. Usually I would include external data by putting this in a cell: =ImportHtml("http://somedomain....
2
votes
1answer
11k views

Updating data validation for a group of cells

I have a spreadsheet where a particular group of cells has defined drop down values to choose from, using data validation rules to get the list from a seperate sheet. How do I update all of the cells ...
3
votes
1answer
5k views

What is the “web clipboard” in Google Spreadsheets?

I made a chart in Google Spreadsheets and then clicked on Copy Chart. A little popup notified me that the chart was copied to the web clipboard. However, when I try to paste the chart anywhere in the ...
0
votes
1answer
228 views

How can I have column E copy its data into the right column based on the initials in column M?

I have a spreadsheet that will auto time stamp column N when my technicians enter their initials into column M. The second thing I would like the spreadsheet to do is, when I enter the hours (example: ...
9
votes
5answers
43k views

Prevent the cell from expanding to the size of cell contents in a Google Docs spreadhseet

How can Google Docs Spreadsheet be prevented from expanding to the size of the cell contents? Example: The cell expands vertically to fit the cell contents: The cell expands horizontally to fit the ...
-1
votes
3answers
3k views

Merging Data in Google Sheets [closed]

I have a survey created in Google Docs used in several classes. Each class has its data in a separate Google spreadsheet. Now I want to collate all the data into a single spreadsheet. If I simply copy ...
5
votes
1answer
38k views

Google Spreadsheet Timestamp? [duplicate]

I'm looking for some help with my Daily Work Log spreadsheet. I've search and read many different version of making a "TimeStamp" in Google spreadsheet. And it seems I don't have enough experience for ...
1
vote
2answers
5k views

Escape parentheses around a number in Google Sheets?

How do you escape parentheses around numbers in Google Sheets so that they don't default to displaying as negative numbers?
4
votes
2answers
748 views

Google Spreadsheets Conditional Formatting with color

I want to add a column of cells together only if the particular cell is colored green. Can I do this using conditional formatting on a google spreadsheet?
3
votes
1answer
1k views

Why is “access denied” to multisheet charts in published Google Sheets?

I can successfully include a chart based on a single sheet, but as soon as I combine ranges from multiple sheets, I get an access denied error. Example spreadsheet Published spreadsheet What am I ...
5
votes
0answers
534 views

Preserve formatting when referencing cells across sheets [duplicate]

Is there a way to show the formatting of the referenced cells from another sheet in Google Sheets? For example I have a sheet named balance with A1 having a comment and a blue background. When I ...
0
votes
1answer
158 views

How to copy data from cell below?

Envision two rows, one up top and one below it. The cell up top is blank but the one below has 9/24/12. How can I create a function that will make the top one copy the value of the cell below it if ...
1
vote
0answers
160 views

How to insert empty row in Google Spreadsheets when two rows are not duplicate?

I have a number of rows in a Google spreadsheet. I want to insert an empty row only when two sequential rows are not duplicate. How can I do this?
4
votes
1answer
8k views

Multiple Conditions on a CountIF?

I have a spreadsheet that is essentially a todo list for different groups. I have a column for Group and Status. Both have data validation drop downs so I can reliably match the text content. I have ...
0
votes
1answer
141 views

I need a formula that returns how many times a unique value appears in a given date

In a spreadsheet in Google Spreadsheets, I’m trying to solve this: 17/02/2012 banana 17/02/2012 banana 17/02/2012 banana 17/02/2012 apple 18/02/2012 apple 18/02/2012 apple I need a formula ...
31
votes
2answers
48k views

Generating Google Spreadsheet hyperlinks from cell contents

I have a column of cells in a Google Spreadsheet with values such as: 37683 36583 38637 32391 What I would like to do is generate a hyperlink for each cell like: http://mywebsite.com?id=xxxxx ......
2
votes
2answers
1k views

How can I set conditional formatting on particular cells that depend on another cell's value in Google Spreadsheets?

I would like to colour the background of a row in Google Spreadsheets: For example: If cell Dx = title 'To do' or 'title 'Done' then cells Fx to Nx are filled colour black. If cell Dx = title '...

1
132 133
134
135 136
140