A productivity application from Google that allows you to create and edit worksheets

learn more… | top users | synonyms (2)

0
votes
1answer
71 views

Google spreadsheet, sort adds a bunch of rows

I have a function that sorts a table, unfortunately when I call my function it adds a bunch of empty rows at the bottom that I don't like. var kotlijst = SpreadsheetApp.getActiveSpreadsheet() ....
1
vote
2answers
711 views

Make a counter, that counts cell change

I have a cell, let us call it A1, that contains an IF function. Cell A1 changes between two types of text: Healthy Injured What I want is a counter in for example B1 that counts how many times A1 ...
1
vote
1answer
1k views

Google Sheets Print Filtered Rows

I use a Google-Sheet (sheet called "Data") for my payroll. In A1 I paste data from another spreadsheet that I use to store all the data for my business ( example value of job, location, date, ...
2
votes
1answer
568 views

MATCH Function does not work

MATCH function does not appear to work at all. Given the following data: $7,109.19 | $867.19 | -$5,374.81 | -$11,616.81 =MATCH(MAX(FILTER(B122:U122, B122:U122 < 0)),B122:U122) returns the error "...
3
votes
1answer
606 views

Google Spreadsheets: How to count items meeting criteria in multiple columns

In Google Spreadsheets I need to count instances of a certain value but only when they match either of two values in another column. So below I would ask for the count of all brown animals that are ...
1
vote
1answer
71 views

Custom Score for Spreadsheet

I have a Google form that has multiple choice answers. I want to score the document (the spreadsheet that is generated) by giving each answer a numerical value (not just right or wrong, but answer A=1 ...
0
votes
1answer
513 views

How to merge multiple rows in Google Docs?

I've got a Google Sheet with columns along the lines of: URL | Pageviews | Time on Page The same URL is sometimes on multiple rows and I'd like to merge the two other columns together so that the ...
0
votes
1answer
4k views

How can I use Google Spreadsheet to format Date in DD/MM/YYYY format?

First thing's first: my spreadsheet's locale is properly set to UK: If I paste in the following date: 30/09/2013 21:15 Then click Format > Number > Date time Nothing changes. I also can't ...
1
vote
1answer
742 views

How do I split multiple rows / insert a row below every existing row in Google Spreadsheets?

I use a spreadsheet to keep track of journeys in a lift-club. Each day has its own row, and the number of lifts given to a person will be 0, 1 or 2. I realized that the algorithm for the lift scheme ...
2
votes
2answers
97 views

How do I merge cell data into a new column?

A | B ----- 1 | a 2 | b 3 | c and I'd like to have a third column that merges the data like this: A | B | --------- 1 | 1, a 2 | 2, b 3 | 3, c currently I can kind of do this one row at a time ...
1
vote
4answers
353 views

Google Spreadsheets: How to drag down 'A1:A2', 'A1:A3', 'A1:A4'

Title basically says it all lets say every day (1 day = 1 row) a number is being added in column A I want to have column B show the total of these numbers. However, if I drag it down, it keeps ...
0
votes
2answers
3k views

Make first row in Google Spreadsheet column names

I cannot figure out how to turn the first row of a Google Spreadsheet into column names so that I can sort the spreadsheet by column without losing the variable names at the top of the spreadsheet. I ...
0
votes
0answers
1k views

Create a checkbox-type function that works on the Android Drive app for Google Spreadsheet?

How can I create a checkbox-type function that works on the Android Google Drive app for a Google Spreadsheet? I want to make a to-do list (groceries, trip prep, etc.) that the user can check "done" ...
1
vote
1answer
2k 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. ----------...
8
votes
4answers
963 views

Looking for an “isFormula” formula for Google Spreadsheets

Is there a function that will tell if a specific cell has a plain (manually entered) value or has a formula?
2
votes
1answer
573 views

How do I debug “The action you're trying to perform is causing a fatal error and cannot be performed” errors?

Since today, I'm no longer able to edit a specific Google Spreadsheet. Every time I try to make an edit, no matter which kind, an error message is displayed: The action you're trying to perform is ...
1
vote
1answer
64 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 ...
0
votes
1answer
187 views

Use sort function but filter results

I'm looking to use the =SORT function on some data, but I only want the first result with that name. Column A contains a Name, column B contains a level, and column C contains a date. I'm currently ...
3
votes
1answer
2k 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 ...
2
votes
1answer
1k views

Split content with multiple lines into multiple rows and columns in Google sheets

I like to know if it is possible to split an entire paragraph contained in a single cell, into multiple columns and paragraphs using formula's in Google sheets. This is what the text in the cell would ...
3
votes
4answers
1k views

Count the number of Fridays in a specific month

I would like to find the number of Fridays for a specific month via function in Google Spreadsheets. For example, for January 2014 the value would be 5 and for February 2014 the value would be 4. ...
3
votes
2answers
357 views

Cube rooting a negative number does not work?

I tried using this formula for cube rooting but it doesn't seem to work. =ROUND(C38^(1/3)) The value of C38 is -2. I'm getting the following error: Imaginary numbers are not supported in real ...
2
votes
2answers
3k views

How do I write or read Google-Sheets “comments” on mobile devices?

In a Google-Sheet called Field Schedules for Google web-apps at http://drive.google.com you can right click on a cell to open a context menu with the option to "Insert comment." Let's say for example ...
1
vote
0answers
46 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
237 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, ...
2
votes
1answer
2k views

CONCATENATE a string with an ArrayFormula

I have the following string in column H and I. H2="http://" I2="aaa" H3="http://" I3="bbb" I want to have a auto-generated J column, which results like: J2="http://aaa" J3="http://bbb" So I put ...
-1
votes
1answer
46 views

Help with a previous question you answered

I noticed this code from a thread I was reviewing as I needed the same functionality to provide a timestamp when a particular row is edited in a Google Spreadsheet; function onEdit() { var s = ...
1
vote
1answer
40 views

sharing only select rows

I'm trying to create a sheet with data compiled via application forms which are filled out by many people. I want to be able to edit that information and share portions of it with the people who fill ...
1
vote
1answer
734 views

Daily running average in Google Spreadsheets possible or not?

I work at a job wherein I receive tips. I have set up a sheet to keep track of the tips I make throughout the year. I have all the formulas set up that I want, save for one. I am trying to figure out ...
1
vote
2answers
51 views

Is there a more efficient formula to use than just copying and pasting?

D3 =(B3^3.0)-(B2^3.0) D4 =(B4^3.0)-(B3^3.0) D5 =(B5^3.0)-(B4^3.0) D6 =(B6^3.0)-(B5^3.0) D7 =(B7^3.0)-(B6^3.0) .... I rarely used Excel but since I don't have it installed on my computer I'm using ...
2
votes
1answer
1k views

Applying IF Statement to entire column

I currently have an IF statement that checks a cell in column B if it is blank. If it is blank it returns No in the corresponding A cell. If it does have a string, it returns Yes. I currently have ...
2
votes
2answers
280 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
1answer
528 views

Hide gridlines in Google Docs spreadsheets by default?

I general like to hide spreadsheet gridlines. Google Docs has them on by default when you create a new sheet. Is there any way to have them hidden by default?
2
votes
2answers
5k views

Does text overflow a Google Spreadsheet cell if the cell next to it is empty?

In Microsoft Office Excel a long text string is readable over multiple columns whenever the next (right) column is empty. Is that also possible within Google Spreadsheet?
0
votes
1answer
118 views

google spreadsheet filter, string equivalent

Columns D, E, and F store names that represent 2-3 person teams assigned to the name in column A. The teams are assigned to multiple names and thus appear in multiple rows. The teams' composition ...
2
votes
1answer
1k views

Google Apps Script - exceeded maximum execution time

I'm currently developing a new spreadsheet for my company to make one of the tasks we do on a weekly basis more easier - the way it works is data is imported into this spreadsheet and then the scripts ...
5
votes
2answers
1k views

Force cell to zero if result is below zero or N/A

I currently have the exact function set up here: Summing a column based on another column in Google Spreadsheet The number I'm getting from the query is almost always negative (a list of transactions)...
1
vote
2answers
35 views

Take data from a specific row

I'm making a form where people can enter in certain dimensional grades for a specific name. So each row of the spreadsheet will probably read something like: Name | Strength | Agility | Luck John | ...
1
vote
2answers
102 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.
2
votes
2answers
752 views

How to zero out cell if filtered sum is less than 0

I currently have the exact function set up here: Summing a column based on another column in Google Spreadsheet I would like to know how to make the value 0 if the real sum is less than 0. Any help? ...
1
vote
1answer
2k views

In Google Script, get the spreadsheet cell calling a custom function

In VBA for Excel, I can get the column of the cell making the call to a custom function like this: ThisCol = Application.Caller.Column What is the equivalent in Google Scripts? I've been trying to ...
2
votes
1answer
728 views

Arrayformula with dates before and after

Here is what my spreadsheet looks like I enter recurring weekly payments details in G,H,I,J & K (Name,Amount,Day of week, Start Date, End Date respectively). This arrayformula: =...
1
vote
2answers
177 views

Possible To Get Average Function For Accumulative Input?

I am trying to figure out an average function for my Google spreadsheet, but I am not sure if it is possible, see screenshot: I could not fit all the spreadsheet in the pic, but the column A goes ...
1
vote
2answers
2k 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 ...
4
votes
1answer
1k views

How to convert 1.33 hours to 1:20 (hours:minutes)?

How to add minutes in Google Spreadsheet? I've got a Google Spreadsheet that looks roughly like this: min | min | min | min | min | total min | total time 20 | 20 | 20 | 20 | 20 | 80 ...
1
vote
1answer
1k 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 ...
2
votes
1answer
277 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?
1
vote
1answer
289 views

Time Triggered Script to Change Cell Contents

What I want to do is for example: A time will be manually entered into a cell say D3, when it is 20 minutes before this I want cell D1 to change to "20 MIN", WHEN IT IS 5 minutes before I want to ...
1
vote
2answers
107 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
0answers
36 views

'New Row' Spreadsheet List function

I have set up a Google Docs Spreadsheet to use as a job booking in system for my design agency. I'd like to have this where the newest jobs are at the top, but at the very top is a blank row, where a ...