The Stack Overflow podcast is back! Listen to an interview with our new CEO.

5,384 questions
Filter by
Sorted by
Tagged with
10 views

### How do I advance the column instead of the row when I copy/paste a formula?

So pretty simple thing I am doing, pulling data from a form and putting it in a template. =('Form Responses 1'!B3) is what I am doing, which works fine for my needs, however when I copy and past ...
32 views

### how to extract URL from the cell?

The cell is not the type of HYPERLINK, but it is still a link, when you click the cell, it can redriect succcessful.
28 views

### Getting #DIV/0 error in Google Sheets for AVERAGE, SUM, COUNT, etc on column generated by ARRAYFORMULA

I am trying to get the average value of a column (column C "Profit Margin" in the screenshot) in Google Sheets. For some reason, I get a #DIV/0 error when trying to use any sort of range functions ...
22 views

### How do I get this formula to increment by 1 per 25?

I need my formula to increase by "1" for every "25". I wrote the following formula, but it does not work: =SUM( IF(O11<25,0, IF(O11<50>21,1, IF(O11<75>51,2, IF(O11<100>76,3, IF(...
26 views

### Is there a better way or more efficient way to write this IF statement? [duplicate]

I need a way to get the return number to increase by "1" after every increment of "10". Is there a more efficient way to do this other than: =SUM( IF(AC11<10,0, IF(AC11<20,1, IF(AC11<30,2, ...
36 views

### Can I use “countIFS” with a filter?

https://docs.google.com/spreadsheets/d/1PlPmShZ4SnkxAqBTg5xY_LHaNokGaFli4Wc7MjV_Jqo/edit?usp=sharing I want to count how many paid is for city MB and then how many paid is for city UB. I tried to ...
40 views

### Reference formulas from one sheet into multiple sheets

I would like to reference (pull in) formulas (not the result of the formula) from one sheet into multiple sheets so that they calculate on the sheet they are referenced. For example, if I have =...
14 views

### Google Sheets: move a chart and still have it update from original data/arrays?

Can you move or copy a chart in Google Sheets into another EXISTING sheet and have it still update form the original data arrays? I know you can move a chart into its own sheet, but I'm looking to ...
22 views

### How to show the current day of the week in Google Sheets

I have a Google Sheets that works as my To-Do list, and I want to make a cell that displays the current day of the week in text and updates itself every day. For example, Monday or Friday.
37 views

### Combine columns where there is only one data cell per row in Google Sheets

I have Google Sheets data that looks like this: A | B | C ----------- 1 | a | | 2 | | b | 3 | c | | 4 | | | d 5 | | e | 6 | f | | 7 | | | g 8 | | h | I need to ...
30 views

Is there a way to get a live preview image (an image, similar to the content of the document that updates without manual intervention) of a Google Sheet (or other apps in the Google suite) to link to ...
16 views

### I'm using googlefinance in sheets; printing to PDF shows N/A in place of calculation values

in calc using googlefinance function, when working/looking in worksheet, it calculates properly BUT when I go to print/PDF with control P, then open PDF the print shows N/A Here's a simple example ...
22 views

### How to reference the result of a IMPORT function as a defined name in a single cell

Note: The motivation for my question is just formula readability. My sheet is working fine. Let's pretend I have an IMPORTXML function that's currently returning 2 columns and a varying number of ...
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 ...
20 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, ...
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?
28 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 ...
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 ...
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 ...
56 views

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 ...
46 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" ...
143 views

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 ...
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 ...
32 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")...
17 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 ...
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 ...
136 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. (...
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 ...
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....
52 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 ...
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 =...
26 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 ...
16 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 ...
40 views

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 ...
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 ...
67 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 ...
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 ...
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 ...
32 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 ...
24 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....
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.
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 ...
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 ...
33 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 ...
30 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),...
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 = ...
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 ...
48 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 ║ ...