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

learn more… | top users | synonyms (2)

-1
votes
0answers
21 views

Stocks Valuation google spreadsheet

I'm a bit of a dummy as far as spreadsheets go, so hoping someone can help with my dumb questions. I want to have a spreadsheet where I can list all my mid to large caps with the market cap in the ...
-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
53 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
46 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
25 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
31 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
38 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
34 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
18 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
26 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
27 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
58 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
38 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
35 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
36 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
39 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 ...
0
votes
1answer
25 views

Sort column from another sheet alphabetically

I have a sheet that has a column of names. I want to have another sheet that copies all of the entries from this column in sheet 1 and alphabetizes them automatically as I add new entries into sheet ...
0
votes
0answers
16 views

Can I Add Multiple “Locations” to a single row for a Map Chart

I have a Google Spreadsheet that I am testing out the Map Chart with. I wanted to test two Charts, Org and Map. So I thought that a list of gods would give me both. However, I ran into a situation ...
1
vote
1answer
29 views

Alternate colored lines in Google Sheets that respect other formattings

I accidently read this question about alternate coloring for filter views wrongly and answered a question I had all the time. The question is: how can I use alternate colored lines but still have ...
2
votes
1answer
28 views

ImportRange as dependent function

I am trying to write a script which set the function importRange in a specific cell, using us KEY the content of another cell. I have the list of the KEYs in Sheet2 and here is what I wrote so far: ...
2
votes
1answer
22 views

Keyboard shortcut to extend Google Sheet formula down to the next cell?

I have a formula in cell A2, say, in a Google Sheet. With cell A2 selected, is there a keyboard shortcut to extend that formula down to cell A3?
1
vote
1answer
19 views

What is a cut and paste approach to converting a chunk of a google spreadsheet to markdown table?

I maintain my web site in a version of markdown, with the common table extension. I maintain my inventory as a google spreadsheet. I'd like a quick way to copy paste a chunk of a spreadsheet, and ...
1
vote
1answer
46 views

How to auto generate the date a URL was last updated?

I'm trying to find out if it's possible to fetch the date a URL was last updated. So column A I'd have the URL and column B the data would auto generate. I'm guessing this would be done using some ...
1
vote
1answer
37 views

Add Additional Lines to Google Sheets Line Chart

I'm having some issues adding simple lines to a line chart on Google Sheets. I have a line chart using Table A, has 10 X and Y values, X values are dates, Y values are a number, simple line chart. I ...
1
vote
0answers
15 views

How can I auto-format US and international phone numbers plus extensions of various lengths in Google Sheets?

I have contact data being submitted from a bajillion sources globally. I would like Google Sheets to format the phone number field specifically to accommodate international phone numbers and phone ...
2
votes
2answers
30 views

Create a grade sheet where it will flag number grades in a certain range by turning that row another color

I'm trying to create a grade sheet where it will flag number grades in a certain range by turning that row another color. The problem I'm having has to do with grades of Zero. I have this formula ...
3
votes
0answers
22 views

Alternate colored lines in Google Sheets that respect filter views [duplicate]

Basically I want the zebra stripes effect for readability but all the methods I've found so far don't work when using filter views. Does anyone know a way or is this not possible? Update: Using a ...