Questions tagged [google-sheets]

For questions about the Google's web application to create and edit spreadsheets on a web browser. Don't use it for the Google Drive Excel files editor. Please consider adding a demo spreadsheet to your question, this will greatly increase the chances to get a satisfactory answer.

Filter by
Sorted by
Tagged with
-1
votes
1answer
21 views

What do <> (angle brackets) mean in Google Sheet formulas?

What does <> mean in a spreadsheet formula, such as: =A1<>B1
2
votes
2answers
25 views

Multiple IF-statements in a single cell - checking long list of results [duplicate]

I have a Google Sheets where I enter all the results of my beer pong matches with friends. I'd like to see my amount of wins/losses with certain friends. This can be done with =IF(AND(B2="Won",E2="...
-1
votes
3answers
14 views

How do I sort data by size and not in ABC order

I am new to Google Sheets and have only used Excel a little, so Google Sheets is a bit different. I want to sort our band uniforms in size order from smallest to largest but Google Sheets only sorts ...
0
votes
0answers
14 views

Disable printing / downloading spreadsheet for editors - Google Drive Sheets? [duplicate]

I know it is possible to disable printing and downloading a Google Drive Spreadsheet for viewers, But is it possible to disable the same for editors other than the owner ?
1
vote
1answer
17 views

Create a Google Sheets graph with multiple lines in the same chart

I have data that looks like this: Name X Y Bob 0 15 Bob 3 20 Bill 0 24 Bill 5 30 And so on. Basically I want to have a line for Bob, a line for Bill, etc. With X as the X-...
1
vote
1answer
22 views

Allow others to make google spreadsheet copies that retain the view/edit permissions of its parent spreadsheet

I have a google spreadsheet with the permission "anyone with the link can view" so that I'm the only one able to edit but people can look at it freely. I have also been giving people the https://docs....
0
votes
2answers
20 views

How to filter after parsing CSV values contained in Google Sheets cells

I would like to be able to match all cells in column A (titles) that have one of the comma-separated values in column E (Key Search Terms). This will involve at least two steps. 1) Parse each of the ...
2
votes
2answers
36 views

How can I quickly change the color of text in a cell in Google Sheets?

How can I quickly, with either a single or double click, assign a color to the text in a cell in Google Sheets? In order to quickly determine the status of certain pieces of data in a spreadsheet I ...
0
votes
2answers
30 views

How can I set this up to run two onedit functions in the same sheet?

all If you put the two together they don't work What is the right code to work together Note that the first to arrange automatic The second is to set the date if you put only one works, but if you ...
0
votes
2answers
51 views

IF and IFS not working properly

I am trying to locate data present in different sheets. I have tried using IF and IFS. Below are the formulas I have used. For IF, I get NOT IN USE even when I know there should be one of the sheets ...
0
votes
1answer
24 views

Trying to use Google Sheets importHTML() to import a table. But no content appears

I'm attempting to load the following website into Google Sheets: https://www.lasvegasadvisor.com/vegas-lines/?sport=ncaafb&period=0 Can anyone help provide a formula that would work in google ...
0
votes
0answers
21 views

How to customise ordering of segments in stacked waterfall chart using Google Sheets

I've drafted a stacked waterfall chart in Google Sheets (shown below). By default, the ordering of stack segments are as follows: In Column A: Apples, Bananas, Carrots, Durian from top to bottom In ...
0
votes
0answers
20 views

Unable to position custom data labels in center in Google Sheets waterfall chart

Context I've drafted a stacked waterfall chart in Google Sheets, with custom data labels (guided by Ben Collin's tutorial on custom data labels). My goal is to have the custom data label positioned ...
0
votes
0answers
17 views

Match based on row with lowest value

I'm finding the index of a row using another text value in a row as a reference to add a value to a "unit cost" column: =INDIRECT("Sources!I"&MATCH(A5, Sources!A:A, 0))*CONVERT(C5,D5,INDIRECT("...
0
votes
0answers
39 views

Using Google Forms to create an automatically updating inventory

I have created a Google Form that is used for people in the office to request items (swag given to donors). After an item or items are requested, the request must be fulfilled by a team member. I ...
0
votes
0answers
10 views

Google Sheets ImportHTML formula not pulling table I need [duplicate]

I have a Google Sheet trying to pull website table using ImportHTML formula to get a table from https://mesowest.utah.edu/cgi-bin/droman/raws_ca_monitor.cgi?state=AZ&rawsflag=3 ImportHTML(https:...
2
votes
1answer
18 views

Conditional Formating for Google Sheet comparing to list of text (highlight duplicates)

I am trying to create a custom formula for conditional formatting. I want to highlight the cell if the text appears in a list of names. This list will contain 210 unique names so I can't type each one ...
1
vote
1answer
43 views

How to countif with dates before today's date that auto updates

I am trying to use countif to count a certain number prior to today's date. So if today's date is 8/15/2019 the formula would count the number that is the B column that had a corresponding date prior ...
0
votes
1answer
19 views

Query runs but returns first row greater than the DATE at 00:00:00 not the row after 10:00:00

Trying to use the following query: =query(WABrdg729!A:B, "select A, B where A > date '"&text(datevalue($A$6), "yyyy-mm-dd")&"' AND A > timeofday '"&text(timevalue($A$6), "hh:mm:ss"...
0
votes
1answer
23 views

Conditional Formatting in Google Sheets based on the same rows conditional format

I have a spreadsheet where I have tasks, and I prioritize those tasks based on high, medium, and low levels. I currently use conditional formatting for this, so if I select from a drop-down "HIGH", ...
0
votes
1answer
25 views

Sequential numbers via formula - Google sheets - IF & MAX

I use this formula to find highest value in column A of other sheet, and then add 1 to it to get new unique number for a record ID, and I use... =if(B3<>"",max(Backend!A3:A)+1,) with this ...
0
votes
0answers
11 views

Automatically copy new imported entries into another sheet

So I'm using importjson to import a json feed into my google sheets. =importjson("url") It updates with 10 new entries a day. However, it doesn't save old entries, it just updates with new ones. ...
0
votes
0answers
20 views

Race results as race is being run

i have a sheet for a multi lap race. At any point I want to print the current standings. Racer D is currently leading having gone the furthest, racer B in 2nd, and so on. How can I get the current ...
0
votes
1answer
25 views

Google Sheets - summing numbers across a spreadsheet depending on the Column header

I am looking to automate our timesheet process. Each staff member has their own separate Google Sheet which has the dates down one column, and then a varying number of columns named after different ...
1
vote
1answer
19 views

Concatenation within IMPORTRANGE

I'm completely stuck on this one -- I need to use IMPORTRANGE function but want to make the sheet it pulls from flexible via concatenation -- here is my formula with a scrubbed URL: =importrange("...
0
votes
0answers
38 views

Open Gmail compose window in same window if clicked on Google Sheets comment reply?

Below is an example of an email received from Google Sheets comments. If I click on "Reply", the compose window opens in a new browser tab. Is there any way to make this compose window open in the ...
1
vote
0answers
17 views

How do you “Paint Format” more than once in Google Sheets?

In Google Sheets you can select a formatted row, click the "Paint Format" Tool, then click another row to apply the same format. You can drag down to do multiple rows if they are together (say rows 50-...
1
vote
1answer
51 views

Create table showing difference between values in two pivot tables

Our bookstore has two separate documents in Google Sheets (one containing purchase data and one with sales data). Each document contains a sheet with a pivot table that sums up total purchases/sales ...
0
votes
1answer
13 views

How can I group rows in Google Sheets and sort

I have been trying to group rows in Google Sheets. I have a heading (name) and then the information that must be included on the sheet without losing the spacing or lines. How can I do this ...
1
vote
1answer
27 views

Extracting specific phrases from a cell and echoing them in another

Longtime learner, first time poster here! I was wondering if anyone knew how to extract specific data points (phrases) from a Google Sheets cell and echo them in another cell. For instance, in my ...
0
votes
0answers
14 views

I need help auto-incrementing a column in google sheets based on data in another column

I'm working on a spreadsheet linked to a google form and I need to generate an ID for specific response. The form has 2 types of entries: New Entry and Update Entry. I need to assign an ID to the New ...
0
votes
0answers
11 views

How to make one cell automatically update a timestamp every time another referenced cell is updated? [duplicate]

I want to make a cell in my spreadsheet that updates a timestamp every time another cell is updated. I have a SUMIF connected to a budget inflows/outflows tab in my spreadsheet and I want this cell ...
1
vote
1answer
10 views

Setting a trigger to send mail when data is added to a row that was empty

I`ve got an external app that sometimes adds data to the last row of a sheet, is there a way to trigger this to send a mail with the content of that row?
1
vote
1answer
22 views

How to generate a range of serial numbers by formula?

I want to produce an array of numbers from 1 to n, where n is a value in another cell. So if the cell value is 10, I want to generate an array of the numbers 1 to 10. I found this resource which ...
0
votes
1answer
64 views

Syncing Google Sheets to Google Calendar

Automatically add a schedule from Google Sheets into Calendar I followed the instructions in this video: https://www.youtube.com/watch?v=MOggwSls7xQ and it works fine. However, the one thing that ...
0
votes
2answers
41 views

Chronological ordering of checkbox in Google Forms

I have a checkbox in my Google Form, which sends the user selections in the form in an ascending order list: But I want to grab the list in the order of selection, for example if the user clicks in ...
0
votes
1answer
42 views

How do I add values from one sheet based on a dropdown that references the other?

I have 2 sheets with the same columns with integer values. In sheet A I have a drop down list of the names in sheet B. Based on what drop down I have selected, I'd like to add the values of sheet B to ...
1
vote
1answer
18 views

How to highlight cell if it's value is a multiple of a given number

I would like to apply conditional formatting to any cell within a range containing a value that is a multiple of itself. IE: Apply bold font to any cell of column A that is a multiple of 4 (4,8,12,16,...
0
votes
1answer
32 views

Reference an array's data in Google Sheets

Per Google Docs Editors Help > Using arrays in Google Sheets: Any function that takes a range (e.g. A1:B6) as an input parameter will also accept an array in its place. For example, SPARKLINE ...
1
vote
2answers
55 views

Issues with Google Script on collecting Form responses and moving to another sheet

I have been trying to piece together some code for a task at work using Google Sheets and I am having some issues with what I can find versus my current knowledge level. I am trying to create a script ...
1
vote
1answer
46 views

Google Sheets - Split row into multiple rows

Current: ------------------------------------------------------------------- | Amy | Adam | Bob| Cliff | Dave | David | Derek |...| Zachary ------------------------------------------------------------...
1
vote
1answer
28 views

Conditional row sum

I'd like to sum a column of cells if the corresponding cell on the next column contains a string of any sort. I've tried using SUMIF but I can't figure out how to combine it with ISBLANK or ISTEXT. ...
-1
votes
1answer
28 views

Google Spreadsheet Trigger which will fire when the active selection changes for a given sheet

This would be equivalent to the Excel Worksheet_SelectionChange event.
0
votes
1answer
31 views

Help with complicated math and syntax

I am trying to create a calculator for this mobile game that I play (Lord’s Mobile) but cant seem to figure out the formula. 1) In this game, you can get your upgrade time reduced when your guild ...
1
vote
0answers
30 views

In Google sheets is it possible to have a combined chart with stacked columns?

I currently have a simple combined chart with a revenue line and columns. For what I am trying to communicate with this graph, I would really like to have stacked columns in addition to my revenue ...
1
vote
1answer
342 views

Send a Google Forms response to specific email address based on form response

I need to send Google Forms responses to specific clinicians at my practice depending on whether they have been selected on a drop-down menu in the form. At the moment, Google Forms sends an email to ...
2
votes
1answer
38 views

How can I select all cells that contain specific text in Google Sheets?

I have a spreadsheet that contains 20,000 cells. I want to select all cells that contain "foobar". How can I do this?
1
vote
1answer
22 views

Querying for the last results with group by

I've got the following data sheet: date(A) source(B) cost(C) totals(D) val(E) 9-8-2019 Magic 0.00 0 0.00 9-8-2019 Stick 54.72 6820 ...
1
vote
0answers
28 views

Conditionally format a column if it contains all the values in a set

Each of the columns in my Google Sheet represent a farm. Each farm is a list of animals. I want to highlight the entire column if the farm has a duck, a horse, and a cow. So the column may look like ...
1
vote
2answers
181 views

Is there a way to allow users to access Google Sheets with installable triggers without manually signing in?

I have set up a Google Apps Script that validates data that is entered into various Google Sheets files. I am looking for a way to allow users to access those Google Sheets files without making them ...