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

learn more… | top users | synonyms (2)

1
vote
2answers
1k views

REGEXEXTRACT and French accents in Google Spreadsheets

I have the following formula: =REGEXEXTRACT(source!A2,"^[\w\s\À-ÿ]+") where source!A2="Ancien Marché Saint-Jacques (1125, rue Ontario Est)" and I would like to extract Ancien Marché Saint-...
2
votes
1answer
1k views

How to automatically open a created text document after it being created

I've used this script to create a Google Document (like word document) with Google Spreadsheet. But, when I do so, the new text document created from a template is placed in the default chosen folder. ...
7
votes
4answers
27k views

How to automatically insert a new row and retain functions/formulas from last row?

I have a table with cells that have functions/formulas, like this one: I need a script that creates a new row, copying with it the functions/formulas of the last used row. I find this script which ...
1
vote
1answer
861 views

Create New Google Spreadsheet with timestamp

I'm trying to create a new spreadsheet once we select the specific function from the custom menu item that's selected. I want the new spreadsheet to be "Sheet" & "Timestamp". Can anyone point me ...
2
votes
1answer
2k views

How to make a simple two column data chart in google spreadsheet? (simple case but doesn't seem to work)

I have a column with dates and a column with an amount of money. I just want to make the simplest chart possible, a line chart that shows money as a function of time, so I can see in what dates I tend ...
-1
votes
1answer
307 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
vote
0answers
476 views

How can I get a cell to change it's value based on another cell's color?

So I have three colors in column F, green, grey and red. What I want is for column G to display a number (1, 2, 3) depending on the color value of F. Is there a way to do this? Here is a link to a ...
1
vote
1answer
403 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 ...
6
votes
2answers
18k views

How to insert the current date into a Google Spreadsheet?

I've got a spreadsheet in Google Drive and one column is meant for the date the entry is made. Is there a button to do this? I'm aware of the functions =NOW() and =TODAY() but their description says "...
1
vote
0answers
164 views

Relative paths to other sheets inside a Google Spreadsheet

I'm trying to put our food recipe collection into a Google Spreadsheet. On the first page we have an index of all the foods. Each recipe is located on a separate sheet. We would like to be able to ...
5
votes
2answers
3k views

Multiple substitutions in a single text

Is it possible to write such a formula that it will substitute in a text value all occurrences of few values with their replacements? For example I would like to substitute all occurrences of aaa ...
1
vote
0answers
318 views

Google Sheets: Reference one sheet from another, where the user may not have view access to the referenced sheet

This is what I'd like to do: The public (even you!) would have view access to a particular Google sheet. It would draw data from another Google sheet, which you DO NOT have any access to. Using ...
2
votes
1answer
320 views

Chart with points in Google Spreadsheets

I have a Google Spreadsheet with a line chart. Despite the name "line chart", the data does not appear regularly spaced on the x-axis but according to a date column. (This shows up correctly, no need ...
-1
votes
1answer
3k 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
vote
1answer
87 views

How do I add a range of numbers positioned relative to its criteria?

I'd like to sum up some named values by referring to their names in a separate sheet. Can I do this with a single formula in the second sheet? Sheet 1: | A | 3 | | B | 5 | | C | 2 | | D | 4 |...
1
vote
0answers
83 views

Auto paste formula on form submission

I have searched and tried various solutions elsewhere but none seems to work for both conditions. I would like to have the formula: =IF($A2="Elementary", VLOOKUP($B2,'ELEM PRINCIPAL'!$B:$AA,7,false), ...
1
vote
1answer
438 views

How can I set the increment value for Google Spreadsheets to auto-increment?

I have a series of cells referencing other cells: | Row | a | b | col B shows | |-------------------------------| | 1 | 1 | =a2 | 2 | | 2 | 2 | =a4 | 4 | | 3 | ...
1
vote
1answer
197 views

Inserting rows and adding a cell reference

I'm trying to automate adding new rows if I'm on the last few rows of my sheet. It works, but since I'm also adding a cell reference to it, and checking the amount of free rows left using getMaxRows-...
0
votes
1answer
2k 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
1answer
215 views

How do I select a range programatically in Google Spreadsheets?

I have a spreadsheet like this: active date name 1 1-Jun-2013 Paul 1 4-Jun-2013 Sheela 1 8-Jun-2013 Paul 1 2-Jul-2013 Henrik 3-Jul-2013 Henrik 10-...
1
vote
1answer
2k views

Google Spreadsheets - how to add carriage returns to CSV downloads

In reference to this question: Google Spreadsheet downloaded as CSV comes out on 1 line? Is there anyway to have a downloaded Google Spreadsheet incorporate carriage returns and linefeeds such as if ...
1
vote
1answer
268 views

How Many Ways To Sort in Google Spreadsheets

When I'm working in a Google Spreadsheet, I always use the same routine to perform a sort. Are there more ways to sort, that lead to Rome?
4
votes
2answers
4k views

Paste format only in Google Spreadsheets with Chrome as the browser

I want a working keyboard shortcut for Google Spreadsheets, that lets me paste just the formatting. Google says the shortcut for copying just the formatting is Cmd+Alt+C, and pasting just the ...
17
votes
3answers
14k views

How to reverse the order of selected rows?

Is there an easy way to reverse the order of selected rows? (Or how about all rows, if that's easier.) Specifically, in this case, there is no column that could be used for sorting to get them in ...
0
votes
1answer
81 views

Copying data, based on the value in a cell

I've been trying to work out how to copy data from cells on a worksheet into another based upon the value in a cell. We have weekly data so for arguments sake Week 1 Week 2 Week 3 Week 4 ...
0
votes
0answers
28 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 ...
1
vote
2answers
346 views

Is there a way to speed up the auto-increment routine in Google Spreadsheets?

The solutions that have been provided for this question does the job, but when more people submit data at the same time, things go wrong. The same number is used in multiple rows. Is there a way to ...
5
votes
3answers
2k views

How to move to the last active row in a Google Spreadsheets

I am using a Google Form to insert data into a Google Spreadsheet. Is there a shortcut to move to the last row where data is entered?
2
votes
2answers
9k views

Conditional formatting using other cells in Google Docs

I could use some help with conditional formatting. I would like to format the first 6 cells in a row in a Google Docs file based on the following condition: If column A is not empty and column C is, ...
3
votes
2answers
2k views

How to add minutes and seconds only, in a Google Spreadsheet?

How can I add minutes and seconds only in a Google Spreadsheet? Example: I want to add 1201:01 to 390:35.
3
votes
1answer
3k views

Google Script for pulling gmail addresses into a spreadsheet

This Google Script goes through and finds the emails in my gmail which are in a label called "LabelToGet" and send me a link to the spreadsheet created with these emails. It works well, but I have ...
2
votes
1answer
839 views

Google Spreadsheet downloaded as CSV comes out on 1 line?

I have created a very simple spreadsheet of 3 columns with about 5 rows of data (as a test). When I download it as a CSV it comes out all in one line; I would expect each row to be a separate line. ...
3
votes
2answers
732 views

Google Spreadsheets sum only shown rows

Is it possible to sum a range of cells while ignoring rows which are not hidden? Thanks
0
votes
2answers
889 views

Spreadsheet to calculate weekly increase

I'm trying to create a spreadsheet with my weekly cardio and weight training average times and a total of time spent during an average visit. I would like the final column to display the in/decrease ...
2
votes
2answers
729 views

Allow trailing whitespaces in Google Spreadsheets

I was working on a Google Spreadsheet and I found that it does not allow more than one white space anywhere. Is there any option to stop auto trimming on text? I searched it but didn’t found any ...
1
vote
1answer
341 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 ...
3
votes
1answer
2k views

Why would this Google Spreadsheet onEdit script be so slow (2 secs to change cells, 3 secs to update)

I've put together a script for a spreadsheet based on what I have seen here and other sources that should provide a simple username and timestamp function. I have another spreadsheet that uses a very ...
1
vote
0answers
1k views

Google Apps Script UrlFetchApp and password protected pages

I'd like to be able to use Google Spreadsheets to login to my registart and automatically list into rows the current name server and email settings of all my sites, rather than use the heinously ...
1
vote
1answer
753 views

Google Spreadsheet Timestamp for columns B & D? [duplicate]

Found this script on one of the questions answered in the forum what I don't know enough to make it work. I would like it to time-stamp date and time in column B when they check in and then a separate ...
1
vote
1answer
2k views

INDEX-MATCH to get a MATCH and use that MATCH in a second INDEX-MATCH

I am trying moving from an access database to google spreadsheets. In my workbook, I have 3 google sheets: merged_data (merge all data) studentsANDemployers (studentID, student_name, employerID) ...
3
votes
1answer
1k views

Use specific currency symbol in Google Spreadsheets

'₴' is a currency sign used for the Ukrainian Hryvnia. It's in Unicode since 2004. I want to use it in spreadsheets as a sign for money values, but Google Spreadsheets doesn't understand it as a ...
2
votes
1answer
1k 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 ...
4
votes
1answer
9k views

Google SpreadSheets - Change value of a cell based on a drop menu of values on a different sheet

I want cells in a column, to have drop down menus. Then, the rest of the row needs to match the corresponding column set. Here's an example that explains what I want: Sheet 1: A1, a drop down menu ...
11
votes
4answers
14k views

How Do I Combine Columns In Google Spreadsheets? [duplicate]

I need to combine multiple columns into a single column, so: one four seven two five eight three six nine Becomes: one two three four five six seven eight nine
1
vote
2answers
434 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 ...
2
votes
1answer
254 views

google spreadsheets timesheet calculations

I have a timesheet that I use to log my time. It works fine if I log in and log out. It works at the end of the day but doesn't work in all configurations. For example, I want it to work if I only ...
-1
votes
1answer
95 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 "paste ...
0
votes
2answers
1k views

Total of column if adjacent cell is true while subtracting from another column

I have data like in the following table: +---+-----+-----+ | A | B | C | +---+-----+-----+ | 0 | 5 | 30 | | 1 | 0 | 30 | | 0 | 15 | 40 | | 1 | 0 | 40 | | 1 | 10 | 50 | +---+-----+----...
1
vote
1answer
1k views

How to zip two columns together in a Google Spreadsheet [duplicate]

For example columns are setup as: A | B ----- 1 | a 2 | b 3 | c 4 | d 5 | e I want to be able to make column C be like this: C --- 1 2 3 4 5 a b c d e via formula. The two columns ...
1
vote
3answers
5k views

Return a blank when cell reference is blank—Google Spreadsheet

I am using the following formula in a Google spreadsheet to calculate the number of days between two dates (dates are in columns G and AL). The problem is that some of the cells in col AL are blank, ...