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

learn more… | top users | synonyms (2)

4
votes
1answer
192 views

How to nest ImportRange into the query function in the new Google Sheets

We have applicants who come in and fill out a form via Google Forms. I have fields that auto-populate from the Response tab into a separate tab that is organized to fit our trackers. I am looking for ...
4
votes
1answer
1k 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
183 views

How do I print comments of a Google Spreadsheet?

Can I print the comments of a Google Drive spreadsheet? And if yes, how? I should mention that the print should not be on the same page.
3
votes
1answer
200 views

How can I create a Google Spreadsheet whose name and cells auto-complete with cells completed on another sheet?

I'm using Google Spreadsheets to manage projects, and I'm not familiar with scripts or macros (though I'd really like to learn how to use it, so if you have any good tutorials or tips, let me know). ...
3
votes
1answer
419 views

Is there a way I can set only a certain sheet visible in Google Spreadsheets?

So lets say I have a Spreadsheet and I press the share button to Public (no edit except me). I have 2 sheets but only want other users to see 1 sheet. Without having to create another document is ...
3
votes
1answer
262 views

How to anchor all the cells on the page in Google Spreadsheet

To anchor cells in a Google spreadsheet so that you can drag the values/cells/formula, with one or more of the linked cells/values remaining constant you can follow these steps: ...
3
votes
1answer
317 views

Monitor webpage changes using Google Spreadsheets

I want to monitor a web page. The best solution I found was Google Spreadsheets (apart from feed43 which has limitations). I'm using the importHTML function in Google Spreadsheet which will update ...
3
votes
1answer
651 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 ...
3
votes
1answer
586 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 ...
2
votes
1answer
36 views

Google Sheets auto-format the highest value in a row of cells

I have a set of data like so: A|B|C|D 1 9|3|5|4 2 7|6|6|6 3 3|6|2|7 4 6|9|4|7 And I would like to auto-format the highest value in each row. So, for instance in row 1, A1 would get the ...
2
votes
1answer
23 views

Adding particular data to particular sheets within one document

I am a bit new at this and am having a tough time getting this to work... I have multiple sheets, one main one (Submissions) which receives data from a form, then I have the sheets: Level 1, Level 2, ...
2
votes
1answer
66 views

Consolidate List of Similar Data into Single Row in Google Spreadsheets

I have a Google Spreadsheet that lists donations given by constituents with a unique account number. Several constituents have made more than one donation in a given period of time listed separately. ...
2
votes
1answer
160 views

How to automatically refresh date in Google spreadsheet published to the web?

I am using Google Spreadsheets to maintain a register of all students in my school and track their monthly payments. Each student has a separate Google spreadsheet maintained and in the spreadsheet I ...
2
votes
1answer
182 views

Preventing Paste Overwriting Cell Formatting in Google Sheets

I have a spreadsheet used for booking employees onto training sessions. It's very simple to use; the person booking simply enters their employee number into column A and column B, C & D ...
2
votes
1answer
172 views

Google spreadsheets showing “shared with xxx” count greater than actual?

For every one of my Google spreadsheets, the sharing settings is on "Specific people can access", and each sheet is shared with 3 people I know. Their names are listed when I click on the blue "Share" ...
2
votes
1answer
94 views

Is there a way to neatly format length in Google Spreadsheets across multiple orders of magnitude?

I have a spreadsheet with a column for length with values ranging from millions of kilometers to fractions of micrometers. Viewing it all in meters as unformatted numbers directly is awkward since you ...
2
votes
1answer
103 views

ARRAYFORMULA and COUNTIF

I have a formula: =IFERROR(COUNTIF(C14:V14,"I")/ COUNTIF(C14:V14,"<>"),) to compute a percentage of I inputs divided by <> (all other inputs) and I need to omit blank cells. The IFERROR ...
2
votes
1answer
79 views

Google Spreadsheets: Identifying and Working with Any Cells that Match

I am trying to find a function, or a series of functions, that allow me to (1) Identify if any cell in column A matches any other cell in column A, (2) add numbers in Column B that occupy the same ...
2
votes
1answer
60 views

Display Columns For this weeks Data

I'm trying to create a to do list schedule like spreadsheet that would show only the data presented for the current week. I've been having some difficulty figuring out how to display the data of ...
2
votes
1answer
313 views

Date Formatting for Deadlines

I have set up a Google spreadsheet for managing projects and due dates, and I need to apply the following formatting to a column of dates, but I'm not sure how: Dates more than 7 days from today: ...
2
votes
1answer
122 views

Get data from specific date in Google Spreadsheets

I’m trying to collect data from specific dates in a Google spreadsheet. For example, I want to get the data from January only. Is this possible?
2
votes
1answer
63 views

Creating a Chart with independently indexed series

I have a data series that looks like this: 0 317.59 1.4 317.59 1.5 408.77 2.15 408.77 2.25 440.46 2.98 440.46 3.08 471.37 3.12 471.37 3.17 ...
2
votes
1answer
2k views

Import Google Spreadsheet range if a column contains a particular value

I want to import a range of data from one Google Spreadsheet (1) into another (2), but only when Column J in spreadsheet 1 contains a 'yes'. I'm using the following formula: ...
2
votes
1answer
2k views

Google Spreadsheets Data Validation - Unique Values

I have a google sheets document which contains two sets of data in separate worksheets: Public IP addresses Private IP addresses In my private IPs worksheet I want to create a dropdown which ...
2
votes
1answer
83 views

Google Spreadsheet protected cells

I have created my spreadsheet with protected cells scattered throughout the document in google docs. Now I want to duplicate the spreadsheet and have the protected cells in the new worksheet keep the ...
2
votes
1answer
379 views

Grouping columns in Google spreadsheets (and summarize them)

Lets say I have a table like this: A | B | C 1 | 4 | 3 Is it possible to group these columns together so that I can expand and collapse them with a specific formula. For example with SUM I would ...
2
votes
1answer
590 views

Automatically create a new row each day, on top of older rows

I am looking for a way to automatically create a new row on top of older rows each day. Inside of this row should be the current date.
2
votes
1answer
130 views

Data Validation Criteria

I am currently trying to change cell validations cell range in Google Spreadsheet base upon a cell's input. For instance, if A1 = 123 then have B1 (which is the data verification cell) pull from ...
2
votes
1answer
810 views

If cell equals a value then move row to different Google Spreadsheet

I've got a script that sorts a Google Spreadsheet when a value in a column is changed. I'd like to add to the script the following functionality: If the value for column E = "Complete" then the ...
2
votes
1answer
302 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
1answer
2k views

Google spreadsheet: named range built upon formula

I have a list of items (cells A1 to A7) that are counted in cell B2 (whose value is currently 7), B2's formula is something like =COUNTA(A1:A10000). That way if I add some value in cell A8, the count ...
2
votes
1answer
758 views

How to use a named column in a calculation based on a cell value in Google Spreadsheet

Playing with named ranges, I discovered it is possible to name a whole column (say "September") and use it in rows: =September*K4 What I'm trying to achieve now is that the value of the column ...
1
vote
1answer
22 views

Print text associated with a value

I have a Google Sheet that collects data and analyses any trends. What I'm trying to do is figure out how to output the text value associated with the numerical value. Example: Apples 7 ...
1
vote
1answer
16 views

Reverse (or repopulate) a Google Docs Form

I created a Google Docs form that collects (mostly) biographical and contact data from users. Now I would like to reverse the process and repopulate the form with each user's input, one page per ...
1
vote
1answer
32 views

Google sheet multiple column lookup

I have a table that looks like this: A | B | C ---|--------|--- 10 | Item x | 1 10 | Item y | 1 10 | Total | 2 20 | Item x | 4 20 | Item z | 5 20 | Total | 9 Now I would like to perform a ...
1
vote
1answer
39 views

Calling IMPORTRANGE inside of REGEXMATCH function?

I'm interested to know whether (and how) can i call IMPORTRANGE function inside of REGEXMATCH function. I want to get root domains from list of URL's and use REGEXMATCH to do this but want to get ...
1
vote
1answer
42 views

Associate cells to imported ones with importrange in Google Sheets

I have the following issue: I have table A with several columns and I use the following function to import some of data to table B: ...
1
vote
1answer
114 views

Google Docs invitation to edit on my Outlook email address

I have got an invitation to edit a Google doc on my outlook.com email address, but every time I click on the link, I get the message “You need permission”. I am signed in to my Gmail account as well ...
1
vote
1answer
196 views

Problem adding Image to hyperlink in Google Sheets

I want an image to be my hyperlink in Google sheets. Here is my code: =HYPERLINK("google.com/de", IMAGE("http://s5.favim.com/orig/69/hi-love-quote-start-Favim.com-658946.jpg")) The image shows up ...
0
votes
0answers
154 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
895 views

How to make Google Spreadsheets recognize data as numeric

I have the opposite of a fairly standard problem -- how do I force Google Spreadsheet to understand that a value is numeric? It seemed like using Format > Number should do the right thing, but it did ...
0
votes
0answers
431 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
283 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
159 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.
0
votes
0answers
381 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
499 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
2k views

Change value in one cell through a formula in another cell

I am trying to capture a timestamp for when a spreadsheet is first edited, and ONLY keep that first timestamp. However, NOW() updates each time a spreadsheet is edited. I found a working formula ...
-1
votes
0answers
5 views

I am having problems inserting text into a google sheet on my android device

I wish to insert text into a spreadsheet created on my PC,and saved to drive. I want to do this on my nexus 10, android 5.1, either in drive or google sheets
-1
votes
0answers
22 views

how can i deliminate a cell(s) with multiple values into new rows in google response sheet

I have created a Google form that has a lot of logic branching or condition based questions. However the "Then" part of conditioned based question allows a user to select multiple values based on the ...
-1
votes
0answers
57 views

How do I use JSON in Google Spreadsheets using an IP specific token?

I am trying to import data from https://api.heroesofnewerth.com/readme.php which only provides you with ip specific token. I found this import json script for google spreadsheets but I cannot get it ...