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

learn more… | top users | synonyms (1)

1
vote
1answer
33 views

How can I use a single column as a normalized data point with multiple choices in Google Sheets?

I find I often want to have a column that is meant to be one or more choices from a fixed set. E.g. a Codebase field in a dev roadmap spreadsheet, which might have choices like {DB, API, JS, CSS, ...
1
vote
0answers
111 views

Can I fill specific cells in my spreadsheet when submitting a Google Form?

I have a Google Spreadsheet that contains a list of dates, and empty cells. For a variety of reasons, I'd like to be able to have people add fill out a Google Form where they select a date, and fill ...
1
vote
1answer
182 views

How can I sum a row in Google Spreadsheet so that the formula isn't overwritten when Google Forms adds a new row?

I'm using Google Forms to collect some data from students. Each time a new student submits a form, the data (4 columns worth) is added to a new row in a Google Spreadsheets, bumping anything ...
1
vote
1answer
63 views

Start new line automatically when otherwise content would overflow cell [duplicate]

I don't know when Google changed the version of Spreadsheets. Right now when the cell's text is longer than the cell width the display of this line is no longer what it used to be. I want the display ...
1
vote
2answers
99 views

Import current price from website to spreadsheet

As you can probably gather from the title, the goal is to plug the current price of this product into a spreadsheet. Perhaps I'm over-complicating things, but there must be an easy way to do this. ...
1
vote
0answers
37 views

How to return a value from another cell / a formula for an IF function in Google Spreadsheet? [closed]

I tried to use the following =IF(AD23<0,-1,AB22), but I get an error message. AB22 and AD23 are number values. Is it not possible to put values from other cells as a return value? In fact, ideally ...
1
vote
1answer
14 views

How to get formulas to do the calculations

I have a column from A1:A398 in a Google spreadsheet. Each cell either has an "f" or is blank. I want to count how many of each there are. In row 399, 400 and 401 I put the following formulas ...
1
vote
0answers
127 views

Retrieve data from another sheet based on key value without empty rows

This seems pretty straight forward, and I've seen some answers that come close, but I'm having trouble nailing down one specific requirement. ...
1
vote
0answers
71 views

Trello API: How to remove a member from an organization using Google Apps Script (GAS)

In a Google Spreadsheet, I have a list of Trello usernames that I want to remove from my Trello organization. How can I use the Trello API to remove all these members from my organization? I found ...
1
vote
1answer
51 views

How to parse a date and time in the format 2012-12-12T00:00:00+00:00?

I have a CSV file with dates in the following format: 2012-06-20T00:00:00+00:00 Is it possible to parse a date or date and time in this format? The goal is to turn it into a date and time that ...
1
vote
1answer
30 views

Is it possible to define user permissions on a sheet basis in Google spreadsheet?

I have a Google spreadsheet with 10 sheets. Is it possible to define user permissions on a sheet basis in Google spreadsheet? For example, on sheet 1, user X can edit but user Y can only view.
1
vote
0answers
29 views

Google Sheets Cells don't calculate when printed or viewing as PDF

Workbook: Very large workbook with multiple tabs of data and multiple tabs of reports using sumproduct, query and filter formulas. Payroll tab is a reflection of our master database so i'm not dead ...
1
vote
0answers
35 views

Send email from Google Spreadsheet to adress in column

From an existing Google Spreadsheet; every time a value is added in column M(x), I would like to send an email with a specified text to the address listed in column F(x) from the same row x. Which ...
1
vote
0answers
101 views

Yet Another Mail Merge - sending to multiple recipients

I'm required to send a parametrized mail message to multiple recipients, based on values in a Google spreadsheet. I've followed the instructions in this guide on how to use Yet Another Mail Merge. ...
1
vote
1answer
812 views

Send an email with attachment using Google Apps Script

I have a Google Spreadsheet with a list of emails. I want to build a routine that send email automatically to those email addresses. I also want to attach a PDF to this email. The PDF file is located ...
1
vote
1answer
126 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
0answers
95 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
66 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
85 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
24 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
51 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
0answers
44 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
29 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
2k 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
263 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
1answer
246 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
89 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
122 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
363 views

How do I reference a cell string to use as a note in another cell?

I'm simply looking for how to link one cell's data into another cell as a note. What I have here simply errors telling me I do not have permission to setNote. :/ function noteSetter() { var ss = ...
1
vote
1answer
60 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
1k 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
1k 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
171 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
91 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
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
145 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
78 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
149 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
62 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
311 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
342 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
86 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
168 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
113 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
316 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
1k 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
74 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
804 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
134 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
1answer
231 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, ...