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

learn more… | top users | synonyms (1)

0
votes
0answers
117 views

Prevent sorting within a strict subset of the columns

For Google Docs Spreadsheets, is there any way to prevent sorting from ever being carried out in just a strict subset of the columns, so that data in some of the columns remains stationary while data ...
0
votes
0answers
30 views

get editor name, time stamp, and date after every editing

I have a spreadsheet, on that every cell i want the name of user, new time and date on which the editing done. the formate will be "date, time stamp, and update by" Kindly suggest
0
votes
2answers
2k views

Counting unique values based on multiple columns

I am working in Google Spreadsheets and trying to do some counting that takes into consideration cell values across multiple cells in each row. Here's my table: |AUTHOR| |ARTICLE| ...
0
votes
0answers
71 views

Google Apps Script: how to get data from another sheet from the active spreadsheet? [duplicate]

I have a spreadsheet with several sheets, like this: If I want to use the active sheet in the active spreadsheet, I use this method: var s = SpreadsheetApp.getActiveSheet(); How do I use another ...
0
votes
1answer
38 views

Prevent the cell from expanding to the size of cell contents in a Google Docs spreadsheet every time I open the doc?

I know how to "Wrap text" to make this happen, but my issue is I am having to do this EVERY time I open a spreadsheet in Google Docs. It is a quick couple of clicks, but it adds up. Is there a way to ...
0
votes
0answers
173 views

Filtering data based on dropdowns in Google Forms

Is it possible for me to have a choose from a list question in a Google Form and have two dropdown boxes? Such that, the list items in the second dropdown box will depend on the item chosen in the ...
0
votes
0answers
86 views

Sending emails to specified end users

I'm trying to write a script to send emails from a google spreadsheet. My specifications are: Send email upon form submit Only send to email address listed on form I have written a sendEmail ...
0
votes
0answers
78 views

How to automatically “start a new paragraph”\“full stop” in a cell ?

I have some problem to set the automatic start of a new line in a cell of a Google spreadsheet without press CTRL + every time that I want a new line in a cell. I have try to do as specify in this ...
0
votes
0answers
46 views

Using a dynamic OFFSET & ISBLANK() function

I have a spreadsheet I'm working on that we use to run large corporate events. Each segment length has a length as well as corresponding start time. I want each cell in the time column to look above ...
0
votes
0answers
137 views

Use of importdata with arrayformula

I’m using importdata to retrieve Yahoo stock information, which works fine on indivdual rows, but when combined with arrayformula to fill down the page when additional symbols are added does not ...
0
votes
1answer
77 views

Google Spreadsheets Validation list with Label

Thanks in advance. I have just started using Google Spreadsheets so am very new to it's ways! So far it looks incredibly powerful! I am using some data in a sheet called Jobs as a reference to ...
0
votes
2answers
568 views

Show data from one sheet on another if date is today

I have a list of people responsible for data verification that are changing every day. The schedule is on one sheet. And data verification is on another. What I need is to show only responsible ...
0
votes
0answers
59 views

Link to a point in time snapshot from a Google Document revision history? [duplicate]

Is it possible to get a link to a Google Document that is a read-only "point in time" snapshot of the document?
0
votes
1answer
160 views

Google Spreadsheets (Query) - Conditional Formula

We're trying to create a query based off whether or not specific "Categories" have been selected. Here's an example of the categories they would select: Channels Arts & Entertainment ...
0
votes
0answers
50 views

A simple spreadsheet sorting

In a Google Spreadsheet I have different groups of cells in one column to auto-sort. All cells in this column have same pattern of data, all datum have it's own cell and it's needed to be sorted into ...
0
votes
0answers
27 views

How to have function input row/cell automatically update in response to new data? [duplicate]

I apply a function, such as SUM(A10:A20) to a set of data. When I give A21 a value I would like SUM(A10:A20) to automatically update to SUM(A11:A21), "following" the last X number of cells in a ...
0
votes
0answers
186 views

How do I reference only the elements of a multi-column range that meet particular conditions?

I have a spreadsheet made up of several individual sheets: one sheet for each category of product and one sheet designed to be a "global view." In each sheet is a 3-column range of variable length ...
0
votes
1answer
749 views

Getting SUM function to work in Google Spreadsheets

I'm trying to get something like this. These are all in minutes I guess it goes that way when I type them like this. Number Time After Work TOTAL 1 1:52 2:00 ...
0
votes
0answers
25 views

How to return the latest date in Google Docs Spreadsheets? [duplicate]

I would like to return the latest date from a number of dates in Google Docs Spreadsheets. In Excel MAX(E2:L2) would give me the latest date, but Google Docs just gives me a number: 40505 instead ...
0
votes
1answer
194 views

Creating a class roster in Google Spreadsheets from a split result

A lecturer from the European School of Physiotherapy in Amsterdam stumbled on a particular script I prepared, hoping it would resolve a problem he had. After having had a little chit chat, it turned ...
0
votes
1answer
218 views

Google spreadsheet cell outcome dependent on another cell’s range

Example: column A1 is $35.00. I want column B1 to be a percentage markup value dependent on the value in A1 (i.e.: 75%). So if A1 is between $1 and $10, B1 = 75%; if between $11 and $20, B1 = 60% and ...
0
votes
0answers
427 views

How to use Google Scripts w/ spreadsheet and jotform to auto sort so the newest entry is always listed on the top row?

I'm trying to setup a form and spreadsheet database to track inventory on a daily basis at a remote location. The idea is that the person at the remote location can update our stock via a simple ...
0
votes
0answers
39 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
1answer
114 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
147 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
1answer
193 views

Google spreadsheet multiple auto-sorting

In a Google Spreadsheet I have different group of cells to auto-sort ascending i.e. table range a3:c16 columntosortby = 2 table range d18:f31 columntosortby = 5 table range g33:i46 columntosortby = ...
0
votes
1answer
128 views

Google Spreedsheet, Auto sort in categories

So I want to sort my Spreadsheet on Google but it remain in the Categories that it's laid out. I can get to it sort double columns but the categories get messed up as they move away from where they ...
0
votes
1answer
247 views

IMPORTRANGE formula query to query data in another file

Is it possible to create two different files where in the first I put the data and in the second the references query? I used IMPORTRANGE but this method gives me "=CONTINUE(A1; 2; 1)"... I want to ...
0
votes
0answers
727 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
2answers
2k views

Google Spreadsheets formula question: do not include cell in a formula if blank

I am a music teacher and I use the following formula to calculate my students performance grades: =100-SUM(F3-5)*-7 How can I change the formula so it only calculates a grade if there is data in ...
0
votes
0answers
269 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
154 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
329 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
443 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
16 views

Google Spreadsheet: reference seperate spreadsheet [duplicate]

Possible Duplicate: How do I link a cell in Google Spreadsheets to a cell in another document? Is it possible with a Google Spreadsheet to reference a cell to another spreadsheet using a ...
0
votes
1answer
6k views

How do I use the INDEX or OFFSET functions in Google Spreadsheets?

I have my spreadsheet set up as follows: first 10 columns full of descriptive data followed by 24 columns of month data (2 columns per month). The last 24 columns are static and the values are ...
0
votes
1answer
166 views

Automatically add values before and after Google spreadsheet

I have a library of flags online and would like to have a client-foolproof solution for adding flags. Right now my function looks like this: =image("http://www.website.com/flags/us.png", 3) But I ...
0
votes
1answer
509 views

Query multiple Google spreadsheets

I have the following sheets: ListA ListB ListC Note: at each sheet I have a column which contains YES or NO. How do I query all my lists (spreadsheets) where myBooleanColumn equals to YES/NO?
0
votes
3answers
3k views

Protect entire column of a Google Docs spreadsheet

I select a column (e.g. Sheet1!A:A) to be protected, then in the right pane I edit the settings (name, permissions), and finally I click Done What happens: The protected range then switches to ...
0
votes
1answer
815 views

Google spreadsheet validation data empty cell

So I'm struggling with the following: I have this formula (I know it's huge but it works so far) =IF(AND(COUNTIF(basictier1;"*"&A4&"*"));"T1 Basic"; IF ...
0
votes
2answers
1k views

Create a dropdown list of options from VLOOKUP

What I'd like to do is get a dropdown list of options from a VLOOKUP type function where I can select the value for the next lookup. Example Here the data I'm using for reference. Notice "AAA" ...
0
votes
0answers
1k 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 ...
0
votes
1answer
865 views

Google Spreadsheet Change X and Y Axis

I am trying to graph the temperature of a substance versus the time the substance has been heated. My data is as follows: A | B Time (Minutes) | Temperature (ºC) 0 ...
0
votes
1answer
81 views

Google Spreadsheet Paste

I need to copy and paste content from one sheet to another sheet within the same file, keeping formulas where there are formulas, and keeping data where there is just data. I tested every past ...
-1
votes
1answer
662 views

Writing a spreadsheet script

The above link is a picture of the Google Docs spreadsheet that I am working on. Basically it is a sale ticket for a small appliance parts store. I need to be able to select a range of rows and ...
-1
votes
1answer
171 views

Mileage Calculator Google Spreadsheet

I am trying to calculate miles driven for two different companies. I want to make a cell that will add up only data from Company A, and a cell that will add up data from only Company B. EX: COMPANY ...
-1
votes
1answer
952 views

Insert Text Google Spreadsheet [closed]

How do you enter text boxes in a google doc spread sheet? In google doc excel spreadsheet, I want to skip a few spaces between words. Google doc allows me to insert spaces, but when I am finished ...
-1
votes
1answer
1k views

Set the headers in a Google Drive spreadsheet to move on screen as I scroll down

How do I set the headers in a Google Drive spreadsheet to move on screen as I scroll down the spreadsheet?
-1
votes
1answer
25 views

How can I calculate compound interest with different interest rates?

Assume that I have the following different interest rates for different periods. I would like to calculate a compound interest rate based on these rates for lets say 200 periods. How can I do it ...
-1
votes
1answer
89 views

Google Spreadsheet: add automatically the same formula in each new row of a column. Also with “SUM”

I have this sheet: https://docs.google.com/spreadsheets/d/10YVUO2a-XftaCOX73tOiOwQfu0t80iKPJjQrRDiht1A/edit?usp=sharing In the column "E" I need the same operation as ARRAYFORMULA in column C and D. ...