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

learn more… | top users | synonyms (2)

0
votes
2answers
2k views

Google Docs Spreadsheet ImportHtml() with Basic Auth

Within a Google Docs spreadsheet, I need to access external data that requires basic authentication. Usually I would include external data by putting this in a cell: ...
0
votes
1answer
206 views

How can I have column E copy its data into the right column based on the initials in column M?

So what I have so far is a spreadsheet that will auto time stamp column N when my technicians enter their initials into column M. Now the 2nd thing I would like the spreadsheet to do is. When I ...
0
votes
1answer
115 views

I need a formula that returns how many times a unique value appears in a given date

In a spreadsheet in Google Spreadsheets, I’m trying to solve this: 17/02/2012 banana 17/02/2012 banana 17/02/2012 banana 17/02/2012 apple 18/02/2012 apple 18/02/2012 apple I need a formula ...
0
votes
1answer
2k views

Insert copied cells in Google Spreadsheets

I'd like to shift a set of cells downward from a selection in Google Spreadsheets. Ideally "insert copied cells" from Excel, but I can live with just the shift part, i.e. insert blank cells, shifting ...
0
votes
2answers
549 views

How can I link to a cell in Google Spreadsheets?

I have a headings and every time I have to scroll down to the cell I need. Can I create some kind of "header" on the top of the page and just click on the header I want and it will automatically ...
0
votes
2answers
2k views

Sum of numerical values excluding formulas in a Google Spreadsheet

I have a long column of numbers in Google Spreadsheet, and occasionally there exists a cell that sums some of the cells below it. For example: =SUM(2:4) 5 10 30 =SUM(6:8) 40 10 10 ...
0
votes
1answer
365 views

Working with names in Google Docs Spreadsheet

I have created a spreadsheet to keep track of my players on my team, I would like to sum all of their individual times playing regardless of who they played (different players). Is this possible? ...
0
votes
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. ...
0
votes
1answer
179 views

Entering Local Date on Google Doc Sheets

If I use the shortcut CTRL+;, the date that is pasted is the server date. I have changed the settings so my Time zone is selected to my local time. Shouldn't my Local time get pasted as opposed to ...
0
votes
0answers
1 view

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

Is there a way to sum the cells in column A if the cell in column A equals "X" and the adjacent cell in column B equals "January"?
0
votes
1answer
23 views

How do I use a dropdown menu in a cell to populate other cells with information?

I'm trying to build a spreadsheet that allows a user to select a product in a dropdown menu in the first cell and then based on what is selected it will populate the spreadsheet with prices and ...
0
votes
1answer
13 views

how to make columns not affect other columns within the same row in google spreadsheet

I have done an schedule in google excel(google spreadsheet). I set text wrapping to wrap. The problem is that when i write something in column A and the row in column A gets expanded to fit all text ...
0
votes
0answers
12 views

How can I check emails against a Google sheet containing a list of email addresses?

I am conducting a research study and receive many emails (via Gmail) from potential participants. I do an eligibility screen with participants over the phone, and if they are not eligible, I add their ...
0
votes
0answers
10 views

Can you restrict Google Sheet to editing just text with restrictions on formatting?

I simply do not want people who edit the sheet to mess up the formatting. I'm sharing a file with well over fifty people, and if someone messes up the document, it'll probably set off a chain. Thanks ...
0
votes
0answers
26 views

Google Sheets Query Formula Needed

https://docs.google.com/a/fivetowns.net/spreadsheets/d/1myKz4WpRAt3Kja__Dsddnr3YtfOjVPkYUOTXoi-4exc/edit#gid=1665161315 Above is link to mock up of my spreadsheet. I would like to build a formula ...
0
votes
0answers
15 views

Google Sheets trendline broken; file unavailable

In Google Sheets, I've created a line graph. I want to add a trend line. I do so by clicking the blue line and selecting Linear from the trendline dropdown. No trendline appears. Then when I right ...
0
votes
0answers
13 views

Google Sheets - Checking duplicates without direct access

I have set up a spreadsheet on Google Drive that multiple users can access and edit, but I also need users to be alerted when the data they enter already exists elsewhere (This could be another sheet, ...
0
votes
0answers
20 views

Google Sheets - Filter based on a condition

How can I filter across a range and return all the details based on a condition? I would like to be able to identify customer deliveries based on Dates and would like to filter for delivery dates ...
0
votes
1answer
20 views

How to edit a particular sheet using Google Forms

I created a form that has list of items to be selected. I also created a spreadsheet that has a couple of sheets that correspond to the elements in the form. I wanted users to select a category and ...
0
votes
0answers
7 views

Using arrayformula in google sheets to copy down

I have read all the other questions that show this being used and I ether get errors when I plug this in, or it copies everything from the first row all the way down. =(split(split(D1,"SMS from ...
0
votes
1answer
16 views

Formula help for mileage calculation/constant

I need to create a spreadsheet in Google Drive that will let me calculate mileage for my employees. I know the exact mileage to the locations they'd have to drive to. What I need to do is have a ...
0
votes
1answer
30 views

RegExp for data validation

I need a help for regexp writing to validate format: any_positive_integer@any_text,any_positive_integer@any_text, ..... To be exact, "any_positive_integer@any_text" separated by commas and inside, ...
0
votes
0answers
20 views

ArrayFormula in Google Spreadsheets iterating formula

I want to use ArrayFormula across entire column ranges. This works: =arrayformula('sheet1'!A1:B) However, I can't get a more complicated formula to work (inserted in A3 on empty sheet): ...
0
votes
1answer
36 views

Only display importrange rows that match specific criteria in Google Sheets

In Google Sheets, I'm using IMPORTRANGE to pull in a large list of data (about 400 rows, 6 columns) and I want to only display rows where column D matches EXAMPLE TEXT. Is this a possible? For ...
0
votes
0answers
7 views

Change certain cells back to default value every Monday morning in Google Sheets

I have a Google spreadsheet that ~30 members can edit (one row for each member). I need to create a column showing "yes" as default in each row until the member manually changes it to "no" if he/she ...
0
votes
0answers
7 views

Staying on the same page after sorting by a script

The following script does not return me to the sheet I edited. First Sheet sorts by script on edit function onEdit(event){ // This example assumes there is a sheet named "Schedule" var sheet = ...
0
votes
0answers
12 views

Equivalent of Ctrl+Apostrophe in Google Sheets

In Microsoft Excel I frequently use the keyboard shortcut Ctrl+' (apostrophe) to copy the value from the cell above the current one. The same keystrokes in Google Sheets instead toggles the display of ...
0
votes
0answers
16 views

How to display Image from URL in Google Sheets? (and apply it to multiple rows)

So I created a list of members in Google Sheets, each member having a profile image, name, location, etc. I exported this list from import.io, a data extraction tool. The only problem is that when I ...
0
votes
1answer
16 views

Google spreadsheet into email

I created a spreadsheet to track clients contact information. For convenience, I entered their email addresses as a hyperlink. When I click on the link, a blank 'untitled' page opens. I'm not sure why ...
0
votes
1answer
31 views

Advanced formula in Google Sheets

I'm trying to make a worksheet that gives graphs of data in other worksheets. I had the idea that the user could choose which worksheet they want to use. For example, there are 3 worksheets with data ...
0
votes
0answers
20 views

Google sheets grouping function in excel equivalent or workaround?

I know you can't do it in Google sheets. I think the grouping function in Excel is one of the most useful things out there with the ability to expand or collapse rows and columns by grouping them. ...
0
votes
0answers
17 views

How do I get choose a Named Range in Gsheets from a drop down (autocomplete, etc.)

I'm using Named Ranges in google Sheets but it's a real pain to have to type the name exactly right, esp since I'm using very verbose, descriptive names. So, I'm wondering if there is any sort of ...
0
votes
0answers
22 views

Discrete values on Google Sheet's chart axis

For some reason i'm getting middle values of a month when plotting just 3 points (one for each 1st of month). How can get rid of them? Thanks!
0
votes
0answers
24 views

Google Spreadsheet Script: insert text at end of list

I'm trying to add a custom menu that inserts a date in whatever cell is selected, appending it if anything is there already. It works fine, if slowly. The goal is that, at the end, I've got a list of ...
0
votes
0answers
29 views

Unable to import pricing info from toysrus.com into a Google Spreadsheet

I'm trying to pull live pricing from a given toysrus.com item into a Google Spreadsheet (one item/price per row), and am having no luck whatsoever. Importxml(url, xpath) does not work (similar to the ...
0
votes
1answer
43 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
0answers
25 views

replicating importrange() on copies of Google Spreadsheets files

So I know I can use =importrange(spreadsheet-key, range) And that's fine. But I am doing a monthly control of the sales in my shop. So I want just one big file summing up everything that only I ...
0
votes
0answers
28 views

Timestamp in Google spreadsheet

Any idea on how to work 2 timestamp which is start and end into google spreadsheet? I have already this in my script editor, but it’s only for start. I want to get also the end and show into another ...
0
votes
0answers
45 views

Unique ID Column

I have a Google Spreadsheet that I want to have a unique number created in column A when I enter information in column B. Below is the formula I currently have that works, but I am wondering if there ...
0
votes
0answers
20 views

Formula for getting format of a cell in Google Sheets [duplicate]

I'd like to be able to return formatting information about a cell with output similar to that of the CELL command. Ideally, this would be something like CELL("format", A2), and if A2 was bolded, or in ...
0
votes
0answers
42 views

Google Sheets IMPORTRANGE + QUERY won't import IMAGE

I use Sheets in my business to create product catalogs for wholesale prices. I have different sheets for different companies but the data in many of them is the same. I'd like these sheets to sync ...
0
votes
0answers
17 views

Google spreadsheet: Pasting value not function

I am writing a spreadsheet that imports values from webpages that change a lot, I want to keep note on these values over the days of a week. However I'm unsure of how to note them at certain times. ...
0
votes
2answers
51 views

Google Spreadsheet criteria if cell above is blank

I am trying to get a sum of column values in a Google Spreadsheet only if there is no value in the column above. Consider the following example: A | B | C --------------------------------- ...
0
votes
0answers
33 views

Auto sort a column and auto duplicate all sheets to one sheet

The title speaks for itself. I am looking to do two things in Google Sheets, because I am entering data from a different third-party app using Google API. First: I need Google Sheets to auto sort a ...
0
votes
0answers
18 views

Automatically creating sheets across different google spreadsheets

I have one spreadsheet that collects the Google form data that is submitted. I then created spreadsheets titled "A-D", "E-H", "I-L", and so on to create the alphabet. I would like students to use ...
0
votes
0answers
24 views

Automatically create google spreadsheets from master list

I am trying to create new sheets automatically based on a list of items. I came across your answer to a question here , but the example sheet it points to is no longer valid. I am working with this ...
0
votes
0answers
31 views

How to copy permissions across sheets?

Named ranges are duplicated when their sheet is duplicated. However, protected ranges are not. I have 40 protected ranges on a sheet that I need to replicate 6 times, so I'm not really looking ...
0
votes
1answer
31 views

Linking a URL to text using google script in spreadsheet

I have a URL ready to be followed. I am sending an email using Google script, and in this email I need this link to be there... but I do not want it to be: ...
0
votes
1answer
10 views

Have indirect update row when pasted on new rows

According to this answer, I am fetching data from another sheet over rows: http://webapps.stackexchange.com/a/24478/29203 The problem for me is as I am fetching over rows, the supplied answer does ...
0
votes
0answers
42 views

Formula query to perform dynamic sum

I am creating a spreadsheet which looks up values from a second sheet. I need to SUM various sections in the sheet but these are variable - the row that needs SUMing can change at every fresh import ...