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

learn more… | top users | synonyms (2)

1
vote
1answer
16 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
33 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
votes
0answers
19 views

A single script that will Show/Hide Columns & Rows

How do I combine the below scripts so that either one will run depending on whether they are already showing or hidden? I'm thinking maybe an IF THEN statement? I'm looking for the script to run with ...
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 ...
-1
votes
0answers
28 views

SUMIF formula in Google Sheets

I am having trouble with a formula and maybe you can help me. I have created a Google Form where I am capturing when and how much my baby eats, among other things. I have a Sheets responses file ...
2
votes
2answers
30 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
22 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
22 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
40 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
25 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
37 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
55 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
26 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
42 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 ...
1
vote
1answer
12 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
19 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
47 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
40 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
32 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
9 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
58 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
39 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
29 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 = ...
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
19 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
28 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
47 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
29 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
29 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
59 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
26 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
40 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 ...
0
votes
1answer
37 views

Updating a column of cells with a maximum value from Google Finance

function getHigh() { //to update the highest value of a stock price at market close, used to calculate a trailing stop price var sh = SpreadsheetApp.getActiveSheet(); //column E is stock price ...
1
vote
1answer
38 views

Filter View, Text Starts With in Custom Formula

In Google docs (spreadsheet) under Filter View, I am trying to write a custom formula for multiple conditions. For example, in column O, I may have "Jury Room" and also "Jury Rooms" and so I am ...
2
votes
1answer
18 views

Combine rows to a column in Google Spreadsheets

I have a question about combining rows to a column in Google Spreadsheets. There are a lot of threads already about this topic, but I couldn't find one about this particular problem. This is the data ...
1
vote
1answer
15 views

How do I pull information from google sheets based on a date range?

I am using google sheets to collect information about patients in one of our programs. I want to be able to pull a list every week of the patients I need to follow up on. The new spread sheet needs to ...
1
vote
1answer
36 views

Formula to use to return a value of 1 for several cells that meet a certain crtieria

Here's the spreadsheet I need help with: https://docs.google.com/spreadsheets/d/1DGYgprXe7V7WH2HII0hvQDWXl1SaG_a4MUZ5HDGhSq8/edit#gid=258610801 I basically need cell B21 in the "Report" worksheet to ...
1
vote
1answer
16 views

Google Sheets formula for weekly column totals

I'm a bit of a newbie to Google Sheets formulas and such. I have a set of data entered daily with the dates converted by WEEKNUM() to display and allow me to filter by week no. I want to add the ...
0
votes
1answer
22 views

Grabbing every data from every sixth cell in a row for a sparkline

I am creating a spreadsheet in Google Sheets where every 6th column is a "total" column. I need to create a sparkline that will grab the value of every 6th cell in that row.
1
vote
2answers
20 views

How to concatenate date value with a string?

I need to create the following value: // "ABC" + current date + some random number ABC20160405123 I do as follows: =CONCATENATE("ABC", NOW(), 123); But instead of getting expected value I get ...
1
vote
1answer
25 views

Timestamp code for Google Sheets

I am using this script in order to put a time stamp in column B when someone edits in a row. However, I need it to place the time stamp if someone edits a row in column A. I don't need it to place a ...
3
votes
1answer
21 views

Normal Text in Google Sheets is absent. How to enable?

Where has Google hidden Normal Text in Google Sheets? It is present in Google Docs but is absent in Google Sheets: G Docs: G Sheets. There is anything under the menu except Normal Text: When I ...
1
vote
1answer
41 views

Group events by day, count them and aggregate the amounts

I have a long list of date times (timestamps) in column A, attached to some data in column B. I want to group this data by day, obtaining the count of events and the totals for each day. For example, ...
1
vote
2answers
40 views

Row by row comparison with FILTER returning error

I am trying do a row by row comparison of two separate sheets, and display the unequal rows on a third sheet. As an example, rows three and five on Sheet1 are different from Sheet2 and I want to ...