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.
5,374
questions
1
vote
1answer
20 views
Google-sheet IF function not working
I need a formula in Google spreadsheet that will:
+1 when the value is >=5,
+2 when the value is >=10,
+3 when the value is >=15,
+4 when the value is >=20,
+5 when the value is >=25
...
0
votes
1answer
19 views
Using Google Sheets cell reference in SOQL Query
I'm using Data connector for Salesforce Google Sheets add-on to pull Salesforce information into a sheet via SOQL queries.
I'd like to use a cell reference from my sheet inside one of those queries, ...
0
votes
0answers
16 views
why Google Spreadsheet is not Displaying Name and Picture? Even When logged in? [closed]
I have tried in many ways, My Id and picture is not displayed in sheet where others can.
how can i modify or edit that?
is this a bug?
or is there any possible ways to resolve this?
1
vote
1answer
27 views
Is it possible to have a value inserted by data validation automatically update when the source updates
Basically, on one page I have some fields with a simple data validation "List from a range", which gets its items from some fields on another page.
When I update the values on the second page, it does ...
-1
votes
0answers
38 views
Number of times a csv can be downloaded in one day
I have an app that we use for competitions; it displays the weekly schedule for the competition. The schedule is created in Google Sheets - there are 8 columns and approx 800 rows of data...a mere ...
0
votes
2answers
14 views
Will working with an active Google Form responses sheet mess anything up?
I'd like to sort rows and remove duplicates while the form is live and the responses sheet is receiving incoming responses.
Will my working on the sheet while a response is coming in cause any ...
-1
votes
0answers
56 views
+50
How to extract business phone number from address in Google Sheets
Is it possible to extract a business's phone number from the address? I know there are scripts that can be made to extract things like ZIP code from address, but I figured since Google organizes the ...
0
votes
2answers
45 views
How can you *turn off* the new “Show Edit History” feature in Google Sheets?
I turned on "Show Edit History" for one cell in a Google Sheet and now I want to turn it off for that one cell.
I can't see any way to do so. If I right-click on the cell I see "Show Edit History" ...
3
votes
1answer
137 views
Parse JSON from Google Spreadsheet Cell
I am working on an API with google spreadsheet and app script to retrieve JSON response; I am using ImportJSON function (custom function by Brad Jasper and Trevor Lohrbeer) to retrieve and parse JSON ...
1
vote
0answers
34 views
Google Sheets - Query Multiple Columns for same Data
We have Employee training data in a Google 'Form Response' spreadsheet which ranges from A1 to JQ1000. This spreadsheet is automatically populated when a Google Form is completed but it is difficult ...
0
votes
0answers
30 views
Google Script error when trying to move row to another tab
Using the script below to try to move a row from one tab to another and getting the following error I can't figure out
TypeError: Cannot read property "length" from undefined. (line 20, file "Code")...
1
vote
0answers
15 views
How to use “aggregate” chart feature on Google Sheets
Line graphs and most other types in Google Sheets have a checkbox for "aggregate" in the setup tab. I've tried looking through the instructions but I can't find any documentation on how to use this ...
-1
votes
0answers
18 views
how to publish google sheets app to the web?
I have a google sheets app where a person selects an item from a dropdown, enters a value in a cell, and then presses a button for processing, and it works perfects as a sheet.
But when I publish ...
0
votes
1answer
134 views
How can I easily link to a bunch of files in my Google Drive from a Google Sheet (in the same account/drive)?
I have a bunch of PDF files in a single folder (say "myPDFs") in my Google Drive.
I have a Google Sheet stored in the same Google Drive. One column of this Sheet has the filenames of the PDF files. (...
0
votes
1answer
32 views
Import Form data into a sheet
I am trying to accomplish something that may not be possible. My work rents equipment to multiple companies and my boss wants me to setup a "database" of rental equipment and where its located and any ...
0
votes
1answer
16 views
How can I create a filter on Google sheets to filter only words that begin with uppercase?
I have a column with 2 kind of words:
words without uppercase (betrachtet) and
words that begin with uppercase (Analysieren)
I need a filter that shows my only those words which begin with uppercase....
1
vote
0answers
45 views
Multi-Column Repeating Values with new dates
So I am making a sheet with three columns that I want repeating except for every new three columns I want to have a different date (previous date+1). I am unsure as how to go about this, I have seen ...
1
vote
1answer
49 views
How to determine which working day of the month today is?
Using Google Sheets, I need to know what the numeric working day of today is. Somehow I'm just missing something here.
I can already easily determine the number of working days remaining, with
=...
0
votes
1answer
25 views
Aggregate Formula in Google Sheet using wildcards
I'm trying to copy and paste an excel formula I use to categorize data into Google Sheets and struggle as the formula doesn't work.
I have two sheets:
The Referral sheet contains all the referral ...
1
vote
1answer
15 views
Google Sheets - Duplicate Tabs Automatically with Numbered Names [closed]
We are currently building a KPI file for our sales team. I currently have a Google Sheets file with a Monthly tab and one tab for each day of the month (1, 2, 3, 4) and so on. I would like to make a ...
-1
votes
1answer
39 views
auto-fill for new values in google spreadsheets
I have a google spreadsheet that connected to the google form,
this form has the name, family name, email address and... questions.
I want my spreadsheet takes name and family name and combine them ...
-2
votes
1answer
13 views
Calculate conditional total
I would like to compute for the total unpaid (status is a checkbox,true/false) for any specific person.
Name Amount Paid
Me 100 ✓
You 20 (unchecked/False)
Me 50 ...
0
votes
1answer
65 views
Google Sheets - Conditional Formatting question
So I have it set that if a cell has a value of 0 to change the background to yellow. I want to have it so that if there are two 0's (zeros) next to each other in a row (edit: in adjoining cells not ...
0
votes
1answer
28 views
Problems with SUMIFS function
I don't understand why SUMIFS function works with some columns in the same worksheets and for others it doesn't. This is my formula:
=SUMIFS(EURO;AGENZIE;"ABN";MESI1;"01")
where EURO, AGENZIE, ABN ...
0
votes
0answers
21 views
Why Function onEdit dosent work for sorting? [closed]
I try to use the following code:
function onEdit(e) {
var spreadsheet = SpreadsheetApp.getActive();
spreadsheet.getRange('J3').activate();
spreadsheet.getActiveRange().autoFill(spreadsheet....
1
vote
1answer
30 views
How to access all public files shared by one user in Google Drive
Is it possible to access all public files in Google Drive if I have only one link? They are are obviously public as I can access the ones where I have a link, but I would like to obtain links to other ...
0
votes
0answers
31 views
Need to move auto move row in Google Sheet
I need a to move all rows that have the word "wine" in column E to a a different sheet that is labeled "Wine" in the same Google Sheet. I have been trying different scripts but have not been ...
-1
votes
1answer
23 views
GAS MailApp.SendEmail - include multiple attachments using ss cell value
I have file names separated by commas (no spaces) in a google sheets cell 'filez1.pdf,filez2.pdf'.
If I assign a variable as a string;
flist = "filez1.pdf,filez2.pdf"
or an array
flist = ["filez1....
0
votes
0answers
15 views
I need to check if the number belongs to the set
Students id numbers must coincide with the numbers in the database (right bottom corner) for cast votes to count.
So I need a system to check it.
0
votes
1answer
13 views
postEdit functions getting range
Does anyone know how I can change the below function to postEdit rather than onEdit?
I am trying to set this in an autoSort function so that the sheet will be edited only after all values in an ...
0
votes
1answer
11 views
Google Data Studio - Sum of 2 fields from different data sources
I'm just getting started with Google Data Studio. I have connected 2 different Shopify stores to it, which worked totally fine.
Now I try to show the sum of the revenue of both stores, but the ...
3
votes
1answer
31 views
Filter in Filter function Google sheets
I have a Sheet with the prices of some products
Each column is a parameter.
How to use the FILTER() function in order to filter by multiple conditions
In this case I need to filter and see only ...
1
vote
1answer
28 views
Why does close price results have a date shift (one day off) while using GOOGLEFINANCE in a Query
I want to get last 40 days close price of stocks.
I used below formula for the same but the result not showing the last day close price.
=QUERY(
GOOGLEFINANCE("nse:"&B2,"all",$A$2-80,81),...
0
votes
1answer
26 views
Increase my script perfomance and speed
I was ran this script. It worked in more than 30 minutes. I don't know how to make it faster. May be have the way to reduce run time to 5-15 minutes .
strong textfunction sumData1() {
var ss1 = ...
1
vote
1answer
23 views
How to open a hyperlink in the same tab using a keyboard shortcut
How do you open a hyperlink in Google Sheets using only keyboard shortcuts? Google has Alt+Enter which opens the hyperlink, but in a new tab in Chrome. How can you open the hyperlink using only ...
2
votes
1answer
47 views
Split comma-separated cell in sheets while repeating other cell for all entries
I have a Sheet that looks like this:
╔═══════╦═════════════════════════════════════╦══╗
║ ID ║ Users ║ ║
╠═══════╬═════════════════════════════════════╬══╣
║ 12345 ║ ...
-1
votes
1answer
21 views
Can Google Spreadsheets cache images?
I want to create a resource for a browser game and I need to export a ton of character portraits. The url of those portraits is automatically generated with character's id, so you can just load them ...
2
votes
2answers
60 views
Query or Filter formula to 'search for' and 'return' multiple words
I am a basic user of Google Sheets and need help creating a new formula. I am trying to filter a worksheet so that it returns particular information into another sheet.
The filter I have created is ...
1
vote
1answer
22 views
Formula Parse error
Trying to use this formula in Google Sheets but getting a #error! parse error. Any help as to what may be wrong in the above formula
=if(AND(B4="YES",G4=0),(ROUNDDOWN((AVERAGE(I4,K4,M4,O4,Q4,S4))*35%*...
0
votes
1answer
25 views
How to sum specific columns when adding new columns for hundreds of rows?
I've got a sheet in Google Sheets that tracks a large inventory. I want to quickly see the total of the last three months (columns) but ONLY the last three months. So far it looks something like this: ...
0
votes
1answer
20 views
Formatting a cell based off of the rest of the row
I have a spreadsheet keeping track of the various documents that students of mine have been turning in. The first column contains names and each column after tracks a particular document.
Is there a ...
0
votes
1answer
25 views
Copy Rows from Master Sheet to other sheets based on user input
I am trying to set up an assignment sheet for my work team. I have a script to move a selected range from one sheet to another, but is there a way to modify it to have the person doing the assigning ...
0
votes
1answer
20 views
Comparing cell value 450-500 to another cell of value 475 in Google Sheets
I wanted to compare the price range column which will have prices range like 450-500 to another cell value 703.
In this image you can see I need to find column D value (which is the price range) to ...
0
votes
1answer
31 views
Pulling data from a google sheets database
So an assignment fell in my lap at work that is a little out of the ordinary for my skill set. My boss wants to create a google sheets data base to track our rental equipment. I created a handful of ...
0
votes
2answers
65 views
How can I locate a sheet by name from Google Sheets [closed]
I have a Google Sheets spreadsheet with a large number of sheets. I want to find a particular sheet by sheet name from Google Sheets.
I know how to locate a sheet by name using a Google Application ...
1
vote
2answers
37 views
Can I use arrayformula in Google Sheets to count things over a variable range?
Is it possible to create a single arrayformula that does the same thing as the following column of formula:
A1: =COUNTA(B1:B1)
A2: =COUNTA(B1:B2)
A3: =COUNTA(B1:B3)
...
A9: =COUNTA(B1:B9)
My best ...
1
vote
0answers
31 views
How to group by text in Google spreadsheet? [closed]
Say I have a spreadsheet:
Date Calories
Sep 1 -300
Sep 1 -200
Sep 2 -100
Sep 2 900
Sep 3 -700
Sep 3 -300
When I group the above by date, it is fine. I get the following:
Sep 1 -500
Sep 2 800
Sep 3 -...
1
vote
1answer
17 views
Using a custom formula as part of a conditional formatting rule
Ive got a spreadsheet with 3 columns A, B, C, i want to add the 3 columns together in column E, if there is a value in column C, i want the summed number to be shown in red.
If there is a value in ...
1
vote
2answers
88 views
Take cells from a column, populate in two different columns following a pattern & delimiters
To better explain what result I need, I made a text block below as a pseudo sheet to illustrate.
Col A (source) is the manually entered text data. Col B and C (desired result) will have formulas so ...
0
votes
1answer
36 views
Create a hyperlink from two columns, one with title and one with links, then retain only the hyperlink without losing the references
Demo sheet here.
Say I have two columns, one with string literal names, and one with links (in text form)
A B
Restaurant 1 http://www.link1.com
Restaurant 2 http://www.link2.com
...
