One of productivity apps in Google Drive, that allows you to create and edit worksheets

learn more… | top users | synonyms (2)

4
votes
0answers
43 views

Retrieve the distance between two cities

Credit: Google Spreadsheets function to find distance between cities function getDirection(city1, city2, unit) { var directions = Maps.newDirectionFinder() ...
4
votes
0answers
59 views

Embedding a Google Visualization Chart inside a Google Spreadsheet

Unfortunately, the embedded charts in Google Spreadsheets do not have the customization I want. I would like to use a Google Visualization Chart instead. The documentation discusses how to use a ...
3
votes
0answers
26 views

How to merge multiple spreadsheet content having the list of keys to them?

Input: column of Google keys for spreadsheet that contains tables with some data, eg: date | refNum | Name | Description Require: a sheet that will contain a merged table with data from ...
3
votes
0answers
75 views

Notes In Published Google Spreadsheets

I've developed a website for our active adult association. I upload an Excel spreadsheet to Google Drive. It has notes attached to cells. The notes display fine in the converted version in Drive. ...
2
votes
0answers
28 views

Adding columns automatically to Google Sheets

I am using Zaption and Socrative as assessment tools while teaching. After I download the CSV files, I import them to Google Sheets. I figured out a way of having the results sent to a PDF after ...
2
votes
0answers
39 views

Generate a formatted Google document from spreadsheet

As the title says, I have data (Q & A grouped by subject) that I have to export to a document file. As shown above, the source data on the left should be formatted like the example on the right ...
2
votes
0answers
12 views

Adding an overtime column to a Google Sheets template that includes the overtime rate in the total

I would like to use this template to log bi-weekly hours. It is almost perfect except that there is no column for overtime hours. How would I add an overtime hours logging column that would add the ...
2
votes
0answers
37 views

Conditional formatting based on another cell

I use Google Sheets to schedule office appointments. I have set conditional formatting so that if the appointment time slot cells are empty, they are highlighted yellow. (This makes it easier to find ...
2
votes
0answers
38 views

Google Spreadsheet adding new lines in between

I've encountered an issue with Google spreadsheet. When I'm trying to add some text, I'm noticing a new line being added in between. Is anyone else having the similar issue?
2
votes
0answers
61 views

Formula breaks subtly in ARRAYFORMULA in Google Sheets

I have a spreadsheet document with a formula comparing a list of URLs to lists on two other sheets within the document. I desire to know if each URL on the first list is present on the blocklist, ...
2
votes
0answers
110 views

How do I create a map from Google Sheet data that's in another sheet?

I'm trying to create a Google My Map based on addresses in a Google Sheet "file". This seems to work OK following the standard instructions, except that I can't seem to extract data on anything except ...
2
votes
0answers
271 views

How to set Custom data validation in Google Sheets (A really simple step-by-step guide needed)

I'm trying to figure out how to create custom data validation in Google Sheets what are the steps I need to follow to achieve this? For example if I wanted the following validation: // Set the data ...
2
votes
0answers
33 views

Appearance of Forms I never created in Google Drive

I have some Google Sheets file which I copy and change monthly. I never used Forms, but they are appearing all the time in the Drive and are related to this G.Sheets file as you can see on the ...
2
votes
0answers
132 views

Batch Hiding Function in Google Script

I wrote a function that iterates through every non-blank row in the sheet, checks the value of a certain cell, and then if that cell matches my criteria its row number is added to an array. I then ...
2
votes
0answers
331 views

Case insensitive character string filter for multiple individual columns (dynamic input for each)

I'm looking for an efficient way to filter a data set by multiple individual, case insensitive character strings for multiple columns in a Google docs spreadsheet. I can already achieve this by ...
2
votes
0answers
46 views

How do I reference a cell from a Google Spreadsheet in a Google Document

I would like to create a Google Spreadsheet and reference a cell(-range) from that spreadsheet in a Google Document. Basically, I want the spreadsheet to be a variable holder where I can input data ...
2
votes
0answers
88 views

How to Modify Matched Cells Across Multiple Sheets with Google Script

My question is a fairly complex one, but I'll do my best to clarify exactly what I'd like to do and this requires some background: I have a Google Spreadsheet used for user administration in my ...
2
votes
0answers
61 views

Can't unmerge cells

I have a lot of data in a Google spreadsheet that depends on charts I spent ages trying to make look pretty. There is a stupid block of merged cells that won't unmerge, and when I try to ...
2
votes
0answers
112 views

How to make script slow down in GoogleSheets Script Editor?

I have a script thats attached below, and the problem I'm facing is that after it has keyed in "ticker" to Raw Data in b1, my entire sheet is never done loading and thus when its time to check if it's ...
2
votes
0answers
42 views

Change logs for Google Spreadsheets

We've got a large shared spreadsheet which is a chart showing user permissions. Its writable by several people. Although Google Drive allows you to roll back the changes simply its interface isnt ...
2
votes
0answers
18 views

How to avoid selecting a cell address when using the arrow keys while editing a cell

Sometimes, while editing the contents of a cell, using the arrow keys will not move the cursor but instead inserts the address to an adjacent cell. Here is an example of this problem with a ...
2
votes
0answers
236 views

Data validation from other Google Spreadsheet

My scenario : Google Spreadsheet A Google Spreadsheet B I want a Data Validation in one cell in Spreadsheet A that it's criteria is based from a list from a range on the SpreadSheet B. I know ...
2
votes
0answers
79 views

Is there another way to click on the hyperlink in a Google Spreadsheet?

I am aware of the process to click a link on the spreadsheet. However, is there a way where the user of the sheet can directly click on the link? I am trying to prepare a decision tree where, once a ...
2
votes
0answers
648 views

Apps Script Webapp accessing Google Spreadsheet gets #VALUE! on every cell

I have a Google Spreadsheet with a couple of sheets that get data from other spreadsheets via ImportRange function and then calculate numeric values based on that data. Then, I assembled a code ...
2
votes
0answers
338 views

Microsoft Excel 2010 is password protected but opens in Google Spreadsheet showing all locked and hidden formulas

This is a huge problem. When we email a password protected Excel file with hidden and locked cells to protect formulas, they open on a Droid showing and allowing manipulation of all protected ...
2
votes
0answers
1k views

Delay in updating referenced cells when using importrange in Google Sheets

I'm using the importrange() function in Google Sheets to reference data from 'spreadsheet1' and display in it 'spreadsheet2'. This works fine, but if I edit 'spreadsheet1' and then go to ...
2
votes
0answers
334 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
253 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
15 views

I created a button in a panel (dialogue window), when I push the button I'd like to appear a new panel (dialogue) window

I created a button in Google Spreadsheet. When I push the button a custom window appears. In that window I have two buttons, one to close and one to see a new window. Everything goes well except the ...
1
vote
0answers
16 views

Ensure results stay in redesignated column and don't migrate back to original column

Before updating my spreadsheet to fetch new information from the provided scripts, I insert a new column in between the input column (A) and the results column (B). I want my new results to be next to ...
1
vote
0answers
23 views

Google Spreadsheets SUMPRODUCT/COUNTIF in Arrayformula

Actors\Genre 1 2 3 4 5 6 7 A B C D I need to get the counts of the movies by genres acted by the actors in the column and the movie data is in another spreadsheet, "data". I tried the formula ...
1
vote
0answers
68 views

For every occurence of x insert a new row beneath it

I'm using XPath in Google Spreadsheets. In some of my cells I receive fetched results, in others I get #REF!. The explanation given is Array result was not expanded because it would overwrite ...
1
vote
0answers
12 views

Representing hierarchical data in Google spreadhsheet

Background Smartsheet.com allows hierarchical representation of data in a single sheet {without having to use adjacency lists } smartsheet hierarchical data example Question Do google ...
1
vote
0answers
8 views

freeze column according to column heading

I am working on attendance in Google spreadsheet, I want to protect the date column which is past date and future date, I just want to give edit right only for today date.
1
vote
0answers
22 views

Retrieve row data based on indirect Max function value

This spreadsheet tracks live song ratings for a popular band. Users input their score in their own column and those scores are averaged into a community score (Column E). Those song averages are ...
1
vote
0answers
16 views

How can I check emails against a Google sheet containing a list of email addresses?

I am conducting a research study and receive many emails (via Gmail) from potential participants. I do an eligibility screen with participants over the phone, and if they are not eligible, I add their ...
1
vote
0answers
49 views

How to add a line break in a custom date format in Google Spreadsheets?

Google Spreadsheets give us a tool to create and use a customized data format for date values. While the tool allows us to use arbitrary characters, like slashes and commas between the date fields ...
1
vote
0answers
97 views

Cell-dependent cell ranges in data validation in Google Sheets

Regarding Google Sheets -- is there any way to have cell-ranges in data validation depend on the cell itself. For instance, I want G7 to accept input only from E7 and F7. Similarly, I want G8 to ...
1
vote
0answers
64 views

Filter by Date Range in Google Spreadsheets

The filtering in Google Spreadsheets seems to only offer text based solutions. Is there any ability to filter cells by date ranges like any of the following: Today Yesterday Last Week Since ...
1
vote
0answers
47 views

Filter from multiple sheets into graph using Google Spreadsheets

Context I've got a big travel expenses spreadsheet. In it, I have daily entries for different expenses labelled with things like Date Currency Ammount Exchange Rate Amount in £ (my native ...
1
vote
0answers
27 views

Jagged array from Google Spreadsheet range

The range in my Google Spreadsheet looks like this: | A | B | C | D | E | F | ...
1
vote
0answers
31 views

Reference an entire sheet in Google Sheets

Is there a way to reference an entire spreadsheet with a cell reference in Google Sheets? Say I wanted to find out how many cells in Sheet1 were non empty. In sheet two I'd want to do something like ...
1
vote
0answers
43 views

Import a CSV file from a URL to Google Docs and update it periodically

I'm looking to pull data from a CSV file that gets update regularly into a Google spreadsheet that I can format the way I want. I know how to import the CSV as a one time thing but I don't know how to ...
1
vote
0answers
63 views

How to change default row height of a migrated Google Spreadsheet

The old Google Spreadsheet has a default row height of 17. The new Google Sheets has a default row height of 21. After a spreadsheet is auto-migrated by Google to the new Google Sheets, the original ...
1
vote
0answers
35 views

function to verify all cells in active row

I have a function which is triggered onEdit to enter an ID in new table entries: function IdGenerator(e) { // Get the active sheet var sheet = SpreadsheetApp.getActiveSheet(); // Get the ...
1
vote
0answers
20 views

Help me check if this URL is ok to query with Google Chart

For the last couple of hours been trying to get this work. I setup a demo sheet with just two colums: Name Value A 22 B 33 C 44 D 12 And want to plot it. I put this URL into ...
1
vote
0answers
101 views

How to combine and consolidate rows from multiple sheets into one and sort them?

I've few sheets where rows are populated dynamically via IMPORTXML and ImportJSON with the same columns, but they can't be sorted. So I'd like to generate new sheet which will populate rows from ...
1
vote
0answers
8 views

Detect column D changes with Google Apps Scripts

I would like to detect if the column D rows in my spreadsheet are becoming a date (at the beginning those column rows are empty), so if D1, D2, D3 become a date their text or colors should blink. Now ...
1
vote
0answers
22 views

Is there a way to stop Google sheets from telling me to use Ctrl C?

I know the keyboard shortcuts for cut, copy and paste, and I use them frequently. But there are times when using the mouse is much more convenient. Especially if I want to copy a whole row, I prefer ...
1
vote
0answers
31 views

How can one serve a single google spreadsheet cell content to a web page?

I can embed a Google Docs/Spreadsheet's whole tab/table on a web page. Is there a simple way to publish the (unformated) content of a single cell?