A productivity application from Google that allows you to create and edit worksheets

learn more… | top users | synonyms (2)

3
votes
0answers
16 views

Populate column with editable range based on drop-down

So, here's my issue. I've got three sheets. One sheet has all of the classes for Mondays and Wednesdays, one sheet has all the classes for Tuesdays and Thursdays. The third sheet has a drop-down menu ...
3
votes
1answer
42 views

Import only those cells from a spreedsheet that have certain conditional formatting

I have created a Google form which links to a spreadsheet. There is an option which asks for the person's name. For the answers in the sheet, I've created a conditional formatting which highlights the ...
1
vote
1answer
23 views

Align the rows of one sheet with the rows of an imported sheet

I have a spreadsheet of employee names. I am using =IMPORTRANGE() to import the names into another spreadsheet that tracks expenses in rows next each of the imported employee names. The problem is ...
4
votes
1answer
29 views

How many spreadsheets are stored in my Google Drive?

A Google survey asked me: About how many spreadsheets are stored in your Google Drive? I ended up guessing, because I couldn't find a way to find the real number. In Google Drive interface, ...
0
votes
0answers
22 views

IMPORTDATA() with Google Sheets

I am trying to use the IMPORTDATA() function on Google Sheets. Initially I tried downloading yahoo finance data, which didn't work. However, I cannot seem to get the function to work even using ...
0
votes
0answers
27 views

Is it possible to link an Excel document to a Google Sheet?

I have an Excel file that needs to be updated weekly, but I also have a clone on Google Sheets that needs to have identical changes done each week as well. I currently am trying to use the =...
0
votes
1answer
23 views

How to allow users to enter some data in Google Sheet without actually modifying the content?

I'd like to make a sort of calculator based on a grid, where the user checks different lines/columns and it will calculate some stuff based on what's checked. Perhaps I could do something in HTML/...
1
vote
1answer
29 views

Run a formula multiple times in same sitting

I am trying to make a spreadsheet to keep track of the values of each upgrade in the game Reactor Idle. Each "level" increases the value by a certain percent. To predict the value after the next ...
2
votes
1answer
19 views

How to return only the first row containing the value you are searching for in a query?

=QUERY('F/O DEFVSREC'!$1:$1000, "select C, D, E, F, G, H, I, J, K, L, M, N, O, P, Q, R, S, T, U, V where B='"&A35&"'label C'', D'', E'', F'', G'', H'', I'', J'', K'', L'', M'', N'', O'', P'', ...
1
vote
1answer
23 views

Inserting text from a cell into an importrange formula

I have a spreadsheet (Spreadsheet B) with a number of formulas which require data from another spreadsheet (Spreadsheet A). Many of the formulas in Spreadsheet B reference different sheets (on ...
0
votes
0answers
19 views

Can you integrate a form with Google Sheets document?

I want to have a form that you fill, submit, then it updates a Google spreadsheet file. What do I search to learn how to do this? I cannot find info on doing something like this.
2
votes
2answers
39 views

Filter multiple categories Spreadsheet

How do can I filter multiple words in a column? (for example i want to filter the words "golf" and "ski" to show up in my filter)
1
vote
1answer
29 views

How to refer to a cell's content from a query in Google Spreadsheets? [duplicate]

=QUERY('F/O OFF'!1:1000, "select H, J where B='CIN'label H'', J''") Right now this formula works fine, but i have to change the "where B=" for each row in the sheet. I want to get it so where B= (...
4
votes
2answers
83 views

Sortable Version/Requirement Numbering in Google Sheets

We use a number system like software versioning or IP addresses for business requirements, using decimal points to separate significant number sets. Spreadsheets don't handle this well because when ...
0
votes
1answer
36 views

Create Google chart from dynamic number of sheets

Is there a way to create a chart based on an ever-growing folder of sheets? For instance, if I want to graph the running average of some value always found in cell A1 across all sheets within a ...
2
votes
1answer
36 views

Transform a string according to a table of replacements

I need to create a QR code out of a few pieces of user-entered information, we will call them a b and c. I am doing this using a google sheet document and embedding this formula into a cell: =if(...
1
vote
0answers
15 views

How to use dot as splitter in currency format with Russian locale

I want to write currency in the format: ₽ 3 812.23 But if I select Russia as region in the table settings and format the string ₽ 0.00 result formatted number like ₽ 3 812,23 with a comma, ...
3
votes
1answer
36 views

Using regex in Google Sheets data validation

I'm trying to use a regex in the Google Sheets data validation in order to ban the input of special characters, so basically my allowed set should be [a-zA-Z0-9,./()]. I'm using the custom formula ...
4
votes
1answer
31 views

How can we retain authorship when we copy/paste a comment?

We have comments in a Google Spreadsheet that were not originally written by us. The cells the comments are written in already have "Conditional format rules" applied to them (e.g., cell H2). We ...
0
votes
0answers
17 views

Loop through columns in different sheets, comparing the values

I have three sheets. One is for the item senders, one is for the receiving of the items, and the other times compares the sent and received. For the comparison to work I need to loop through columns a ...
1
vote
1answer
17 views

Fill zeros for the dates when no data was recorded

I have a table with dates (in increasing order) and corresponding values. Some dates are missing, like 3/27 below. I'd like to insert them in Date column, and have 0 entered in the Value column for ...
0
votes
1answer
38 views

Google apps script to check availability

I'm using google form+calendar to create a reservation system for my makers lab. The user fills out the form and an event is created on the calendar so the TA knows when to goto the lab to help the ...
1
vote
0answers
23 views

Replacing last edited response with the old one in another tab [duplicate]

You can ignore column D, E, F and G cause those are just alphabetically ordered. So basically I want to draw the names of the responses on the responsesheet to this tab (see screenshot), which is what ...
2
votes
2answers
40 views

How can I see Google spreadsheets in Myanmar font?

I want to know whether it is possible to see Google spreadsheet in Myanmar font. Because in my Ubuntu operating system I am not able to see the spreadsheet text in Myanmar font which show only boxes. ...
1
vote
1answer
26 views

Script to delete a dynamic range of rows

I'm looking for a script that allows me to delete a dynamic range of rows. Basically I have a script that adds rows to the bottom of a list but I want another script that will delete all rows in the ...
0
votes
1answer
26 views

Google Sheets sharing setting, “Specific people can access” but can't see each other

For Google sheets sharing setting, I have it on "Specific people can access", but the people can see who has access to that sheet. Is there anyway to make the setting so that the specific people can't ...
0
votes
1answer
41 views

Copy a row and add to the bottom of a list

I'm looking for script that will allow me to copy a specific row and paste it to the bottom of a list. The bottom of the list will not be the last row on the sheet. Using VBA I would have used an ...
2
votes
1answer
27 views

Reverse lookup from Google spreadsheet key

I can't figure out where the data in an IMPORTRANGE function is coming from. How can I use the spreadsheet key to find the the original spreadsheet IMPORTRANGE is pulling from?
1
vote
1answer
23 views

Reference one of my own spreadsheets, within another, by its name

I would like to reference a spreadsheet that is within my own Google Docs, owned by me. The catch is, the spreadsheet changes. It will be a different spreadsheet ever day, with the date as it's ...
0
votes
1answer
59 views

Using Google URL Shortener API in Google Sheets for bulk URL shortening

Recently come across similar issue to this question, where I want to add use the Google URL shortener API in Google Sheets for bulk URL shortening. However, I keep running into this error: Rate ...
-3
votes
1answer
30 views

Why is this conditional formatting still highlighting cells that don't meet the condition?

I'm trying to apply Conditional formatting applying to column K (range K2:K1001). What I want to do is to highlight each cell in the column if it's date value (e.g., "6/1/2016") is less than a date in ...
3
votes
1answer
112 views

IMPORTHTML 'could not fetch URL' but used to be able to

I made a spreadsheet, a part of which uses the IMPORTHTML function to get data from this webpage. For the first couple of weeks that it ran, it worked pretty great, getting all the data from the table ...
1
vote
1answer
28 views

Compute the total of every row with arrayformula

In my spreadsheet, I need to add up each individual row. It does that if I drag the formula down in Y, but then when a new row is added to the data from a Google form, it won't copy the formula. So I ...
-1
votes
2answers
62 views

Fetching JSON in Google Sheets (ImportJSONAdvanced not defined?)

Currently working on fetching data from an API with Basic Authentication. Through this script: https://gist.github.com/anemitz/8cc6ef6c41ea4cefe51a13fbd6d8676a function ImportJSONBasicAuthentication(...
1
vote
1answer
13 views

Time and Date Edit by GMT Zone

I need to edit the date and time format in a Google spreadsheet. The spreadsheet has 300 rows with the following format in text 2016-04-21 21:28:00 +0000. Using the find and replace feature I would ...
0
votes
1answer
21 views

An “Updated on” field that records the last time that a particular column changed [duplicate]

Is it possible to create a "last updated" field under Google Sheets? I have a status column, where the status progresses something like: New -> Pending -> Started -> Done I would like to add a ...
1
vote
0answers
59 views

How to embed Google Sheet into Google Document and keep the Google Sheet format

How do I embed a Google Sheet into a google document and keep the Google Sheet format in the document? I have got this far with the script but it's not working function updateData() { var ssUrl = '...
4
votes
1answer
44 views

Adding and/or logic into the criteria field (SUMIF)?

Using Google Sheets with the expression SUMIF, is there a way to make the criteria field look for 2 types of values using OR logic? A B Joe 1 Joe 2 Tim 3 Roy 4 Tim 5 Roy 6 ...
2
votes
1answer
27 views

I created a copy (B) of a Google Spreadsheet (A). Now the Google Form that used to feed A is feeding B

Is there any way to change the settings of the Google Form so that it again feeds into the same worksheet of the same Google Spreadsheet (A) that it used to feed before I created the copy B? The only ...
1
vote
1answer
36 views

Conditional number format (whole number, percentage) based on the value in another cell

I have a custom function provides results based on user input - once of these variables accepts either "Numerical" or "Percentage", which provides the data as standard number, or a percentage of the ...
0
votes
0answers
10 views

How to import a single cell from 18 separate googledocs spreadsheets [duplicate]

Can you take one cell each from 18 different googledocs spreadsheets and put them on a summary spreadsheet to keep a running total of the totals. All separate spreadsheets because individual sheets ...
4
votes
2answers
68 views

Sum of values under a merged Cell

I would like to get the Sum for the following formatted spreadsheet: |PIZZA |ABC |21 | | |GHT |12 | | |ERT |45 | | |DFT |2 |=21+12+45+2 |EGGS |GTD |96 | | |YHJ |5 | | |PHJ ...
0
votes
1answer
44 views

Query formula limitations Google Sheets?

I'm trying to run a query (importrange) formula in a new Google sheet. The data I'm trying to load is from another sheet. The source sheet contains 6000 rows and 12 columns. The formula I tried was: ...
2
votes
1answer
35 views

Validation to check a list of values from found on a different sheet

I have two sheets in my workbook named 'Tasks' and 'Personnel'. The 'Personel' sheet has three columns that contains a list of Person's ID, Name, and Contact Number. While the 'Task' sheet contains ...
0
votes
1answer
33 views

How to make Google Sheet jump to today's column when opened?

I'm trying to adjust this code so that I can jump to today's date which are all across row 2 in my spread sheet. function onOpen() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss....
3
votes
1answer
20 views

How to address the columns of an inline array?

Suppose you want to run a query against an inline array: QUERY({"apple"; "orange"; "banana"}, "select A") This yields Unable to parse query string for Function QUERY parameter 2: NO_COLUMNA. Is ...
2
votes
0answers
22 views

What is the behavior when Zapier matches more than one row?

Zapier has a Lookup Spreadsheet Row - action. The docs say "Lookup Spreadsheet Row - Finds a row by a column and value. Returns all the values on that matching row." What is the behavior if the ...
3
votes
1answer
36 views

Sum the totals for each product over all sheets in a spreadsheet

I'm trying to make a spreadsheet to take online orders from clients. I send them a price list, which they complete with their order and every time a client sends an order, it automatically adds a new ...
1
vote
2answers
51 views

Display imported data in reverse order, so that the most recent entries are on top

I want to invert the spreadsheet so I get the data at the top every day. I've tried to =sort(importdata("=importdata("http://www.tr4der.com/download/historical-prices/SPY/"),1,false) but that ...
1
vote
0answers
42 views

How to save a Google Sheets chart as an SVG or EPS?

By default, Google Sheets only lets you save charts as PNGs. This isn't good enough when I need high-quality images, or images that are editable after export. This quick tutorial provides guidance on ...