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

learn more… | top users | synonyms (2)

1
vote
1answer
1k 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 ...
3
votes
1answer
318 views

Monitor webpage changes using Google Spreadsheets

I want to monitor a web page. The best solution I found was Google Spreadsheets (apart from feed43 which has limitations). I'm using the importHTML function in Google Spreadsheet which will update ...
4
votes
2answers
817 views

Google Spreadsheet Formula Applied To New Row

If I have a formula (of any kind) spanning A1:A30 (just as an example), when I right click and insert a new row, it doesn't have the same formula. Numbers (and I believe Excel) allows this, is there ...
14
votes
4answers
17k views

Display Sheet Name in Google Spreadsheet

Is there any way to display a sheet name as the result of a function in a google doc spreadsheet (exactly like this question, except in gspread)?
1
vote
1answer
215 views

Problem adding Image to hyperlink in Google Sheets

I want an image to be my hyperlink in Google sheets. Here is my code: =HYPERLINK("google.com/de", IMAGE("http://s5.favim.com/orig/69/hi-love-quote-start-Favim.com-658946.jpg")) The image shows up ...
0
votes
1answer
2k views

How to format the date in this Google Docs script

I've come across this rank checking script. I'm not sure exactly where I found it but it's built on Google Docs and a script which automates the rank checking process. I understand a bit of coding ...
2
votes
2answers
3k views

How do I create a multiple choice question in Google Forms based on spreadsheet data?

I am making a Google Form for evaluations. I will have a multiple choice question in there and the available options have to come from a list of items, say on a spreadsheet or a text document. I have ...
3
votes
2answers
1k views

Protect Formatting (Validation)

I have a very complicated tool that I developed that produces a mass amount of information. Technically, the whole sheet should be a database drive website. However, it is a spreadsheet: ...
1
vote
0answers
13 views
+50

Google sheets: conditionally change sign of decimal value in cell for each row

Here's a preview of the spreadsheet I'm editing in Google Drive: The transaction type cell has a value of "debit" if the row is for an expense, and "credit" if it is income. I would like a script ...
0
votes
1answer
26 views
+50

Is there an online spreadsheet where I can share individual columns?

I sometimes use a spreadsheet when grading student assignments, where the leftmost columns describe the different parts of the assignments and possible points, and there is a column for each student. ...
3
votes
2answers
331 views

Google Spreadsheet generate random numbers with Math.random()

I'm trying to write a script function, which calls the Javascript Math.random() to generate a random number between [0, 1), like this: function f() { return Math.random(); } and I call it from a ...
2
votes
1answer
305 views

How to do a date formula in Google Spreadsheets

I have to do a query that increments automatically the date year by year. For example I use this formula: =INDEX(query('Scheda Intervento'!C3:K14;"select sum (K) where (F >= date '2013-01-01' ...
2
votes
1answer
168 views

How to automatically refresh date in Google spreadsheet published to the web?

I am using Google Spreadsheets to maintain a register of all students in my school and track their monthly payments. Each student has a separate Google spreadsheet maintained and in the spreadsheet I ...
0
votes
3answers
179 views

Google Spreadsheet changing cell references on its own

I have created a Google Form with an attached spreadsheet. Within that spreadsheet I have created several sheets to sort the answers to my liking. Sheet 2 is just an exact copy of all the original ...
1
vote
1answer
99 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 ...
0
votes
0answers
17 views

Google Sheets: Error- Array result was not expanded

For cell J129 I'm using the following formula =index(B122:122,1,counta(B122:122)), but I keep getting an Error that says, "Array result was not expanded because it would overwrite data in K129." I'm ...
0
votes
1answer
80 views

Transfer data from a form to a new spreadsheet

I have a simple form that inputs entries into a spreadsheet in Google Doc's. All I want to do is open a new sheet and import the data from the forms spreadsheet so I can manipulate it in my own way. ...
0
votes
0answers
5 views

Conditional deleting in Google Spreadsheets

I'm using two sheets, one with the main values and reference datas. The second sheet is for price calculation. I use =Filter to get the values from sheet one where Sheet1!E2:E <> 1. How can I ...
2
votes
0answers
14 views

Is there an “increment” shortcut in Google Sheets?

Is there an easy way to auto increment integer value in a Google Sheet like Ctrl+A in vim? If not, how do I go about creating such a shortcut?
2
votes
2answers
4k views

How to have auto updated current time cell in GoogleDocs / Excel

I am trying to create a spreadsheet that will allow me to track my clients' timezones. I am using the useless NOW() function to calc current time, and then factor in the time zone value (+/- a #) as ...
0
votes
0answers
6 views

freeze column according to column heading

I am working on attendance in Google spreadsheet, I want to protect the date column which is past date and future date, I just want to give edit right only for today date.
0
votes
1answer
148 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 ...
1
vote
2answers
32 views

How to add adjacent cells in Google Sheets

I am looking for a way to add up cells under a name. For instance, I am trying to tally all of the assists the character "Annie" got in a few different games of League of Legends. I am looking for ...
2
votes
2answers
1k 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
262 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) ...
2
votes
1answer
43 views

Return transposed list of all strings in a row in Google Sheets

In my Google Sheet, the range B2:2 contains mostly empty cells, but some cells contain strings. I would like to print these strings into a transposed list beginning at A12. This list should exclude ...
1
vote
1answer
34 views

Google sheet multiple column lookup

I have a table that looks like this: A | B | C ---|--------|--- 10 | Item x | 1 10 | Item y | 1 10 | Total | 2 20 | Item x | 4 20 | Item z | 5 20 | Total | 9 Now I would like to perform a ...
0
votes
0answers
17 views

How can I make Google Spreadsheet recognize dd/mm/yyyy format as a date?

I have a table copied over from other applications to a google spreadsheet. Before processing, I noticed google spreadsheet doesn't recognize 'dd/mm/yyyy' (e.g. 15/01/2015) as a date, instead it treat ...
3
votes
1answer
426 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 ...
1
vote
2answers
76 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.
0
votes
1answer
45 views

Google spreadsheets Conditional Formatting based on another sheet's content

I am trying to set a conditional format in Google spreadsheets and I am having some difficulty. I am not sure if I should use a cell reference or if formula. In my first Sheet called "Roster" there ...
0
votes
1answer
517 views

Google Spreadsheets Query( “where a matches '/[A-Z+]/' ”) condition

According to Google Query documentation: matches - A (preg) regular expression match. haystack matches needle is true if the regular expression in needle matches haystack. Examples: where ...
0
votes
1answer
32 views

Google spreadsheet thinks Chrome is Firefox

I am an Ubuntu user with Google Chrome 39.0 and whenever I enter a Google Spreadsheet-document (with Chrome), I get a warning header saying that "This version of Firefox is no longer supported, please ...
0
votes
0answers
12 views

Formulas mix up references when sorting data in Google Spreadsheet

I have a Google Spreadsheet that has formulas embedded into various cells. When I sort the data, the formulas always get messed up, and no longer pull data from the proper reference cells. How do I ...
0
votes
1answer
65 views

Conditional counts based on dates

I am creating a master tracker for all the technology in my school and it is pulling data from many sheets and placing it in to blocks and I am having trouble figuring out the following ...
3
votes
1answer
31 views

Where does the calculation take place?

In Google Spreadsheets, I have quite a big amount of relatively complex array formulas in many cells. That takes ages to complete calculating. Does the speed of calculation depend on my PC ...
1
vote
2answers
24 views

Google Spreadsheet: Count column if criteria is met in the respective column and another column

Is there a way to COUNT the cells in column A if the cell in column A equals "X" and the adjacent cell in column B equals "January"?
1
vote
0answers
15 views

Retrieve row data based on indirect Max function value

This spreadsheet tracks live song ratings for a popular band. Users input their score in their own column and those scores are averaged into a community score (Column E). Those song averages are ...
2
votes
3answers
1k views

Google Spreadsheets date and time format

I have lots of dates in the first column in the format August 23, 2010 at 11:01PM I was wondering if anyone knows a way to get them formatted in a way that I can then use for date and time ...
3
votes
1answer
46 views

How to count exclusive values in Google Sheets

Ok, so I have data in this format: A B C D 2 X X X 3 X X 4 X X X 5 X 6 X X ... I have a formula ...
1
vote
1answer
41 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, ...
2
votes
1answer
2k views

Google Spreadsheets Data Validation - Unique Values

I have a google sheets document which contains two sets of data in separate worksheets: Public IP addresses Private IP addresses In my private IPs worksheet I want to create a dropdown which ...
2
votes
1answer
61 views

Display Columns For this weeks Data

I'm trying to create a to do list schedule like spreadsheet that would show only the data presented for the current week. I've been having some difficulty figuring out how to display the data of ...
2
votes
1answer
23 views

Adding particular data to particular sheets within one document

I am a bit new at this and am having a tough time getting this to work... I have multiple sheets, one main one (Submissions) which receives data from a form, then I have the sheets: Level 1, Level 2, ...
1
vote
1answer
62 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
1answer
40 views

Calling IMPORTRANGE inside of REGEXMATCH function?

I'm interested to know whether (and how) can i call IMPORTRANGE function inside of REGEXMATCH function. I want to get root domains from list of URL's and use REGEXMATCH to do this but want to get ...
1
vote
1answer
237 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. ...
2
votes
1answer
103 views

ARRAYFORMULA and COUNTIF

I have a formula: =IFERROR(COUNTIF(C14:V14,"I")/ COUNTIF(C14:V14,"<>"),) to compute a percentage of I inputs divided by <> (all other inputs) and I need to omit blank cells. The IFERROR ...
1
vote
2answers
254 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 ...
2
votes
3answers
2k views

How to group data by month in Google Spreadsheets

I have a Google spreadsheet which contains various metrics for each day. Each day has it's own row like this: day | cost | impressions | clicks | conversions 2014-02-01 | $45 | 3,540 | ...