Questions tagged [google-sheets]

For questions about Google's web application to create and edit spreadsheets on a web browser or app. 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 chance that you get a satisfactory answer.

Filter by
Sorted by
Tagged with
2
votes
1answer
16 views

Is there a way to copy a selection spanning multiple rows, and paste them as merged cells spanning two rows each, in Google Sheets?

I'm going to be honest; my biggest issue is describing what I wish to accomplish. I can't find the right word for it, so the title might not make a lot of sense. But the pictures should be clear, I ...
0
votes
0answers
6 views

How to link to source cell from filter output

I have a simple query that outputs columns A and B of a project dataset, when the value in column A is not empty: QUERY(Projects!A2:B, "SELECT A,B WHERE A<>''") This creates an easy to ...
0
votes
1answer
7 views

How to copy an image from one spreadsheet to another in Google Sheets

I have added an image into a cell of a Google Sheet, I'm trying to copy-paste it in the cell of a new spreadsheet but doing CTRL+C / CTRL+V doesn't work. I've added the image doing: Insert > Image &...
0
votes
1answer
7 views

Google sheet - highlihghting cell if in the same row other cell not empty

I'm trying to make a worksheet where I log shift hours. I made columns with dates and to each date a row of hours I want the date text to be green if in the same row a cell is not empty.. The code I ...
0
votes
1answer
15 views

Query or filter the data when using date time format

Example sheet. Sheet2 In cell A2 I have: =QUERY(Sheet1!A1:Q, "Select * where B >= datetime '"&TEXT($A$1,"MM-DD-YYYY HH:mm:ss")&"'") In cell A1 I have: 6/17/...
2
votes
2answers
13 views

How to make a Google Sheets cell output any string?

I can type 1+1 in a cell, and then it appears unchanged. However typing typing +1 or =1, it's not being taken as text, due to the prefixes, and it's shown differently. What to type so a cell has shows ...
1
vote
1answer
9 views

Is there a way to filter for a row that matches AND the row above it?

I have a spreadsheet of customer order data. I want to filter it so that only rows matching certain criteria "XYZ" and "ABC" are kept. However, when a row matches "ABC," ...
0
votes
1answer
16 views

Google Sheets for an Automated Shift Bid Process

Hello I am looking for some help because I don't know how to go about this and have been unable to find any resources that guide me on doing what I am trying to do. So I work for an organization that ...
1
vote
1answer
25 views

Multipliers In Google Sheets

I'm trying to apply multipliers to rows within a column total, having issues.. I've tried multiple attempts using ARRAYFORMULA, MULTIPLY, SUM, and combinations of these, with no luck.. Search attempts ...
0
votes
0answers
8 views

Google Sheets chart only shows first ~250 rows?

I have a stacked area chart with an x-axis from B8:B350 and two series from C8:C350 and D8:D350 (so data range B8:D350) but the data only displays the first ~250 rows which is September to May. Any ...
0
votes
1answer
21 views

How do I convert rows with 45 columns into 15 separate rows, each with 3 columns?

I am working with a google sheet that gets data from an email parser. Each time an email comes in, a single row is created, and fills in these columns: B, C, D, E, F, G, H, I, J, K, L, M, N, O, P, Q, ...
1
vote
1answer
20 views

Creating Hyperlinks of Google Drive Items in Alphabetic Order

The original post that I got the google script editor code from was here: Get share link of multiple files in Google Drive to put in spreadsheet It works perfectly fine, but what I want to do is show ...
0
votes
0answers
11 views

What's the equivalent of Windows F4 to make a cell reference absolute (e.g. $A1$1) in Google sheets?

What's the equivalent of Windows F4 to make a cell reference absolute (e.g. $A1$1) in Google sheets? Online searchers tell me it's apple (command) + T but this just opens up another tab in Chrome. I ...
1
vote
0answers
26 views

How to make this Google Sheets script dynamic?

I'm working in a script to paste a table on the same sheet, in my code I'm only pasting the table on the row A18 function NewQuote() { var ss = SpreadsheetApp.getActive(); ss.getRange("A18&...
0
votes
1answer
18 views

How to run a different script on multiple Google Sheet tabs?

The code writes an auto email once a trigger is met in the sheet. There are 3 different tabs pulled from the main sheet and each tab should run the script but with a different message for each tab. ...
-2
votes
1answer
14 views

Google Sheets: How can I query all names and display it in another sheet according to it's category?

So I have an employee list and a checkbox according to their skills. How can I get the employee list and display them to another sheet?
1
vote
1answer
25 views

Howto sync offline sheet from Sheets app

I did some offline work on a google sheet file on my mobile using Sheets app. I actually did not realize that I am offline, as I never set this option, at least not on purpose. After I connected to ...
1
vote
1answer
27 views

Trying to fetch data from www.csgoempire.com with ImportXML function

I am trying to fetch data from this link using Google Sheets' ImportXML function. This is a betting site, and the link displays a list of roulette roll IDs on 26 June 2020. I am trying to fetch that ...
1
vote
1answer
36 views

Google Sheets formula to find rows with matching values, looking up in multiple columns

What would be the Google Sheets formula to search for a matching value in a range that goes across multiple rows an columns? For example I need to search the entire range H:P (all rows and columns) ...
1
vote
1answer
9 views

Matrix multiplication-esque concatenation?

I'm making a simple recipe maker in google docs, using row vectors and sumproduct I can get it to calculate the protein and calories for a given recipe. The way it's set up it can be hard to read the ...
1
vote
1answer
15 views

Regular Expression to wrap phrases between commas with carets (^)

I have a Google Sheet with example information like this Education, Conservation, Health, Human rights, Rural development, Poverty alleviation, Water and sanitation. -------------------- Human rights, ...
0
votes
1answer
12 views

How to best put many images on Google Sheets?

I need to put a lot of images on my Google Sheet but that makes the file so big. What I want is to put a link or something which can redirect us to another window which contains all the images.
1
vote
1answer
21 views

Referencing a cell from another sheet using a value in another cell

I'm trying to find a way to reference a cell from another sheet using a value in another cell from the "home sheet." I've tried to use INDIRECT but I'm not quite sure how to use it when the ...
0
votes
1answer
30 views

How to get a numerical value of a date with Google Apps Script?

I have a value 0.000347222222222222 in a cell, which when formatted as time, looks like 30/12/1899 00:00:30 . How to get it's numerical value with Google Apps Script? sheet.getRange('A1').getValue() ...
-1
votes
0answers
13 views

ImportXML - Empty error

I'm trying to learn how to use the importXML function in Google Sheets, but I'm still struggling. I'm trying to build a database from Tiktok. Here's a sample page : https://www.tiktok.com/@unmigration?...
-1
votes
0answers
10 views

Running over parameter space in Google Sheets

I've built a model in Google Sheets that with a few parameter cells and a few result cells. I'd like to analyze the results of the model while testing parameters over a specific range. Is there a way ...
0
votes
2answers
36 views

Allow users to make yes/no decisions using checkboxes

I'm looking for a way my users can interact with my scripts. I'd like to use checkboxes to work like a "yes/no" command, where the script does "A" if the checkbox is ticked, and &...
1
vote
0answers
27 views

Isolating conditional formatting to each range in a column

I've set up conditional formatting to highlight the top 3 values (gold, silver, bronze) in a range of rows. However, I want to be able to copy/paste the conditional formatting below the initial rows ...
0
votes
0answers
18 views

Automatically Increase Document Number/Cell Number on open

I would like to be able to click on something which will open a new google sheet based on a template. I would need cell A1 to contain a number which increases by 1 every time the template is opened. ...
0
votes
1answer
14 views

Macro to move down and separate data

I wish to use a macro in Google Sheets to find the number 1 in column A then move that corresponding row and all following rows down to start at A9 row then find the number 2 in column A then move ...
-1
votes
0answers
11 views

I want to Extract that URL inside href with importxml in Google spreadsheet,

<a href="/online-applications/applicationDetails.do?activeTab=summary&amp;keyVal=QBLTQ4TYMGK00" id="tab_summary" class="active"> <span>...
0
votes
1answer
19 views

How to Jump to Column Based off of Cell Value

My expected result is very simple - I have used data validation to place a list of column titles in a cell. When a user selects a column title and clicks the button, I want them to be taken to the ...
0
votes
0answers
26 views

How do I make filters auto-refresh when cells are updated via the API?

I have the following function running in Apps Script, however the onEdit function is only called via manual edits. It does not work when I edit the sheet using the API. Here is the function: /** * ...
0
votes
0answers
7 views

Insert png image to Google Sheets or other cloud based structure in Python to be used in Tableau

I am pulling this sensor data and have an image (heat map) that I want to put in some cloud based location where I can easily pull it from Tableau. The problem - Tableau has preset web connectors so I ...
0
votes
0answers
12 views

How to combine importrange condition with ifcondition?

I would like to ask, how to use IF condition in IMPORTRANGE condition. I want to connect sheets like : In Sheet 1, I want to apply "condidtion IF" for example: IF(A2:A10="black";...
0
votes
0answers
19 views

Convert table into list

I need to convert a table into a list so it can be used as a database Into this:
0
votes
0answers
10 views

Is there a way I can format text to change color in Google Sheets based on the time and date?

I have a weekly schedule that I have set up in Google Sheets in the following way: I have a weekly schedule that I have set up in Google Sheets in the following way: I use this to schedule ...
0
votes
2answers
35 views

How do I keep all the values when I split a cell by delimiter (comma) in Google Sheets?

I have a spreadsheet in Google Sheets, where I am currently running a script. There are two tabs, the first tab is the following: The second tab is the following: This is the script I am running: ...
1
vote
1answer
13 views

How to open sheets to a specific tab based on days of the week?

I have a file with 7 tabs or sheets each of them represent a day of the week (Monday to Sunday). In each day (Tab) a have this formula in B2 to show the day of the week if it is today... =IF(WEEKDAY(...
0
votes
1answer
17 views

Google Sheets conditional formatting based on cell above it

I have a column of blank cells. If I type something into a cell, I want the cell immediately below that one to turn red. Any ideas for conditional formatting help?
0
votes
1answer
48 views

Why is Google Form stuck on “Updates made after release”?

I was trying to find a way to ask help for Google Forms so I hope this is an acceptable place (official forums > no answer). I am using Google Forms to create quizzes for my students but when I ...
0
votes
1answer
15 views

Conditional format based on data in 2 columns

I am trying to create a conditional format that will highlight cells across 2 separate columns based on data in both columns: So I need to highlight all cells in column A that is greater than 0 AND ...
0
votes
1answer
15 views

IMPORTRANGE query with checkbox

I'm trying to do an IMPORTRANGE with query with checkbox. However I keep encountering parse error. =QUERY(IMPORTRANGE("1pzzOzjtJ8GJOWnkBozdO0anKHnbeREvadEc4rzY4ezI",'Guest Speaker Tracking'!...
0
votes
1answer
12 views

Google Sheet Script for automatically entering date/time stamp when the adjacent column

I've found a script on here for entering a timestamp in a column based on edits to the adjacent column: Date and time stamp automatically added in column if(e.source.getActiveSheet().getName() == &...
0
votes
1answer
17 views

Count rows that fall between two times

Looking to get the count of rows that fall within a certain hour of the day. I can perform IF statements against the times, but not COUNTIF(S)... So far I have tried: =countifs(timevalue(A2:A),"&...
0
votes
1answer
19 views

How to convert a numeric value into a time format inside a formula that also contains a string

I have a "mixed" formula (containing numbers and text) and I need to convert the numeric values into a time format. Here is my formula: =count(J8:J11)*2/24&" / "&sum(K8:K11)...
-1
votes
1answer
25 views

Create multiple menu dropdowns based upon 1st rollover, 2nd rollover, 3rd rollover etc

Example: User selects a cell for dropdown. Dropdown shows A,B,C,D,E,F. Upon rollover of B, a new 2nd dropdown populates with RED, BLUE, GREEN, PURPLE. Upon rolling over GREEN, a new dropdown ...
0
votes
1answer
11 views

Show image if rank equals number

I have a row of 5 cells. I want to show an image above each cell depending on the rank of the cell. So if the rank of the cell equals 1, show a specific image (from a link), if the rank is 2, show a ...
1
vote
1answer
16 views

How do I pulling in historical daily trade volume data in Google Sheets with Google Finance?

If I try =GOOGLEFINANCE(A1,"volume",A2) where A1 is the stock code and A2 is the date I'm querying, it comes back printing 'date' and 'volume' on one line as headers and then the data on the ...
0
votes
1answer
17 views

Calculate average across rows that match an ID and a word - Google Sheets

Table is as follows: I want calculate the average of values in column C for rows with value "ABC" in column A and value "Yes" in column B. So, basically, the average of values 2 ...

1
2 3 4 5
126