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

learn more… | top users | synonyms

0
votes
0answers
3 views

How to make my google spread sheet automaticaly calculate “days since”

I have spreadsheet with several columns and one of them is for date (column "D"). How to make the next column ("E") on open automatically to display the days passed from date in "D" until now?
0
votes
0answers
27 views

How to create a simple dialog form in Google Spreadsheets with GAS

The functionality that I am going for is this: Click on a menu option Interactive box comes up with 6 textboxes that correspond with a label each In two of those boxes, at most three, a number is ...
15
votes
6answers
24k views

Alternating colors for lines in Google docs spreadsheet

I have a shared Google spreadsheet where several users have already filled out parts. It would be useful to have alternately colored lines to facilitate correct placement of additional data. Is ...
2
votes
1answer
624 views

How to use a named column in a calculation based on a cell value in Google Spreadsheet

Playing with named ranges, I discovered it is possible to name a whole column (say "September") and use it in rows: =September*K4 What I'm trying to achieve now is that the value of the column ...
1
vote
1answer
273 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. ...
4
votes
1answer
2k views

Remove empty rows in Google Spreadsheets

Is there a way to in Google Spreadsheets to remove / delete empty rows? Ideally I'd like to be able to select the columns to check.. ie. Select columns D, E and remove all the empty rows from them or ...
1
vote
1answer
207 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 ...
2
votes
2answers
912 views

How can I set conditional formatting on particular cells that depend on another cell's value in Google Spreadsheets?

I would like to colour the background of a row in Google Spreadsheets: For example: If cell Dx = title 'To do' or 'title 'Done' then cells Fx to Nx are filled colour black. If cell Dx = title ...
1
vote
1answer
30 views

return name of range as string

I have a range that is named apple in Google Spreadsheets. I thought a method like getRangeName("apple") would exist. I want to get the names of many ranges and set them as the header for the ...
0
votes
1answer
749 views

Google spreadsheet validation data empty cell

So I'm struggling with the following: I have this formula (I know it's huge but it works so far) =IF(AND(COUNTIF(basictier1;"*"&A4&"*"));"T1 Basic"; IF ...
2
votes
1answer
300 views

Looping through the range of cells to test the dates

I am trying to create a function to check the dates in 'Dt' sheet and return Match or Not Match. It works fine with when I display my answer in MsgBox, but when I try to do it in one of the ...
0
votes
2answers
1k views

Counting unique values based on multiple columns

I am working in Google Spreadsheets and trying to do some counting that takes into consideration cell values across multiple cells in each row. Here's my table: |AUTHOR| |ARTICLE| ...
1
vote
2answers
40 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
1answer
76 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 ...
3
votes
0answers
29 views

How can I create a Google Spreadsheet whose name and cells auto-complete with cells completed on another sheet?

I'm using Google Spreadsheets to manage projects, and I'm not familiar with scripts or macros (though I'd really like to learn how to use it, so if you have any good tutorials or tips, let me know). ...
2
votes
1answer
51 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?
4
votes
2answers
437 views

Google Spreadsheets Conditional Formatting with color

I want to add a column of cells together only if the particular cell is colored green. Can I do this using conditional formatting on a google spreadsheet?
2
votes
1answer
19 views

Moving down the fixed page numbers in a Google spreadsheet

Can you move the page numbers on the left side of the screen down? I have a list that I need numbered, but the very top of the list (meaning the first column) has the categories for said list. So that ...
2
votes
2answers
63 views

Split text with Google spreadsheets

I have a Google spreadsheet with 1,500 cells containing items like: 1,300 users 2236 users, 12 companies 15000 users,153 companies <46,000 users, <200 companies I need to split this ...
1
vote
1answer
194 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 | ...
0
votes
1answer
38 views

Merging spreadsheets

I have three Google spreadsheets that I want to merge into a master spreadsheet, so that each new entry in any one of the three spreadsheets will automatically update the master. How can I do that ...
0
votes
1answer
239 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
800 views

Is it possible to add conditional formatting when number changes?

This is probably not possible but... I'm looking to update cells in a Google spreadsheet using the conditional formatting tool.(Changes to SERPs rankings) So when the number in a cell is changed, ...
3
votes
1answer
186 views

Google spreadsheet: Cannot select pre-selected date in Date picker

In a Google spreadsheet, when having a cell formatted as date, or with a data validation set on date, a date picker appears when double clicking this cell. If the cell is blank, the picker's date is ...
1
vote
1answer
2k views

Copying email addresses from Excel to Gmail into the BCC line

I used to be able to copy a column of email addresses (with a comma at the end of each) from Excel into the BCC line of a Gmail message. Now when I try to copy the column of emails, only the first ...
0
votes
1answer
96 views

Google spreadsheets Conditional Formating Formula

I am having trouble highlighting all cells in a column that do not contain the same text that is found in the first cell at the top of the column. I would like to accomplish this with a conditional ...
1
vote
1answer
63 views

Referencing a Range Name from a different spreadsheet

I would like to create a spreadsheet that contains name, phone number, address, email address of many individuals and I will define the data as a range name "Index". Then I would like to create a ...
2
votes
1answer
33 views

Google sheets: Individual time stamps for individual sheets in a spreadsheet containing multiple sheets

I am using the New Google Sheets, and I have created a "Master Document" that contains a multitude of sheets, with each expressing different kinds of data. I want a "Last modified" time stamp to ...
2
votes
0answers
24 views

How Can I Solve Error “Exceeded maximum execution time” in Google Spreadsheet?

I found a script which I really need (link) but it gives an error (Exceeded maximum execution time) generally. How can I solve this error? This is the script: function getTotalSum(cell) { var ...
2
votes
1answer
209 views

Monitor webpage changes using Google Docs

I want to monitor a webpage. The best solution I found was Google Docs (apart from feed43 which has limitations). I'm using the import HTML function in Google Spreadsheet which will update the cell ...
0
votes
1answer
380 views

Grouping Pivot Table Date Settings Into Weeks or Months in Google Spreadsheets

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, ...
2
votes
1answer
67 views

Altering the Sort Filter in Google Spreadsheets

I live in Australia and when I'm putting in dates, I place the date, followed by month then the year. However when I am filtering/sorting my spreadsheet it's coming up incorrectly. How do I edit ...
1
vote
1answer
26 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 ...
2
votes
1answer
336 views

Automatically create a new row each day, on top of older rows

I am looking for a way to automatically create a new row on top of older rows each day. Inside of this row should be the current date.
0
votes
1answer
34 views

Date format in Google spreadsheet is not correct

Whenever entering the date e.g. day-month-year, it automatically changes to month-day-year. I went into format-number-more formats-more date and time formats, and I changed it to day-month-year. And ...
5
votes
2answers
107 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
2answers
36 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 ...
2
votes
1answer
285 views

How can I make text flow out of a cell as it does in Excel?

If you enter a long bit of text into a cell in Microsoft's Excel the text flows out of the cell over the top of the adjacent cells. This doesn't happen by default in Google Spreadsheet - it flows ...
0
votes
1answer
29 views

Google Sheets, Suddenly decimalised some of my number entries

I've been using Google Sheets to create a record of car parts, entering: each part's serial number, the quantity of that particular part, the name of the part and the location where I'm ...
0
votes
1answer
74 views

Get a list of items missing from array in google spreadsheet

I have a spreadsheet where I'm using the trailing set of columns as a kind of foreign key; I'm trying to throw an error if someone enters a value that doesn't exist. I'm thinking one way to do this ...
0
votes
1answer
3k 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.
4
votes
2answers
3k views

Parsing Time data in Google Spreadsheets

I'm keeping cycling diary in a Google spreadsheet. Each entry has a value of Duration entered as ie. . Then I have the totals where duration is summarized as well. But whenever Some of the relevant ...
2
votes
1answer
404 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 ...
0
votes
1answer
99 views

Changing the A B C … column labels

The picture above shows what I am referring to. I'm looking for a way to change these " A, B, C, ..." labels to describe better the content below each. A would contain what date, B what length I ...
0
votes
1answer
45 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 ...
0
votes
2answers
1k views

Create a dropdown list of options from VLOOKUP

What I'd like to do is get a dropdown list of options from a VLOOKUP type function where I can select the value for the next lookup. Example Here the data I'm using for reference. Notice "AAA" ...
1
vote
1answer
64 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. ...
0
votes
1answer
95 views

How do I populate a cell in one spreadsheet to a cell in another spreadsheet in the same workbook in google docs?

In Google Spreadsheet, I have created a master spreadsheet that I complete with the amounts of the items needed. I would like those numbers to auto populate in each individual spreadsheet in the ...
1
vote
1answer
29 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
1answer
100 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 ...