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

learn more… | top users | synonyms (2)

1
vote
1answer
475 views

How can I speed up my Google Spreadsheet Script?

I am somewhat new to JavaScript and very new to using it in Google Spreadsheets. I have read that fewer calls to Google Spreadsheet API speeds things up, but I feel like I have as few as possible at ...
1
vote
1answer
747 views

Protect Google Spreadsheet formatting while allowing changes to data

I would like to protect the formatting of a cell (or a range of cells) in a Google Spreadsheet, but still allow changing the data in that (or those) cell(s). For example, I want to add a validation ...
1
vote
1answer
344 views

Duplicate check while creating Google Contact with Google Apps Script

I have the following code which creates Google Contacts from a Spreadsheet. The problem is whenever I run the code it creates contacts but has no functionality to check if the same Google Contact ...
1
vote
1answer
574 views

Changing an onEdit function to run onOpen

I have the function below (found online and adapted and it works) that is an on-edit function, but I want it to run/trigger when an import is done OR on open, as the data will not really be edited it ...
1
vote
1answer
166 views

Is it possible to use the importHTML function with a concatenated URL?

What I'm basically trying to do is use a URL previously made with the CONCATENATE function in an IMPORTHTML function. When I try importHTML (H1, "table", 0) Where H1 is the cell with the ...
1
vote
2answers
272 views

How can I make a Google spreadsheet Function reference one column's value and adjust it to a different Value?

I am trying to create a spreadsheet that will calculate varying sizes. I need it to reference a key where a letter is an established size such as H=1984, S=672, etc. so as that that column can be ...
1
vote
2answers
708 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é ...
1
vote
1answer
589 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 ...
1
vote
1answer
328 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
1k 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
188 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?
1
vote
2answers
278 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 ...
1
vote
1answer
1k 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) ...
1
vote
2answers
322 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 ...
1
vote
1answer
747 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
1answer
236 views

Google Spreadsheets Messes Up Comments When Sorted [duplicate]

I added comments to a bunch of cells. When I then sorted the cells, the comments did not follow their original cell and now was connected to the new cell. This is a massive problem and now my ...
1
vote
1answer
945 views

Google Spreadsheet Form Responses in to an already made sheet

I have a template form and matching spreadsheet that need to be copied multiple times. When I make copies of the two, the copies are not linked for the form responses to go to the newly copied ...
1
vote
1answer
282 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 = ...
1
vote
1answer
243 views

Google Spreadsheets Filtering data in another page and changing data in the original

I have a lot of data that I need to filter. I did it in another page and that's good... but now I need to put some values in that page... and transfer that data to the original. This is the formula ...
1
vote
1answer
293 views

How to have Google Spreadsheets automatically complete cells with previously used data

I'm using a Google Spreadsheet to fill in my mileage. Since I'm using many addresses more than once, I want to make the process of filling in easier by (like Excel or Open Office) having the ...
1
vote
1answer
399 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 ...
1
vote
3answers
2k views

Google spreadsheet connect with database and fetch data to cells

I have been wondering about this for a while. We are using those google spreadsheet a lot with my colleagues and the thing is that we always have to write down data that we already have in our MySQL ...
1
vote
1answer
319 views

Conditional formatting for dates in Google sheets

I work at a language school and I have a column giving the students expected arrival date. I want to set conditional formatting to: Highlight in red any date that is older than 1 week Highlight in ...
1
vote
1answer
8k views

How do I automatically update a cell in Google Spreadsheets to the most recently entered in the same row?

I am trying to have one column that will show the most recent thing i entered in the row. Example: I want B2 to be the same as D2 but once I enter something in E2 I want B2 to display that. And then ...
1
vote
1answer
271 views

Count related to date items in a Google spreadsheet

I have a spreadsheet that shows how many are still completing a task at two and 8 weeks. Col A Name Col B has Start a date Col C is the WeekNumber of the date from col A (Using WeekNumber Script) ...
1
vote
1answer
196 views

Finding and removing periods in Google Spreadsheet

I'm using a Google Spreadsheet and trying to create a formula to remove a period and anything that comes before it in a cell. For example: idontwantthis.iwantthis I have used this in the past: ...
1
vote
3answers
175 views

Google Spreadsheets: how to show the 10 most recent rows from another sheet's timestamp?

In one sheet A I have an ongoing number of rows where the 1st column is a timestamp in ascending order (more recent entries at the bottom). I'd like to have another sheet B where only the 10 most ...
1
vote
1answer
1k views

Sorting Google spreadsheet by month and day but not year

I made a Google spreadsheet with a list of birth dates, anniversaries, etc. that I would like to sort by when they occur in the year, not when they first happened. If you sort by the date normally, ...
1
vote
1answer
280 views

2 axis line chart in Google Spreadsheets

I've set up a Google Spreadsheet to compare one set of stats against another. The stats are for traffic vs. an action the actions only happen once a day and not every day were as the traffic has more ...
1
vote
3answers
7k views

How to auto increment a field in Google Spreadsheet

In my spreadsheet I have a column called S+ No. How to auto increment this for each row, like: S1,S2,S3,S4 In short how to make it dynamic.
1
vote
1answer
290 views

Google Docs time stamp?

The following code was almost exactly what I was looking for to timestamp the adjacent cell after being edited. However, I need to incorporate the currnet date as well as time. The code below gives a ...
1
vote
1answer
7k 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 ...
1
vote
1answer
1k views

Google spreadsheet sorting messes up cell comments

I'm running into this weird problem with Google spreadsheets: if the cells have comments on them and I sort the spreadsheet, the rows sort but the comments stay in the same position, and don't move ...
1
vote
1answer
134 views

Stop lines in GDocs chart overlapping/obscuring other lines

How can I stop lines in GDocs chart overlapping/obscuring other lines? See for example the green line in the graph below, which starts up high, butthen goes behind other lines such as the yellow one. ...
1
vote
1answer
1k views

How can I prepare a Sparkline graph (line/bar) in a Google spreadsheet?

How can I prepare a SPARKLINE graph (line/bar) in a google spreadsheet? With the google drive help it doesn't work for me. Reference: Google Drive Help
1
vote
1answer
2k views

How do you add a date created to Google Forms / Google Spreadsheets

We have a Google Spreadsheet It has a few columns Issue Raised By Date Raised We've turned this into a Google Forms which we want anyone in the business to be able to answer. The problem is ...
1
vote
1answer
1k views

Updating data validation for a group of cells

I have a spreadsheet where a particular group of cells has defined drop down values to choose from, using data validation rules to get the list from a seperate sheet. How do I update all of the cells ...
1
vote
1answer
664 views

Embed only cells from Google Spreadsheet and not application header

When I embed a Google spreadsheet, I get cells in my page (and this is good). But I get also the application header with toolbars (and this is bad for me). See a test here: ...
1
vote
1answer
532 views

How to search an embedded Google Spreadsheet in Google Sites?

I would like to know how I can make embedded spreadsheets searchable in Google Sites.
1
vote
1answer
936 views

Avoiding duplicates when adding cells in column one by one in Google Spreadsheets

How can I have a kind warning if I am adding a text to the cell which was already added somewhere in previous cells of the same column?
1
vote
2answers
637 views

Referencing a cell range relative to the bottom of a sheet

I am developing a "Daily Personal Inventory" spreadsheet based off a related Lifehacker article. I've successfully made a few modifications based on my own circumstances/goals, but there is one ...
1
vote
1answer
2k views

Nested IF statement on Google Spreadsheet, second part same as the first

I have a spreadsheet for my budget. Payments are either drawn from my bank or my Amex card and then my Amex card is drawn from my bank as well. So I add up all my monthly total like this: ...
1
vote
2answers
1k views

Editable Google Spreadsheet on Google site - assign username

So here is what I am trying to do: Have a Google site that has an embedded editable Google Spreadsheet on that allows end users (if they have been given permission) to edit the spreadsheet. Here is ...
1
vote
1answer
2k views

How can I make some data on a Google Spreadsheet auto-sorting using onOpen?

I was working with @W0lf here but I am unable to comment/continue the conversation anymore. I am trying to use autosort function onOpen but is not working: function onOpen(event) { var ss = ...
1
vote
1answer
858 views

Duplicating a set of columns with various widths within the same spreadsheet

I'm trying to duplicate a set of 5 columns multiple times on the same sheet. For example, column A is wide, columns B & E are medium width and Columns C & D are narrow. I want to duplicate ...
1
vote
1answer
363 views

How can I automate a series of actions, after receiving an email in GMail?

Here's what I want to do... When an email with a known subject, or from a known source, is viewed I want a button that will: Add data from the email (could just regex parse) to a new row in the ...
1
vote
1answer
2k views

Google docs spreadsheets: Copy data down into next set of blank cells, if any, for whole column?

I have some text that I've taken in from a pdf that isn't exactly synced up with the right lines as much as I'd like: I want to duplicate the column A and D values down into any empty spaces/rows. ...
1
vote
2answers
576 views

Google spreadsheet flextime

Being a (productive) geek, I want to keep track of the trend of my flextime. I keep a personal document of my hours worked in a Google Spreadsheet, having one column for hours worked every day. By ...
1
vote
1answer
5k views

Applying two filter functions in Google Spreadsheets

I am trying to apply two filter functions in Google Spreadsheets: Column (A) contains new data Column (B) contains filter data, i.e. cells with text that should not be included in column C Column (C) ...
1
vote
1answer
383 views

Google Docs Spreadsheet sections

I'm using Google Spreadsheets. I want to be able to have several different sections all on one spreadsheet: an income section with totals there an expense section with totals in it etc. How do ...