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
vote
1answer
14 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
20 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
37 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
votes
0answers
18 views

How to implement inheritance in a Google sheet

I have a sheet in Google Sheets that has several complex formulas that will be used many times over by other sheets. Additionally, improvements are regularly being made to these formulas. As of now, I ...
1
vote
1answer
27 views

Google Sheets - Split row into multiple rows

Current: ------------------------------------------------------------------- | Amy | Adam | Bob| Cliff | Dave | David | Derek |...| Zachary ------------------------------------------------------------...
1
vote
1answer
25 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
21 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
27 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
25 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
57 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 ...
1
vote
1answer
27 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
19 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
27 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
79 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 ...
1
vote
1answer
17 views

How do I keep borders when dragging down to fill cells?

I have a large scheduling spreadsheet of dates and names, split up by week, with borders for clarity. I want to be able to autofill the dates by dragging down the cell. Sometimes I also want to fill ...
0
votes
1answer
29 views

Google Side bar & editing form responses [on hold]

I have some code which captures the URL of the edit response, so you can click it, and amend the record if needed. It pops out and opens in a new window. I wondered if it was possible to open it ...
1
vote
1answer
20 views

“Superset” Checkbox

I have two checkbox columns E and F. I want F to be the "superset" checkbox column, meaning that every checked cell in E means the corresponding cell in F must be checked as well. I can populate ...
2
votes
0answers
34 views

Opening Google Sheets to A Certain Cell or Column

I am trying to make it so when anyone who is in this weekly calendar opens the doc, it locks to the week we are currently in. Our dates are in row 4, going across the top of the doc and run from June ...
1
vote
1answer
28 views

Offset called JSON into the next column

I am trying to check for emails based on domain names stored in a column in Google Sheets. I have the API call setup and working, but the data gets pasted into the selected cell. I would like to paste ...
1
vote
0answers
15 views

How to search within an Array to a range in Google sheets and setFontColor to blue [closed]

Don't know why this is puzzling me but I want to search for all parts listed within the primeparts array shown below and find them in a table then color the text blue. So to clarify, using the partial ...
-1
votes
1answer
22 views

Find and Replace (CTRL+H) script on Google Sheets

I'm looking for a "find and replace" script for Google Sheets. I have phone numbers on column C, which are in a ###-####### format. I want to make a script that will replace the "-" to nothing. ...
1
vote
0answers
10 views

Auto adding date to cells having data [closed]

All the people in my sheets are adding data to different cells in different days and I want to know when they did them because difference between the registered data by different people is very ...
1
vote
1answer
52 views

Google Sheets countif attendance sheet, quarterly report

I have a Google Sheet that I use to track attendance at an open lab that I run. Each quarter I put together a report where I count the number of people that attended that quarter. If I just use the ...
1
vote
0answers
11 views

Survey Data & Google Sheets: Excluding Missing Values?

I am using survey data in Google Sheets with rows for "before" and "after" responses, with the same survey administered to the same subjects at two different time periods. With each question, a number ...
1
vote
1answer
28 views

Exporting to PDF from Google Sheets removes emoji

I have designed a schedule in Google Sheets that uses emoji to indicate the character of each days activities. They display perfectly in Google Sheets. I want to physically print the sheet but when I ...
1
vote
0answers
22 views

Google Sheets Calendar Monday start of week

I don't want my weekday to start on a Sunday, who does? I want it to start on a Monday like most normal people, but impossible to find a way to do this. It's Ok on Google Calendar, you go to 'settings'...
-1
votes
0answers
29 views

Google Sheet Link from WordPress site

So I am looking at a WordPress website and I'm trying to get the link to a Google Sheet that was embedded to make a copy of it. By going to into the page source of the WordPress site I was able to ...
0
votes
0answers
11 views

TypeError: Cannot read property “audits” from undefined [migrated]

I cannot seem to figure this out. I can run this script to pull in Pagespeed Insights some times, but lately I've been getting this error "TypeError: Cannot read property "audits" from undefined." I ...
2
votes
1answer
292 views

Struggling to Generate Chart From Existing Data

This question is specific to Google Sheets—hopefully I’m in the right place. https://docs.google.com/spreadsheets/d/161rtpjNK5363-U6y6MZYzqOIx7CQBCHDWInBXFtZYIg/edit?usp=sharing As you’ll see above, ...
-1
votes
0answers
11 views

Google Forms to Google Sheet Multiple Cloud Print

I am looking for a solution to a problem i have, so i have a google form with a dropdown to multiple number options (1-20), the form transfers the info onto a google sheets form, and through google ...
1
vote
1answer
24 views

Combine Google sheets data with the same header names

So, I have a data where several columns have the same column names. I would like to arrange these column names alphabetically and then combine the entries of columns with the same column name into a ...
1
vote
1answer
22 views

Automatic value depending on drop down list

I have a drop list in D24, you can choose between Junior, Mid and Senior. I want E24 to have a different value depending on the choice. Junior= 21.43€ , Mid= 28.57€ , Senior= 35,71€ Then, I want to ...
1
vote
0answers
14 views

Attach a default color palette to my account?

I have a bunch of specific colors that I use for my gSheets & gDocs, but every time I open a new file, I have to start over again and apply my colors. How can I set it up so that Sheets/Docs ...
1
vote
1answer
20 views

Assigning a value to a letter in Google Sheets

I would like to know how to assign a specific value to selected letters and later on use the letters in a formula which will return a value. There are few letters in one cell, they can be seperated ...
-1
votes
1answer
13 views

DeleteRow Formula parse error. Google sheets

I am not sure what I am doing wrong. I want to delete the row if it is True.
0
votes
0answers
11 views

IF formula to subtract from amount in another cell

I am setting up a Google Sheets spreadsheet with a few columns as follows:- Pref|Room|Item|Price|Got I have a formula to add up the total of all the cells based on the room and if they are a ...
1
vote
0answers
28 views

why does this array formula on google sheets display no match when i add a new row?

hi and thank you for reading my post. please help me with my array formula. the goal of the formula is to display the status on the column of my work sheet (queue, working, done and blank). it works ...
0
votes
1answer
19 views

Having Problems with SUMIF in Google Sheets

Having a bit of an issue with SUMIF in Google Sheets. Currently, I'm pushing data from Google Analytics into a workbook. From there, I'm then taking the data and combining it to show how much ...
2
votes
1answer
21 views

Google Sheets sharing based on dynamic list?

I'm betting this is way beyond Sheets' capabilities, but my workgroup is large and changes frequently. It would be ideal to be able to share Sheets documents based on a column of values in another (...
1
vote
1answer
14 views

How to Change Agregated Data to Continuous

I would like to change the following two graphs in this link here Problem 1 Under the chemistry and physics tab I have a graph like this: Which is an agregate data set, but as you can tell the x-...
1
vote
0answers
10 views

Arrayformula with iferror and vlookup does not update automatically

My spreadsheet is for inventory checking. I use several of arrayformula ,iferror and vlookup. The problem is I just noticed that sometimes the formula does not update. It might because I duplicated ...
0
votes
0answers
14 views

How to find the original source to get the xPath

I'm trying to get an updating list from a store on Taobao.com I've tried using importxml to get the list using xpath but I keep getting "import content is empty" error. =IMPORTXML("https://...
0
votes
1answer
34 views

How to change the values of a pie chart to absolute values instead of percentages in Google Sheets

I want to be able to change the percentages under each of the fruit names to absolute numbers (the respective quantities). I tried changing the 'slice label' but that only added the numbers over the ...
0
votes
1answer
26 views

Help needed with script that auto-updates cells in column in Google Spreadsheet showing last modify date

I'm looking for some help with a script for a spreadsheet. I found a script (see below) that does half the trick for me, but I encounter two difficulties. What I am trying to accomplish is the ...
0
votes
0answers
14 views

Pasting values depending what column cell is in

Afternoon, I have this script where if I press delete, or edit, it takes the value and puts it in A6. Now I'm wondering how I make it so that if the cell value is from column A, it puts it in A6, but ...
0
votes
2answers
18 views

Transpose notes / comments in Google Sheets

I've a Google Sheet. I've transposed the data. Is there a way to also transpose any notes/comments that are attached to cells in the original data set?
-1
votes
1answer
10 views

How do I stop my sheet from being randomly filled by =SUM(-1,1)? [closed]

This is some sort of very strange bug. I am creating a spreadsheet using conditional formatting and colour-coding: in one (and only one) of the columns, the cells are randomly and automatically ...
1
vote
1answer
26 views

Query & date formatting

I have run into an issue where I have a query formula that acts like a filter on multiple criteria. I have been trying to add into it the ability to search between dates as well, with intermittent ...
1
vote
0answers
22 views

Google sheets script add data in next column

I'm trying to modify a script to create a PageSpeed report that pulls in certain KPI's from Google Pagespeed API. Once the data is received, i want it to place those KPI's next to the URL and so forth....
0
votes
1answer
43 views

Splitting the contents of a comma separated cell into new rows

Based on: https://stackoverflow.com/questions/52376162/combining-column-data-in-google-data-studio I have a long list of data, about 200 rows, and each row contains multiple columns of data and a ...