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

learn more… | top users | synonyms (2)

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
28 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
33 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
13 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
35 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
16 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
38 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
25 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
57 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
101 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
60 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
57 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
42 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
67 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
42 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
21 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
33 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
48 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
40 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 ...
2
votes
1answer
37 views

Can I set a trigger to run every second?

While searching for answer to How can I trigger a function when switching sheets within a spreadsheet? I noticed that the Triggers for current project dialog has an option for specifying a trigger ...
3
votes
2answers
68 views

How can I trigger a function when switching sheets within a spreadsheet?

How can I trigger a function when switching sheets? Let's say I'm viewing a multi-sheet spreadsheet. Now I want a function to run whenever I switch from one sheet (tab) to another. Is that possible? ...
2
votes
2answers
27 views

Formula to use to add up all rows that returned a value of 1 for several cells that meet a specific crtieria

This is the spreadsheet I need help with: spreadsheet I need cell B21 in the 'Reports' sheet to add up all rows that meet this criteria: return a value of 1 if columns M, O, T, U, W, X, Z, AA, AB, AC ...
0
votes
0answers
27 views

Set a send email account in Google spreadsheet

I have 3 email accounts, two gmail (a "corporate account" and a work account) and one personal account not via gmail. We collect requests in a google spreadsheet, where I want to add a hot mailto ...
3
votes
2answers
36 views

How to make Google Sheets autowrite value into table

I would like to place some values in a table, given their row and column coordinates. Do I have to use a script or can I use a function? On the image I swapped the x and y axis but I think you get ...
1
vote
1answer
46 views

arrayformula (or other to copy down formula in adjacent cell to last row with data?

I have a spreadsheet in Google Sheets in which the formulas in E2 and F2 need to be copied down to the last row that has data. Here are rows 1 and 2: Name of Teacher Date Absent During Start ...