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

learn more… | top users | synonyms (1)

0
votes
0answers
2 views

Operations on hyperlink labels of cells

I am using hyperlinks on some price values on cell in Google Docs. So my cells look like this: =HYPERLINK("http://www.site.com/item","$25.00") I am trying to perform a SUM operation on a bunch of ...
0
votes
0answers
5 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
14 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
3 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 ...
1
vote
0answers
11 views

Find first value in list in cell

I keep running into situations where I have a list of values in a cell in Google Spreadsheets, and I need some value out of the list: by list I mean a string of values (generally dates, but could be ...
0
votes
0answers
4 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
1answer
11 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 ...
1
vote
1answer
9 views

Reverse (or repopulate) a Google Docs Form

I created a Google Docs form that collects (mostly) biographical and contact data from users. Now I would like to reverse the process and repopulate the form with each user's input, one page per ...
0
votes
0answers
3 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
28 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 ...
2
votes
0answers
16 views

Is there any option to operate with 2 lists in one list in Google Sheets?

Is it possible in Google spreadsheets to have one list which is somehow divided into 2 parts and both of those parts consist of different lists? Something like iframes in HTML.
0
votes
1answer
13 views

How do I make one cell correspond with another for google spreadsheet?

A B C D 1|Male | 5 |Male avg| 8 | 2|Female| 4 | | | 3|Female| 8 | | | 4|Male | 9 | | | 5|Male | 10 | | ...
1
vote
1answer
26 views

How to get a running balance?

I'm messing around with Google Sheets today, and I'm trying to put together a balance sheet similar to the one my bank uses. Its got both a credit and debit field in each row and a running balance to ...
0
votes
0answers
11 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
12 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
15 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!
1
vote
0answers
21 views

Reference an entire sheet in Google Sheets

Is there a way to reference an entire spreadsheet with a cell reference in Google Sheets? Say I wanted to find out how many cells in Sheet1 were non empty. In sheet two I'd want to do something like ...
1
vote
1answer
30 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
11 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
25 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 ...
2
votes
1answer
86 views
+50

Add a time picker to Google Docs Spreadsheets?

Is there an option to add a time picker on Google Docs Spreadsheets? I don't need timezones or anything complicated. Just a string on the HH:MM format, that matches the custom format available. I ...
0
votes
1answer
22 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
24 views

Google Docs Chrome extension - what does it do / why does it exist?

In some Chrome instances, several extensions (apps?) called Google Docs, Google Sheets, etc. are installed (I've seen various subsets of these across different Chrome instances). What are these for / ...
0
votes
0answers
15 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
1answer
24 views

script editor - google spreadsheet

Need help in adding another function using the below script. I would like to have a timestamp "start" and "end" on two different columns, whenever the other two separate columns are edited. Based on ...
0
votes
0answers
16 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
17 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 ...
1
vote
1answer
24 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
29 views

Select row in Google Sheets

I have a function in Google Sheets that is giving the following output: a b c 1 2 3 I don't want the a b c I just want the 1 2 3. What function can I wrap around my other function so that it will ...
2
votes
1answer
27 views

What is the key in my Google Spreadsheets URL?

I have found many posts from awhile ago that talk about the <key> in the URL. Problem is when I am trying to input the key, there is none. Well at least I cannot determine what the key is. ...
2
votes
1answer
26 views

google cell format: only 3 digits

Is there any way to do this: I have cell and most of the numbers have 2 significant digits like 3.45. But once in a while I have a number like 143 big number, the rest are under 10. Currently for 143 ...
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 ...
1
vote
2answers
36 views

How to sort cells with text and numbers correctly

This is my example list: example file As you can see I am sorting all unique elements in row B. But the "Sprint 9" gets sorted as the highest value, not the lowest. I really have no clue how I can ...
1
vote
1answer
29 views

Get duration as seconds google spreadsheet

I'm calculating some sums of gain over time - therefore I want to divide X by time required to generate X. The problem here is, that the SECOND function in the =(SUM(B4:B18)/SECOND(SUM(A4:A18)))*60 ...
1
vote
0answers
20 views

Import a CSV file from a URL to Google Docs and update it periodically

I'm looking to pull data from a CSV file that gets update regularly into a Google spreadsheet that I can format the way I want. I know how to import the CSV as a one time thing but I don't know how to ...
1
vote
1answer
32 views

Dynamic date range query

I'm trying to create two cells that will update my query: A >= date"A1" and A <= date "B1". My goal is to create a search page for the data, where the end user could insert a date or the =today() ...
2
votes
1answer
37 views

How do I loop a script through all pages but the first one?

I'm very new to all this. I'm trying to write a script that sorts sheets by descending date order each time a new row is entered. I need the script to run on all pages but the first (the summary ...
4
votes
0answers
36 views

How to have multiple users complete a single form in Google Forms

Using Google Forms, is there a way to have a user complete a section of a form, share the form and have another user complete another section of the same form, thereby keeping the combined inputs as a ...
0
votes
0answers
34 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 ...
3
votes
2answers
80 views

Join two columns in Google Sheets

I have two columns in Google Sheets, and I would like the product of a cross-join: Student ------- Jake John Sally Grace Days ----- 1/1/15 1/2/15 1/3/15 1/4/15 For example, if these were tables ...
0
votes
0answers
16 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
39 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
27 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 ...
2
votes
1answer
31 views

Google Sheets auto-format the highest value in a row of cells

I have a set of data like so: A|B|C|D 1 9|3|5|4 2 7|6|6|6 3 3|6|2|7 4 6|9|4|7 And I would like to auto-format the highest value in each row. So, for instance in row 1, A1 would get the ...
1
vote
1answer
22 views

Calculate total based on drop down criteria

I am creating a budget that has different expenses on one worksheet (Expense_Overview). On another worksheet, I have a list of expenses (Expense_Detail) I am entering that are categorized based on a ...
0
votes
0answers
15 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 ...
2
votes
0answers
19 views

How do i move an image/chart to a corner in Google Sheets without the awful margin?

I'm trying to get this image in a corner: As you can see, when trying to move, Google puts an awful margin on the top which makes impossible to get an image on the very top of a document. Any ...
0
votes
0answers
18 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
25 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
24 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: ...