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

learn more… | top users | synonyms (2)

6
votes
0answers
1k views

Publish spreadsheet as Atom/RSS not possible in Google Apps for Business

I am trying to publish a Google spreadsheet as an RSS feed using Google Chrome. When I go to File → Publish to web and then go to Get a link to the published data, the option Atom/RSS feed is not ...
4
votes
0answers
44 views

How to have multiple users complete a single form in Google Forms

Using Google Forms, is there a way to have a user complete a section of a form, share the form and have another user complete another section of the same form, thereby keeping the combined inputs as a ...
4
votes
0answers
2k views

Is it possible to link a cell in Google Spreadsheets to a Google text document? (not spreadsheets)

I learned here on Web Applications how to link a cell in Google Spreadsheet to a cell in another Google Spreadsheet: How do I link a cell in Google Spreadsheets to a cell in another document? Is ...
3
votes
0answers
338 views

Google spreadsheets importrange() error: Loading Data

Is there any reliable alternative to ImportRange() in google spreadsheets? After some time the formula brakes, and shows "Error: Loading data... ", and it wouldn't work until I change anything in the ...
3
votes
0answers
51 views

Track changes in read only shared Google Docs

I have shared a spreadsheet, anyone having the link can see it. Since it is a spreadsheet I update daily, I want to facilitate the others recognizing the last changes. However, revision history is ...
3
votes
0answers
64 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. ...
3
votes
0answers
928 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
14 views

Entire sheet as a function

Is it possible to use an entire worksheet as a function? I would like to be able to define the inputs to the worksheet and then select a certain cell as the output and copy that multiple times. I ...
2
votes
0answers
20 views

Is there any option to operate with 2 lists in one list in Google Sheets?

Is it possible in Google spreadsheets to have one list which is somehow divided into 2 parts and both of those parts consist of different lists? Something like iframes in HTML.
2
votes
0answers
18 views

Insert a datatable directly under my chart in Google Spreadsheets

How do I create a data table directly under my chart on Google spreadsheets? I want to achieve something similar to the figure below. In MS Excel it is called datatable and it is inserted by a click ...
2
votes
0answers
54 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
104 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
44 views

Save daily to my Gmail in Google Sheets

Right now what I have is this in a Google sheet for my company daily lunch program: function sendLunchPerkSummery() { var d = Date(); var file = ...
2
votes
0answers
120 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
64 views

Pre-fill field with formula — incremental counter — in Google form

I have a Google Docs form that I use to track my customers complaints. Is it possible to have a "counter" field pre-fill with an incremental number? I want my customers to have a complaints number ...
2
votes
0answers
28 views

Go to changes in Google Spreadsheet (or Docs)

When I see that somebody has changed a document I am working on in Google Drive, I normally want to see where exactly the change happened. Using File > See Revision History... is not really helpful ...
2
votes
0answers
32 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
108 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
37 views

Automatically adjust corresponding cells when using “=query”

I just learned how to use the =query function in Google Sheets, pulling information from one sheet to the next when a specific condition is met. =query('Sheet1'!A:Z, "select B, D, E, F, G, I, L where ...
2
votes
0answers
43 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 ...
2
votes
0answers
36 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
82 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
57 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
109 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
40 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
17 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
194 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
75 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
625 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
331 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
994 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 ...
2
votes
0answers
311 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
250 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
28 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
17 views

ImportRange with preserved formatting in Google Sheets

I am importing a certain range of data from a master sheet and would like to maintain the formatting for those cells. Cell reference with colour formatting This would be the perfect option, except I ...
1
vote
0answers
45 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
26 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
33 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
16 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
24 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
33 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
28 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
32 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
17 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
59 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
20 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
26 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?
1
vote
0answers
24 views

Why is there sometimes no “Move to trash”/“Move to bin”

I'm trying to clean up some old Google Sheets, but some of them don't have a "move to bin" menu option: Other spreadsheets do have it: What's the difference? How can I delete spreadsheets that ...
1
vote
0answers
23 views

How to grant a specific list of user to access Google Form?

Currently when I click on the "Send Form" button in Google Form and user will be able to input the form when they know the URL. Is it possible to grant a specific user to have access to the form? (So ...
1
vote
0answers
47 views

Dynamically creating sums from lookups

I was trying to do something similar to this post: Google Sheets advanced lookup + sum But I just can't figure out how to amend it for my purpose. I'm basically building a diet plan, where I have ...