Last call to make your voice heard! Our 2022 Developer Survey closes in less than a week. Take 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
10 votes
5 answers
11k views

How to indent spreadsheet cells in Google Sheets?

It's a fundamental feature that I need in my financial work but I can't seem to get this working in Google Sheets, or it doesn't support it. I've also looked into Zoho Sheet, but they also don't ...
user avatar
6 votes
1 answer
2k views

How do I reference existing formulas from custom formulas in Google Spreadsheet Scripts?

I want something essentially like this: function contains(arg1, arg2) { return NOT(ISERROR(search(arg1, arg2))); } But NOT and ISERROR are undefined even though using =ISERROR(...) works in the ...
user avatar
5 votes
1 answer
5k views

Is there a way to filter columns in Google Spreadsheets?

Is there a way to filter columns in Google Spreadsheets: Column (A) contains new data Column (B) contains filter data, i.e. cells with text that should not be included in column C Column (C) is the ...
user avatar
  • 63
1 vote
1 answer
1k views

Google Docs Spreadsheet sections

I'm using Google Spreadsheets. I want to be able to have several different sections all on one spreadsheet: an income section with totals there an expense section with totals in it etc. How do I ...
user avatar
46 votes
5 answers
82k views

How can I get GOOGLEFINANCE to return only the historical price of a stock and not an array?

I'm trying to figure out the cost basis of some stock that I sold last year and I can't quite get GOOGLEFINANCE to do what I want. The stock was purchased through a DRIP so there are about five shares ...
user avatar
  • 571
0 votes
1 answer
255 views

Entering local date on Google Sheets

If I use the shortcut CTRL+; the date that is pasted is the server date. I have changed the settings so my Time zone is selected to my local time. Shouldn't my local time get pasted as opposed to the ...
user avatar
2 votes
1 answer
3k views

Batch copying/renaming in Google Docs

I need to copy and rename a base form (a spreadsheet) to several other forms in Google Docs. Imagine I have the following form: My Base Form - @name (@course) After running the script or whatever, I ...
user avatar
4 votes
2 answers
24k views

Hovering image in Google Spreadsheets

I want to write a script which detects the mouse hovering over a cell (or if not possible, triggered by a menu as described in "Google Developers: Apps Script: Custom Menus in Google Apps". This ...
user avatar
5 votes
2 answers
5k views

Google spreadsheet obscure fields with passwords

I would like to create a spreadsheet to manage my domain information in one place. I was thinking of creating rules that made dates red when registration and contracts were expiring and whatnot. I ...
user avatar
  • 151
12 votes
2 answers
21k views

How to reverse text on Google Spreadsheets?

When I enter data in a Google Spreadsheets cell, I would like the text to reverse itself. For instance, I would like to put in a cell My text and get it converted to txet yM.
user avatar
  • 1,265
12 votes
3 answers
49k views

In Google Spreadshets, how can you loop through all available sheets not knowing the total count?

I'm keeping stats for my daughter's baseball team. I have a sheet for each game, each one identical in structure. I want to create a summary sheet that totals numbers from the other sheets. How ...
user avatar
2 votes
3 answers
3k views

Pre-fill a cell with today's date [duplicate]

I would like a certain cell of mine to display today's date when I starts a new row. Is it possible?
user avatar
  • 533
2 votes
1 answer
1k views

How to get data between tabs in Google Spreadsheets

is it possible to get a value from a tab cell and work with it in another tab? Tab 1 (T1) row working hours (A) who (B) 1 3 Mike ------------------------------- Tab 2 (T2) ...
user avatar
  • 161
28 votes
2 answers
95k views

Google Docs date in “dd/MM/yy” format [duplicate]

Is there any way to use date in format dd/MM/yy? The Google Docs support only MM/dd/yy and it cause us problems to use it (we can't sort the date column).
user avatar
2 votes
1 answer
4k views

Validation based on multiple sheets

I have two sheets that each contain a column of data that I would like combined and used as a validation list for a column in another sheet. What would the formula look like for this?
user avatar
3 votes
2 answers
3k views

Auto-Update via RSS (and keep history)

I have a Google Sheets that fetches some data via RSS. The RSS feed is updated once a day, everyday. Is it possible for me to keep archive of all the new and historic data in the spreadsheet? The ...
user avatar
  • 233
3 votes
5 answers
4k views

Is it safe to use Google Apps For Business: Spreadsheets to keep track of passwords?

Google Apps for Business is supposed to be secure enough for corporate data, as described in their FAQ: http://www.google.com/apps/intl/en/business/faq.html They say "We also undergo regular security ...
user avatar
3 votes
1 answer
3k views

Copy data from previous sheet

I have a spreadsheet document where I register tournament results with a sheet for each tournament date. I want to have a cumulative column to show cumulative information. I have already achieved this ...
user avatar
3 votes
1 answer
2k views

How can I create a formula in Google Spreadsheets that uses a date format

How do I subtract days from a cell that has dates? For example, what's a formula that will take 3/2/2011 and return this value 2/28/2011? Is this possible in Google Spreadsheets?
user avatar
2 votes
2 answers
6k views

Is there a way to upload a .csv file to Google Docs using a Google Sheets as a template?

I am generating a .CSV file with an application. I then upload the .CSV file to Google Docs, which creates a Google Docs Spreadsheet which is "plain and white". I then have to manually format the .CSV ...
user avatar
2 votes
4 answers
15k views

How to collate data in Google Spreadsheets?

I have two sheets with data in single Google Spreadsheets document: SheetA: Date Name CounterA 22.02.2011 Beta 101 22.02.2011 Alpha 2 21.02.2011 Alpha 1 SheetB: Date Name ...
user avatar
14 votes
2 answers
11k views

Sum on condition?

I have set up a form with Google Spreadsheet where I want to collect grocery expenses for different people. How can I sum the expenses for different persons? Each row has a column with the person's ...
user avatar
  • 243
7 votes
1 answer
4k views

Type testing in Google spreadsheets

Is it possible to test for integers or strings in a Google Spreadsheet and respond to each differently?
user avatar
  • 173
10 votes
8 answers
29k views

Copy image from Google Sheets to Google Docs

There's an image in a Google Sheets that I would like to insert into a Google Doc. How can I transfer the image from the sheet to the document? I can right-click on the image and select "Copy&...
user avatar
1 vote
3 answers
11k 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 ...
user avatar
11 votes
3 answers
42k views

Get column number by referencing column title

In Google Sheets I have a number of columns that I have given titles to in Row 1. Using a formula, I want to return the column number (i.e. 5, 6, 7, ...) for the column that has a specific title. For ...
user avatar
  • 213
13 votes
6 answers
34k views

Is it possible to hide row numbers in a Google Sheets?

When looking at a numbered list that starts at the number 1, the row numbers are potentially confusing. (Assuming one has row 1 as column heading labels, item 1 will be on row 2, item 2 on row 3, and ...
user avatar
0 votes
1 answer
7k views

Automatically calculate overtime hours

I'm using Google Sheets to keep track of time with the bimonthly timesheet template. What would be useful is if the spreadsheet could start adding hours to another column when the total hours worked ...
user avatar
2 votes
2 answers
40k views

Google Spreadsheet formula, MINUS?

I have a spreadsheet with 3 columns: | ITEM | COST | SUBTOTAL | Subtotal, for example, is 1000 to start, like: -------------------------- | ITEM | COST | SUBTOTAL | -------------------------- | ...
user avatar
1 vote
3 answers
8k views

How can I retrieve records from a Google Spreadsheet in JSON format? [closed]

I'm trying to retrieve data from Google Spreadsheets with no success. I've gone through this: http://code.google.com/apis/spreadsheets/data/3.0/developers_guide.html#RetrievingTables and this: ...
user avatar
1 vote
1 answer
431 views

Google Spreadsheets Data Management

I am looking for a way to manage the input of some data in Google Spreadsheets. Before I roll up my sleeves and write a new UI using the Google API I thought I would see if there was anything out ...
user avatar
  • 155
-2 votes
2 answers
966 views

Not getting sub date granularity in Google Sheets trend lines

My data is in variable increments, anywhere from six to eight hours apart like so: 1-1-2011 00:00:00 100 1-2-2011 00:00:00 103 1-3-2011 00:00:00 107 1-4-2011 00:00:00 109 1-4-...
user avatar
  • 155
4 votes
1 answer
2k views

How to toggle every other column between visible/hidden in my Google Sheets?

I have a Google spreadsheet with my monthly balance sheet for my company. I keep track of estimated and actual like this: Expense | Jan11 Actual | Jan11 Estimate | Dec10 Actual | Dec10 Estimate | etc....
user avatar
  • 193
6 votes
2 answers
11k views

How can I use Google's functions in a spreadsheet's script?

When I use a function such as =importXml("http://www.google.com", "//a/@href") in a Google Spreadsheet cell, it works just fine. However, when I try to use the same function in a script, it gives an ...
user avatar
  • 29.9k
3 votes
2 answers
23k views

Put Google search inside Google Sheets cell

Is there a way to put a Google search widget inside a cell of a Google Sheets? I want to avoid my users having to hit Ctrl + F every time they search. Would be very cool to have a Google Docs App ...
user avatar
5 votes
1 answer
4k views

Charts for black and white printing?

I have a couple of column charts in Google Sheets that have several columns of data. I would like to print them out in just black and white, since they are part of a larger report that doesn't need ...
user avatar
  • 1,808
7 votes
2 answers
22k views

What's the biggest .csv file you can import into a Google Sheets?

I'm trying to upload/import a 7 MB .csv file to Google Sheets without much luck. What's the largest file size that you can import?
user avatar
  • 2,091
36 votes
11 answers
52k views

How to calculate weighted averages in Google Sheets?

I have a Google Sheets where products are listed as rows and attributes as columns. Each product's attribute is rated on a scale of 1-10. My last column is an average of these values (i.e. =Average(B2:...
user avatar
  • 29.9k
65 votes
12 answers
89k views

How to pass a range into a custom function in Google Spreadsheets?

I want to create a function which takes in a range... something like: function myFunction(range) { var firstColumn = range.getColumn(); // loop over the range } A cell would reference it using: ...
user avatar
  • 29.9k
8 votes
2 answers
67k views

Is it possible to use a loop in Google Spreadsheets?

I have the following document: +---+-----------+ | | A | +---+-----------+ | 1 | Foo (100) | | 2 | Bar (30) | | 3 | Baz (50) | +---+-----------+ I'd like to use a REGEXEXTRACT to extract ...
user avatar
  • 29.9k
2 votes
1 answer
1k views

How to plot time series graph with categories?

I've data in Google Spreadsheets, with columns as follows: DD.MM.YYYY CATEGORY COUNTER_1 COUNTER_2 For example: 22.12.2010 APPLES 1 20 23.12.2010 APPLES 100 20 23.12.2010 ORANGES 32 12 I need ...
user avatar
13 votes
3 answers
21k views

How to label points in a scatter plot?

I've tried using the built-in scatter plot chart and the Google scatter plot gadget. I haven't been able to figure out how to get either one to allow me to label the points in the chart. I have data ...
user avatar
20 votes
3 answers
99k views

How do I lookup a value from another sheet in Google Docs?

I have a page which looks like this: ╔═══╦════════╦══════╦═══╗ ║ A ║ B ║ C ║ D ║ ╠═══╬════════╬══════╬═══╣ ║ 1 ║ User A ║ 144 ║ ║ ║ 2 ║ User B ║ 5478 ║ ║ ║ 3 ║ User A ║ 2156 ║ ║ ╚═══╩══...
user avatar
  • 29.9k
6 votes
2 answers
8k views

How do I add a hyperlink to a cell in Google Spreadsheets?

In Excel, I can easily add a hyperlink to a cell by choosing the corresponding toolbar button. How do I do the same thing in a Google Doc spreadsheet? I don't see any corresponding toolbar button or ...
user avatar
  • 29.9k
3 votes
3 answers
2k views

How exactly does sharing work in Google Drive?

I have an Excel spreadsheet I made to track my own scores for an Xbox game I play (TrialsHD, if you are curious). I've made it available to other players so they can track their own scores, but it ...
user avatar
  • 273
9 votes
1 answer
9k views

Cross-reference sheets on Google Spreadsheets

I can just do B12 to reference a field on the same sheet I'm working on, but how do I reference B12 on another sheet?
user avatar
  • 193
3 votes
1 answer
3k views

How to extract information from the subject line and add to Google Sheets?

I'd like to be able to extract tasks from the subject line of an email in Gmail (using some sort of custom syntax) and then insert the task as a row in a shared Google Sheets. Currently the best way ...
user avatar
  • 133
82 votes
6 answers
199k views

How to add days to a date

I'm using a Google Spreadsheet to perform calculations and I'd like to do some simple date math. For example, TODAY() add 7 days. I don't see any functions to do it and some quick stabs in the ...
user avatar
68 votes
6 answers
242k views

Formatting a cell with word wrap without switching modes?

How can one format a cell to have word wrap in Google Sheets? I've tried Shift+Enter, but that doesn't seem to work. One thing I know works is to place the spreadsheet into List Mode and then if you ...
user avatar
  • 2,091
2 votes
1 answer
4k views

In Google Sheets in List View, can you add rows to the bottom instead of the top? [closed]

I've been using Google Sheets in List View (View->List View on the menu bar) as I have a fixed number of columns in my spreadsheet. I'd like to add new rows to the end of the List instead of at the ...
user avatar
  • 2,091