Part of the Google Docs suite, a web app that allows you to create and edit worksheets
4
votes
1answer
214 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?
4
votes
1answer
673 views
Normalizing and grouping dates in Google Spreadsheet
I have a spreadsheet pulling together various readings taken of hours heater has run, electricity units use for that period, and outside temperature.
For the last 3 months, the electricity usage and ...
3
votes
1answer
70 views
Conditionally format by day of the week
How can I conditionally format cells in Google spreadsheets containing dates to have a different background according to the day of the week, e.g highlight the Saturdays and Sundays in a column ...
3
votes
1answer
97 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
453 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 ...
2
votes
1answer
43 views
Compute average over month when measurement is irregular
I want to measure my power consumption. So once in a month I note my meter reading.
So I got the following data:
2012-12-01| 893.8| | |31
2013-01-05| 977.2|34|2.45|31
...
2
votes
1answer
145 views
Conditional formatting based on cell values in same column
In Google Spreadsheet, how do I change a cell's background color to red if the date in the cell matches the date in another cell in the same column? Column E in my spreadsheet is a list of due dates ...
2
votes
1answer
64 views
Exclude cell from sum in Google Spreadsheet
I am using my Google Spreadsheet to keep tabs of my incomming and outgoing money. I've made a row with ~19 cells in it, in those 19 cells I have the monthly what comes in and what goes out. At the end ...
2
votes
1answer
69 views
How to check if value is in range of cells?
I want to check if the value of a cell exists in a range of cells. How can I do this?
Just like you would be able to do "if value in list_of_values" in Python for example.
2
votes
1answer
79 views
How get last added text from column into different sheet
How can I get the last added plain text from a column in sheet1, which also has empty rows, into a cell of a sheet2?
With help I managed to do this with the last added date, but with plain text I am ...
2
votes
1answer
186 views
Calculate monthly sum() on pivote table
I have a Google Form. Upon submit following fields are populated:
Timestamp
Product Description
Unit Price
Quanitity
I have generated a pivot table from this data, in a Google Spreadsheet. The ...
2
votes
1answer
168 views
Auto date insert when opposite cell is populated
I am creating a spreadsheet which will contain records of my daily expenditure. Something like the following:
A | B
----------
0 | 50.04
0 | 20.00
0 | 19.99
0 | 2.40
What I am trying to ...
0
votes
0answers
11 views
Google Spreadsheet Form Responses in to an already made sheet
I have a template form and matching spreadsheet that need to be copied multiple times. When I make copies of the two, the copies are not linked for the form responses to go to the newly copied ...
0
votes
0answers
18 views
How to set hot keys to a customized menu item in a Google Spreadsheet?
I am working with Google Spreadsheet APIs, and found that customized menu item is highly useful. I created some but am now wondering whether I can specify a hot key for each?
0
votes
0answers
14 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
0answers
35 views
Download list of contact information and check if Google Account
I'm looking for a way I could:
retrieve a list of all my contacts and their email's and
In order to retrieve a list of all of my contacts into a Google spreadsheet, I exported them as a Google CSV ...
0
votes
0answers
30 views
how to put in a column how time person worked date by date per month
in this file i have in "foglio 2" column B every date worked for every person... i would like to take for every month the date the person worked. for example person "marco" and in "jauary" column ...
0
votes
0answers
20 views
Google Docs Changing the A B C-“Tabs” in Excel
The picture above is explaining. I'm looking for a way to change these " A B C " to a more describe way of what the content below is containing, etc A would contain what date, B is what length I run ...
0
votes
0answers
26 views
Google Docs spreadsheets: how to specify entire sheet as range?
The best workaround I have found so far is:
worksheet_name!$A$1:$YY
but ideally I would like to be able to simply write, e.g.:
worksheet_name!
So, does anyone know: is there a syntax for ...
0
votes
0answers
37 views
copy google document table of contents links into google spreadsheet cells
I have a large google document where each table of contents item links to the header of a food recipe further down in the document.
How do I copy each TOC link+title into cells in a google ...
0
votes
0answers
41 views
ARRAYFORMULA Using Row Above - Google Spreadsheet
I would like to create a column that contains a running decrementing tally, but is decremented by an amount from a different column on the same spreadsheet. Also, I would like to be able to add rows, ...
0
votes
0answers
54 views
IMPORTRANGE formula query per query in another file
Is it possible to create two different file where in the first i put the data and in the second the references query?? i used the IMPORTRANGE but this method gives me "=CONTINUE(A1; 2; 1)"... I want ...
0
votes
0answers
36 views
Copying cells in Google Spreadsheets and pasting into text file adds quotes around each cell
Copying cells in Google Spreadsheets and pasting into text file (tried with XCode, Notes, Text Edit - the below applies to all) adds quotes around each cell.
How can I avoid those extra quotes? Also, ...
0
votes
0answers
18 views
lock sheet from external viewers but let the view the rest of the spreadsheet - google docs
Ive got a multi sheet, spreadsheet that i want to give out to clients so that they can write in their comment directly into my spreadsheet.
There is nothing i don't want them see in the spreadsheet, ...
0
votes
0answers
89 views
Query google spreadsheet and display single column?
I am working on using Google Spreadsheets as a gradebook. I am attempting to display only a student's grade, not an entire classes. I am integrating this into my wordpress site. The function I want to ...
0
votes
0answers
70 views
Can't delete comments on Google Drive spreadsheet
I did a copy of spreadsheet with comments then deleted content in order to have a template spreadsheet.
The issue I have is that comments were also copied in the new spreadsheet, I did a "delete all ...
0
votes
0answers
38 views
Question about a Google Spreadsheet function (I don't even think of how to describe it in the title)
Pretty much what I'm trying to accomplish is the following:
Cell F1 is a drop down menu.
If F1 contains the words "whatever", then look up the word in A2 on sheet 2, and input the data in 3rd ...
0
votes
0answers
23 views
Redmine issues to google spreadsheet
I know that GoogleSpeadsheet can read external data from URL with ImportXML (among others).
I know that redmine can export data in XML, json, ...
The question is how can I list the issues of a given ...
0
votes
0answers
30 views
Repeat range under each other in Google Spreadsheets
I have a range of two columns with year and dates. In another sheet I want to repeat this range for X amount of times under each other. How can I do this?
So for example I have this range:
Year | ...
0
votes
0answers
63 views
Google spreadsheet revision history — too much detail
For word processing, Google Docs revision history is great.
However, for some of my spreadsheets, something isn't working right:
Revisions are not grouped together, multiple for each minute.
"Show ...
0
votes
0answers
123 views
How do I get an onEdit script to run on a Google Spreadsheet for all users
I created an onEdit script which re-sorts a Google Spreadsheet every time a cell is edited.
The Google Spreadsheet is shared amongst multiple users and I'd like the script to run for all users, every ...
0
votes
0answers
107 views
Apply conditional formatting rules to Google spreadsheet column past set limit (10)
Limit to conditional formatting appears to be 10 per column. Any work around except creating another column next to it for those additional rules or functions, then copy/paste data from one column to ...
0
votes
0answers
230 views
Use Google Apps Script to Parse Google Spreadsheet cell based on date
I would like to use a google apps script to parse a spreadsheet containing 2 columns:
|--Date--|--Schedule--|
|-3/4/13-|--Day 5, G--|
|-3/5/13-|--Day 6, F--|
I want to create a script that parses ...
0
votes
0answers
108 views
2 axis line chart in Google Spreadsheets
I've set up a Google Spreadsheet to compare one set of stats against another. The stats are for traffic vs. an action the actions only happen once a day and not every day were as the traffic has more ...
0
votes
0answers
131 views
focus a specific cell in Google Spreadsheet when a URL is clicked?
I have a questions regarding Google Spreadsheet remote entry.
We use Google Spreadsheets to maintain our inventory and we use QR labels attached to the boxes - we use an iPhone app to decode the QR ...
0
votes
0answers
110 views
How to read a multiple values in cell in each row (separated by comma) in a Google Spreadsheet
I have problem in reading cell with multiple values and comparing the each value with column from a-z if match found then set value of the cell has '1'.
Problem: I need to take multiple company names ...
0
votes
0answers
27 views
Adding a few lines of information to a grid
I have made out an 8 column, 21 lines, informative health chart with grid lines.
I would like to add an afterthought running from left to right UNDER the grid lines that will PRINT out with the ...
0
votes
0answers
22 views
How to paste as value in a given time with a formula (google sheets)
I have created an indicator and it changes every day. I want a record of it in a serie, to make a lines graphic, this is, in Google Spreadsheets.
One idea is to paste as values, with an "if" function ...
0
votes
0answers
229 views
Pull CSV data from URL to Google Spreadsheet
I have a site which allows authenticated users (read: in-house users) to download certain data from the site in CSV format, e.g. http://example.com/activities.csv . Can I create a Google Spreadsheet ...
0
votes
0answers
107 views
Responses Spreadsheet for Google forms: answers are not pasted properly
I created a Google Form and I have been tweaking the Responses spreadsheet to automatically formulate some statistics (you have seen this in my previous question).
Now, the spreadsheet has a weird ...
0
votes
0answers
231 views
How to auto increment a field in Google Spreadsheet
In my spreadsheet I have a column called S+ No.
How to auto increment this for each row, like:
S1,S2,S3,S4
In short how to make it dynamic.
0
votes
0answers
40 views
How can I show the freeze order on the published file?
I created an Excel file on Google Drive, with the intention to embed it on my website. I need to freeze 3 columns in the sheet, save it and publish the file. But the file was published without fixed ...
0
votes
0answers
129 views
Google spreadsheets - “=ImportHtml DIV” how to?
I play Runescape and I want to make a tool that people can use to make profit in the game.
My problem is that I am not sure exactly how do use a command to pull data text from a div element. The ...
0
votes
0answers
36 views
Search and fetch the next cell in an array within one row of data in Google Spreadsheet
Trying to search and fetch the next cell in an array within only one row of data in Google Spreadsheet.
Vlookup and hlookup don't work cause it is getting the data from next column or next row instead ...
0
votes
0answers
129 views
Converting and Excel to Google Spreadsheet
I am trying to convert an Excel Spreadsheet to a Google Spreadsheet, but after it is converted, the document is smaller in size. How can it get it to be the exact size that I uploaded?
0
votes
0answers
20 views
Function Question
I am entering data into the spreadsheet and I could use some type of function that would link separate columns if there is a #1 entered. Such as if a 1 is entered into column F + column K + N, column ...
0
votes
0answers
120 views
Get Published Google Doc in JSON
I have a Published Google DOc at
https://docs.google.com/spreadsheet/pub?key=0AtjON-ccqVTgdDhKeGx0UlZpUWUyLTFZV2szQlJyNnc&output=html
I want to retrieve in JSON. I've been trying this but its ...
0
votes
0answers
212 views
Link Google Adwords & spreadsheet Google docs
I'm trying to link Adwords data with Google Docs. Now I have linked analytics and Google Docs spreadsheet. So now I can see the analytics data in a spreadsheet of Google Docs (I used "magic" Google ...
0
votes
0answers
372 views
Google spreadsheet loop through data validation fields
I have multiple sheets with data validation drop down fields and a number in the next cell of the row. On a summary sheet I would like to loop through each row of the data validation data, and if it ...
0
votes
0answers
646 views
Is it possible to sync a GCal calendar with an Excel/CSV file and/or Google Spreadsheet?
I keep track of the concerts I'm attending with a spreadsheet, which I primarily edit in Google Drive and sync to my computer using Syncplicity. What I would like to do is sync this spreadsheet, in ...
