Part of the Google Docs suite, a web app that allows you to create and edit worksheets
4
votes
0answers
209 views
Preserve formatting when referencing cells across sheets in Google Docs
Is there a way to show the formatting of the referenced cells from another sheet in Google docs spreadsheets? For example I have a sheet named balance with A1 having a comment and a blue background. ...
3
votes
0answers
91 views
How to copy from Google Spreadsheet without it editing the source data
Every time I copy and paste from a Google Spreadsheet, it adds a double quote before and after everything, and duplicates every single double quote.
For example, if I copy:
This is a "string" of ...
3
votes
0answers
202 views
Why is “access denied” to multisheet charts in published Google docs?
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 ...
2
votes
0answers
47 views
How to do a date formula in Google Spreadsheets
I have to do a query that increments automatically the date year by year. For example I use this formula:
=INDEX(query('Scheda Intervento'!C3:K14;"select sum (K) where (F >= date '2013-01-01' ...
2
votes
0answers
358 views
Google Spreadsheets: add unique QR code field to a spreadsheet based on a form in google docs using Script Trigger
At the end of each row filled in, using a custom Google Form, I'm adding three more columns:
Date of creation
Unique ID
QR code (it is a list of computers)
Unique ID and QR code are unique. QR ...
2
votes
0answers
31 views
In a Google Sheets chart how do I prevent “Other” in the legend?
When there are over 8 series in a chart (this is true at least for a pie chart) - Sheets combines all other series above the 8th into "Other" this is really counter productive when there are only 9 ...
2
votes
0answers
163 views
Cumulative Sum without Script
For this question, I've created a Google Apps Script function, that calculates the cumulative sum of a range. Martin Hawksey on Google+ made a comment about a more efficient way of calculating the ...
2
votes
0answers
180 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.
2
votes
0answers
132 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 ...
2
votes
0answers
184 views
Can I precisely position charts in a Google Docs spreadsheet?
I am using Google Docs to create a "Monthly Report" spreadsheet for a product, and am attempting to make an attractive, compelling experience for the consumers of the report.
In this spreadsheet I ...
1
vote
0answers
31 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 ...
1
vote
0answers
63 views
how to make Google Docs spreadsheet recognize data as numeric
I have the opposite of a fairly standard problem -- how do I force Google Docs spreadsheet to understand that a value is numeric?
It seemed like using Format > Number should do the right thing, but ...
1
vote
0answers
41 views
delay in updating referenced cells when using importrange in google drive
Im using the importrange() function in Google drive to reference data from 'spreadsheet1' and display in it 'spreadsheet2'.
This works fine, but 'spreadsheet1' and then go to 'spreadsheet2' its not ...
1
vote
0answers
27 views
Question about pulling multiple numbers from a single cell
I'm trying to cut down on the number of columns my spreadsheet has, to made it easier to pull data from, and to make the general appearance better.
What I'm trying to do is put two numbers in a ...
1
vote
0answers
48 views
How to tally entries by user, date
I am using a Google spreadsheet to track entries by several users. How do I measure their productivity per day? Or per hour? I have the timestamp field, a user field and other fields, but what I want ...
1
vote
0answers
65 views
How can I make text flow out of a cell as it does in Excel?
If you enter a long bit of text into a cell in Microsoft's Excel the text flows out of the cell over the top of the adjacent cells. This doesn't happen by default in Google Spreadsheet - it flows ...
1
vote
0answers
64 views
Create new document within spreadsheet and link
I would like to create a spreadsheet script that allows me to create a new document every time I click on a new cell or row and then have that document links back to that cell.
1
vote
0answers
59 views
Shared Google spreadsheet: enabling app script to run as author
I created a spreadsheet that I'd like to share with anyone with the url.
The sheet contains several app script functions. These functions both change the content of the sheet and copy data to another ...
1
vote
0answers
48 views
How to protect table cells in Google Spreadsheets from myself (accidental edits)?
As in Microsoft Excel, I want to protect certain cells in Google Spreadsheet. This is possible, but asides from the fact that it is quite confusing to me, it doesn't seem possible to protect cells ...
1
vote
0answers
54 views
Conditional formatting for dates in Google sheets
I work at a language school and I have a column giving the students expected arrival date.
I want to set conditional formatting to:
Highlight in red any date that is older than 1 week
Highlight in ...
1
vote
0answers
102 views
Google Drive Form doesn't display on Google sites if not signed in on chrome
I have a site, hosted by google sites that includes a Spreadsheet Form from google drive.
Normally, the page loads, then a second or so later the form loads.
In the problem case the page loads, but ...
1
vote
0answers
46 views
Google Spreadsheet: the script enabling email sending to a cc list doesn't always work
We have a Google Forms that, when filled, is sending out a list of people put on cc. This doesn't always work.
How can this issue be solved?
1
vote
0answers
85 views
Copy one google spreadsheet to another
I am developing a google spreadsheet that I want to make publicly accessible to a community. I've released the first version of it, and now everybody in the community has that first version's link ...
1
vote
0answers
40 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 ...
1
vote
0answers
98 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
vote
0answers
95 views
Sorting on a web-published Google Spreadsheet
I have a Google Spreadsheet that is published to the web and embedded in a website. This spreadsheet has data about hotel rooms, such as hotel name, number of rooms, date in and out, etc.
I would ...
1
vote
0answers
119 views
Protect Formatting (Validation)
I have a very complicated tool that I developed that produces a mass amount of information. Technically, the whole sheet should be a database drive website. However, it is a spreadsheet:
...
1
vote
0answers
110 views
Google Docs capabilities
We've created a commission calculator to help our resellers work out what commissions they will receive on a deal.
We built it in Excel 2010 but want to move it to a web based platform that will ...
1
vote
0answers
128 views
Google spreadsheets and sorting protected range
I've been trying to make the spreadsheet automatically sort some data, and after some searching I found this link..
it's working just perfect with my permissions as the owner but when any of my ...
1
vote
0answers
171 views
How to make a query with Google Spreadsheet, that returns rows if deadline is two weeks from today, one month from today, 2 months from today, etc
I have a spreadsheet that contains several columns with project information. I basically want to modify the following formula:
=QUERY( 'Compilation'!A2:L; " select A, B, F, I, L order by A" ; 0 )
...
1
vote
0answers
37 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
0answers
99 views
Google Sheet document using ImportXML doesn't Automatically Republish
I created a file that uses ImportXML to pull prices from a set of web pages, and bless me, it works! To stay updated with the changes in price, I ticked the "Automatically republish when changes are ...
1
vote
0answers
33 views
How to build a search as you type google spreadsheet
I want to build a embeded google spreadsheet that will be searchable by the way of SAYT so that not all information, but only related rows will be displayed. How can I do it?
Thank You
1
vote
0answers
109 views
How to Create a Dynamic SubTables Based On Data From Another Sheet? (Google Spreadsheet)
I'm wondering if there is a way to create a sheet with dynamic subtables based on data from another sheet in google spreadsheets?
Each student will use a form to enter data to sheet: "Entries" like ...
1
vote
0answers
48 views
Filtering Form Feedback using Google Docs
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 ...
1
vote
0answers
60 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.
...
1
vote
0answers
145 views
Table of Contents in Google Spreadsheets
I'm curious to know if there's a way to create a table of contents within a Google Drive Spreadsheet. I would like to be able to set the active cell in the spreadsheet based on what cell (or contents ...
1
vote
0answers
135 views
Need count of items in one column with specific month/date in another column in Google Docs
I have been trying to use COUNTA with FILTER, but not getting correct results. The column I am counting from has text values input from a drop-down menu, which caused problems just counting until I ...
1
vote
0answers
83 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?
1
vote
0answers
105 views
Hyperlink to “view-source:” URL in spreadsheet
I'm trying to make a hyperlink that takes you automatically to the source of a page in a Google spreadsheet.
eg I want to make view-source:http://superuser.com directly clickable, rather thank having ...
1
vote
0answers
84 views
How to graph one column against another from multiple sheets in Google Spreadsheets?
I have a spreadsheet here: graph with one column against another from multiple sheets
I want to graph the ascent columns against the distance for each of the three tabs on the graph.
How can I make ...
1
vote
0answers
165 views
In Google Spreadsheets the xPath method with Google Maps don't work anymore?
I've used this query to calculate distance between two locations, now it won't work anymore, and returns the error xPath query didn't get any result (translated from Italian, I don't know if is the ...
1
vote
0answers
446 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 ...
1
vote
0answers
253 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 ...
1
vote
0answers
347 views
How to extract info from the subject line and add to Google Spreadsheet?
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 Spreadsheet.
Currently the ...
1
vote
0answers
73 views
How to dash a whole row if a cell is OK?
I have a cell that can be OK, ERROR or WARNING. When it is changed to OK I want to modify the whole row in some way. I was thinking about to dash all cells.
Is it possible? Or is there something I ...
0
votes
0answers
15 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
13 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
23 views
Create sheets in a Google Spreadshet from an array
I need to create 50+ sheets in a Google Spreasheet from an array of strings, either with a formula or a Google Apps Script.
How would I go about accomplishing this?
0
votes
0answers
32 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 ...
