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

learn more… | top users | synonyms (1)

1
vote
1answer
66 views

How to send cell as argument for function?

I am trying to write a custom function for Google spreadsheets that checks the formatting of a given cell and acts accordingly. I know that I can give a string as argument and get it to work but then ...
1
vote
1answer
43 views

“Go to” search in google spreadsheet

I want to have a search feature at the top of my spreadsheet that will actually take me to a row, on the same sheet, based on searching a column for the matching information. So, I want any user to ...
1
vote
0answers
84 views

Can I make a Google spreadsheet deploy as a web application?

Well, this is what I'm planning to do: my spreadsheet looks almost done to me (a few changes here and there of course, but that'll continue forever). I want to deploy it as a web-app and then who ...
1
vote
1answer
101 views

Google Spreadsheet SUMIF Using Two Criteria

I've read through the forums but found nothing that solves my problem. My apologies if the answer is here somewhere and I've missed it. I have a Google spreadsheet with multiple pages, each tracking ...
1
vote
0answers
33 views

How does Google know that I am not a human?

Over on stackoverflow I asked a question regarding accessing google spreadsheets with curl, which doesn't seem to be possible any more, even when setting a valid user agent string. My question arising ...
1
vote
1answer
55 views

Query MAX group by

I'm trying to Query in only the most recent entries of each part number. I can usually figure this stuff out but cannot figure out why it only returns the (date) and not the (part number) and (most ...
1
vote
1answer
45 views

Google Sheet sum column by referencing column header

In Google Spreadsheet, I would like to find a column using a variable matching the column header and sum the column if the match is found. Example: ------------------- Ref | X | Y | z | ...
1
vote
1answer
74 views

Add new row while keeping functions in new Google Spreadsheets

In the new Google Spreadsheets, I'm trying to make a simple spreadsheet which will assign points to my salesmen regarding some actions they complete. I would like to be able to add a new row below ...
1
vote
0answers
23 views

Google Spreadsheet Exporting Results

First of all, I have a Survey Form (JotForm) and I export the statistics in Google Spreadsheet. So I have on each column my specific field that was completed in my Survey. What I would like to do is ...
1
vote
1answer
36 views

Button in column C in each row

I have a spreadsheet with three columns and lots of rows. Column A has a numerical ID Column B is empty Column C is empty I want to have a button in each row in column C. When pressed, it should ...
1
vote
1answer
87 views

Create chart from single column in Google Spreadsheets

I used a survey to collect data about people's opinion. The question is answered using a check-box (Yes/No). I would like to visualize the results using charts. How can I do that using one column? ...
1
vote
0answers
37 views

Need ideas for Google Spreadsheet and Indexing Columns

I have a tough one here. I have a Google form where the employees enter the hours they spent working on particular cases throughout the day. The employees often work on up to for cases a day. So there ...
1
vote
0answers
28 views

Google Spreadsheet notification emails

I have a spreadsheet whereby a user puts in their email address in column A and I populate columns B & C with data. What I would like is for the user in column A to be notified when data is put ...
1
vote
1answer
930 views

Get cell row and column index in Google Spreadsheet

I have spreadsheet with two sheets inside. The name of the first sheet is "fr" and the name of the second sheet "cql". Now the first sheet contains data as the picture given below. And the second ...
1
vote
2answers
195 views

Dynamic generation of cell list / array from range value in Google Spreadsheets

I want to create an array/ a list of cells (i don't know the exactly terminology), in rows or columns form, covering the range between 2 numbers Fox example, I have 2 cells, A1 = 3; B1 = 10 I want ...
1
vote
0answers
88 views

Summing Duration Format with QUERY

I want to sum the begin and end with the QUERY function, to be able to subtract them, see table: day | begin | end | -----------------------------------| monday | 9:00:00 | ...
1
vote
1answer
99 views

Using cell reference with COUNTIFS formula

I am trying to get this formula to work =countifs(J6:J365, "=David & Victor", K6:K365, "=g3") where G3 is a date value (e.g., 02/24/14). I am trying to count the instances in my spreadsheet ...
1
vote
0answers
62 views

Way to automate collection of goo.gl data into Google Spreadsheet?

Is there a way to automatically collect analytics data from goo.gl into Google Spreadsheets or Excel? Specifically I am looking to automatically bring the total clicks from my links into a spreadsheet ...
1
vote
1answer
94 views

Make dynamic array blank based on adjacent values in Google Spreadsheets

I'm attempting to indicate certain months that fall between the end of one period and the beginning of another. I have the months of the year in column C: values 1 through 12. It's a running snapshot ...
1
vote
1answer
45 views

SUMIF not working

I have values in column L and I'd like to SUM what is in column B IF the value in L is greater than 1600 Here is my formula: =SUMIF(L2:L,">1600",B2:B) I'm getting a result of 0 in the cell ...
1
vote
2answers
714 views

Google Spreadsheet; Function to Search a Sheet for String and Return Value of Next Column

Here is what I have so far. it will: Search for keyword in my other sheet (JSON) When it finds the keyword (modname) it returns the row # The keyword is on the A column. What I want is for a ...
1
vote
1answer
845 views

How can I group a pivot table into weeks or months?

In Microsoft Excel, in a pivot table, you can right click on the dates - while within the pivot table, on a date and select group (from the drop down menu) - then you can choose different groupings, ...
1
vote
1answer
88 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: ...
1
vote
0answers
84 views

Creating email price alerts for online products with Google Spreadsheets?

I'm trying to figure out a way to get an email or text notification when an item's price drops below a certain point. I've tried using ImportHTML and ImportXML with Google Spreadsheets but can't seem ...
1
vote
1answer
465 views

How to search multiple columns in Google Spreadsheet and return values in other columns?

I have two spreadsheets and would like to enter a value into cell A1, have it check multiple columns in a spreadsheet named 'data' and output information from other columns if it's a match. ...
1
vote
1answer
38 views

Group by and ordering inside a group in Google Spreadsheets

I have the following data in a Google Spreadsheet: 1 shiplu rice 2 sharmin rice 3 sharmin fast food 4 sharmin salad 5 rafiq burger 6 nazia noodles 7 rafiq salad 8 rafiq ...
1
vote
0answers
41 views

Google Drive: Pasting Spreadsheet Into Doc Woe's

I'm trying to paste a few cells from my spreadsheet into my document. The problem is that the spreadsheet never fits correctly into the document, even though all the cells are smaller than the space ...
1
vote
0answers
109 views

SUM(SUMIFS Array in Google Spreadsheet

Now that Google Spreadsheets support SUMIFS I'm trying to import an expense tracking spreadsheet but I've run into a problem with a formula. Here is the current code: =SUM(SUMIFS('RE ...
1
vote
0answers
53 views

Simultaneously sort multiple ranges on a single sheet in varying orders

I am trying to find a way using a script if possible (or formula) that will allow me to reduce the number of operations that I have perform to sort data in a particular google spreadsheet. Currently, ...
1
vote
1answer
116 views

onEdit only updates top row after pasting (editing) multiple rows

I'm using a Google Spreadsheet and have a script that updates the "last email" column with a date stamp when an employee enters an email address into the prior column. The problem occurs when my ...
1
vote
2answers
51 views

How to display a character when a value in the same row is the highest value in its column?

I have the following example table: A | B a | 5 b | 3 c | 1 d | 9 <=== expected result e | 0 f | 4 So it should display d as in the other column 9 is the highest value.
1
vote
2answers
159 views

In Google Spreadsheets, how do you iterate over a cell range and use the index counter?

I have a table in which I have a list of amounts, each belonging to one of 15 categories A B 1 cat | amount _____|________ 2 1 | 12 3 1 | 4 4 4 | 18,90 5 ...
1
vote
0answers
255 views

Export CSV from a Google Spreadsheet page from command-line

I'm using a Google Spreadsheet document to configure a data-driven program. The program consumes a CSV file, which now I have to export manually from the document. It is rather inconvenient, as ...
1
vote
2answers
78 views

Google Spreadsheet Formula relating to dates

I need a formula that will do the following: If cells in columns L, O or Q have a date of today or earlier then cell B must show the text "CHECK".
1
vote
1answer
278 views

Having an issue with horizontal scrolling in Google Spreadsheets

When I try to scroll horizontally in Google Spreadsheets using the track pad, nothing happens. However, if I scroll vertically first, I can then scroll horizontally if I don't pick up my fingers from ...
1
vote
1answer
125 views

How to get total count of matching counts from different, but matchingly named sheets in same spreadsheet?

I have an inventory spreadsheet with each chest having its own sheet with the sheet numbered and each of those sheets have identical syntax. Rows 1-4 are protected by the separator line, so data ...
1
vote
0answers
91 views

Entering time data quickly using code for a specific range of cells

What API code do I use if I want to quickly enter 24 hour times (without entering the colon and still retaining time formatting) for a certain range of cells? I know the following code works for ...
1
vote
1answer
238 views

Count non-blank cells based on arrayformula in Google Spreadsheets

I am trying to get a count of all non-blank cells in a column that belong to a certain market. The formula I'm using (and that is not working) is: =ARRAYFORMULA(SUM(('GR Live Campaign ...
1
vote
2answers
786 views

Script to automatically change text value

In GDocs under Tools > Preferences, I can define automatic corrections, so that if I type l*, it spells low, h* -> high, etc. In Google Spreadsheet there is nothing like that. Can I do that with ...
1
vote
2answers
68 views

Google Spreadsheet - periodically stamp sheet contents

As the title, is there a way to have a "print" of the content of a sheet periodically? i.a., I'd like to have a trigger that every Monday at 08.15 A.M. copy the contents of a group of a cell of a ...
1
vote
1answer
526 views

Multiple views of master spreadsheet that allow editing of master data

I have a monster spreadsheet with lots of contacts in it. Each contact is a row, with different attributes as columns (first_name, last_name, number, etc.). There are a hundreds columns—i.e., too many ...
1
vote
1answer
109 views

Pulling collumn from sheet 2 & importing into another workbook [duplicate]

So I need to find the formula to pull a column out of one page of my Google Docs spreadsheet and insert it into a separate workbook. Here are some more details: all rows from column C (part number) ...
1
vote
0answers
186 views

Repeat an FILTER or ARRAYFORMULA n times in Google Spreadsheets?

I would like to repeat an ARRAYFORMULA or FILTER n times. Let's assume I have A 1 a 2 b 3 c Now I set =ARRAYFORMULA(A1:A3) and I get the same output. But now I want it to repeat n times, ...
1
vote
1answer
43 views

How to COUNTIF cells are years in Google Spreadsheet?

I have several dates in let's say A1:A with this syntax: dd/mm/yyyy and I would like to COUNTIF the cells are years. I had this first: =COUNTA(UNIQUE(YEAR(A1:A))). But that didn't work.
1
vote
1answer
169 views

Google docs spreadsheet - limit values to other ranges

I'm trying to create a docs spreadsheet that defines various objects, and these objects sometimes reference each other (equivalent to SQL foreign key). Is there a way that I can limit the values of a ...
1
vote
0answers
108 views

Formatting a Google Docs spreadsheet (sorting multiple entries, linking tabs, incrementing numbers)

So, I'm trying to work with this spreadsheet I've created. I was wondering … is there a way to add a button of some kind, so that people can choose how each group is sorted? So they could sort by ...
1
vote
1answer
86 views

Counting number of cells with certain word if another cell in that row is not blank - Google Sheets

I have 2 columns, machine type and install date. What I want to do is count the number of machines per type once they are installed. So if there were 3 "Machinetype1" installed 11/29/13, I want ...
1
vote
1answer
88 views

Sorting by the value of the formula in a Google spreadsheet

I want to sort data by the value of the formula. The data is generated by a formula. I want to sort the data (and related rows) by the value of the formula output not the formula. I cannot do this. ...
1
vote
0answers
26 views

Formula syntax to use a cell data as reference to another cell in a Google spreadsheet [duplicate]

Say I have the cell A1 which contains the number "13". I want to use that number to refer to a specific cell doing something like ='Items'!C"A1" which would mean ='Items'!C13. What is the proper way ...
1
vote
0answers
42 views

Adding and deleting sheets in Google Spreadsheets

How can I restrict users from adding new and deleting existing sheets in Google Spreadsheets? Only the owner of the spreadsheet should be able to do that. Other users should not be able to do that.