Skip to main content
Share Your Experience: Take the 2024 Developer Survey

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 data as markdown table to your question; this will greatly increase the chance that you get a satisfactory answer.

1,778 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
6 votes
1 answer
15k views

How can I duplicate a row in Google Sheets while retaining all of the formulas and format?

I need help with Google Sheets. We are using a sheet as a working file and new rows will be added by different users. Formatting and formulas are included in various columns. How do I ensure the new ...
ejx's user avatar
  • 61
6 votes
1 answer
7k views

Populate a Google slide automatically via Google spreadsheet

Is there a way in Google Slides to populate a slide with content that is referenced from a range in a Google spreadsheet?
Himanshu Pandey's user avatar
6 votes
3 answers
7k views

Why would I be getting the error: Too many simultaneous invocations: Spreadsheets on a simple once a day trigger?

I've searched around and still can't find anything directly related to the failure message I'm receiving. The script hasn't changed and it used to run just fine, but now in the past week or so it's ...
Micah Kuiper's user avatar
4 votes
1 answer
1k views

What ticker symbol to use for the crude oil price?

Which ticker symbol can I use for the crude oil price for the GOOGLEFINANCE function? Nasdaq Brent oil is "BZ:NMX" https://www.nasdaq.com/market-activity/commodities/bz:nmx Nasdaq Crude oil ...
Russell England's user avatar
4 votes
0 answers
737 views

How do I specify a consistent interval for a date-range axis in a Google Sheet Chart

I have a Google Sheet with a set of deposits and withdrawls and the running balance. I have added a chart to the sheet, so I can visualize what the balance has been over time and when deposits or ...
Todd Powers's user avatar
4 votes
0 answers
1k views

How to check if there is any Data Validation error in the whole spreadsheet?

Is there a way to check in a Google Sheets spreadsheet, if there is at least one cell violating a Data Validation rule? If such functionality is not built-into the app, how can I write a Google Apps ...
Federico DTales's user avatar
4 votes
0 answers
171 views

How to automatically convert all Microsoft Office file attachments in Gmail to Google Docs?

My Gmail has thousands of emails. Each email will have several attachments as Microsoft Office files (.doc, .docx, .xls, .xlsx, .ppt, .pptx). Currently, I want to automatically convert all Microsoft ...
fuongtd's user avatar
  • 41
4 votes
2 answers
27k views

How to insert Mathematical Equations in Google Sheets?

I have been searching for a while now and all searches lead to Google Docs, not Google Sheets. So basically what I'm looking for is similar to the insert equation function as in Excel where you can ...
EtoG's user avatar
  • 41
4 votes
3 answers
543 views

Conditional formatting for columns, date & time specific?

I have uploaded 4.000+ Venmo donation data sets into Google Sheets for sorting, but the date and time is preset and looks like this: 2018-11-01T20:16:52 I have tried multiple approaches to sorting ...
Cassandra's user avatar
4 votes
1 answer
1k views

How can I create a Google Spreadsheets whose name and cells auto-complete with cells completed on another sheet?

I'm using Google Spreadsheets to manage projects, and I'm not familiar with scripts or macros. What is: 1) I have a Gantt spreadsheet which lists all the ongoing and foreseen project as follows (by ...
Phil's user avatar
  • 41
4 votes
2 answers
1k views

How to Modify Matched Cells Across Multiple Sheets with Google Script

My question is a fairly complex one, but I'll do my best to clarify exactly what I'd like to do and this requires some background: I have a Google Spreadsheet used for user administration in my ...
Mattoverton20's user avatar
3 votes
1 answer
360 views

Filter date, and add blank rows between different time slots

I'm trying to build a reservations spreadsheet for my friend's restaurant where she can input on monthly sheets as resos come in, then see a filtered, sorted summary of any selected day. Here is a ...
Emma's user avatar
  • 31
3 votes
1 answer
48 views

I wish to make my Google sheet slightly easier for me to use

Can anyone teach me how to autofill the "Selling At" column E and "SC Used Per Transaction" when I key in the "Denomination Sold" Column? So for example, when I key in &...
Joseph Ng's user avatar
3 votes
2 answers
188 views

How do I filter cells by a list of keywords, and import them into another sheet in a workbook?

I've got a list of customer feedback from a company's website. We'd like to filter the data by store, so we can shout out the staff members or stores that are doing particularly well, and give them ...
Pod's user avatar
  • 31
3 votes
1 answer
101 views

Round up duration calculation to the next multiple of five minutes

I currently have this formula: =text(D2 - C2, "hh:mm:ss") I need this formula to round up to the nearest 5 minutes. I have tried mround(), ceiling() and roundup(), but I'm not getting the ...
Cate Kemp  SBFO's user avatar
3 votes
1 answer
405 views

Apply custom formula across all columns using Array Formula

I have trouble applying my custom formula across all columns using Array Formula. My custom formula is named getCountry where it could get the country based on an address. The address components e.g. ...
Carmad94's user avatar
3 votes
1 answer
345 views

Count number of rows with a specific MONTH in the date of a specific cell and a Boolean condition in another cell

Let's say I have a number of dates and whether they occupy full or half a day: DATE | WHAT | HALF? ... 2021-4-1 | Something Something | false 2021-4-2 | Something Something | false ...
User1291's user avatar
  • 143
3 votes
1 answer
171 views

How do I input a current balance in a cell from a running balance that will be updated frequently?

I know I'm not accurately explaining that but here's a sample spreadsheet of what I mean:
Megan Thomas's user avatar
3 votes
1 answer
56 views

Sums with Same Value - Follow-up Question

This is a follow-up to these questions and information. Thank you Jacob and Kowser for the formulae you shared many years ago! The information you shared is almost exactly what I need to simplify a ...
Mike's user avatar
  • 31
3 votes
1 answer
44 views

In google sheets - how return *1.54M* as $1,540,000 with the same formula that I would return $1.35B* as $1,350,000,000?

I am building a stock model - where I use =importhtml() to give me financial data pulled from a website on certain stocks. It is returning it correctly, but there are asterisks surrounding all the ...
George Davis's user avatar
3 votes
1 answer
927 views

How do I stop Google Sheets from opening new tabs?

In Google Sheets, I have two completely separate spreadsheet files. In Spreadsheet A, there is a cell with a link to open Spreadsheet B, and vice versa. When I click on the link, the other ...
jescotucker's user avatar
3 votes
1 answer
2k views

Writing a macro to create a new tab and name that tab based on a cell value in Google Sheets

I would like to have a Macro that generates a new tab and names that tab based on a cell value. There is a tab called 'Dashboard'! on which the user enters information in assigned cells. Afterwards, ...
Othello's user avatar
  • 31
3 votes
3 answers
173 views

Automatically copy first 3 columns from one sheet to each new sheet in Google Sheets

I'm having columns A, B and C filled with data in Sheet1. Those columns contains data that is static for each new sheet. Currently, I need to manually copy the first three columns to each new sheet I ...
Mario Smode's user avatar
3 votes
1 answer
319 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, ...
csswizardry's user avatar
3 votes
2 answers
6k views

How do I get Google forms edit url to work

I want to generate an edit url link in the google sheet for a google form which is linked to it. There are already instructions on how to do it. However they do not work for me. I have followed the ...
Jamil's user avatar
  • 31
3 votes
1 answer
6k views

Repeat formula n number of times in Google Sheets

Apologies, I'm very new to Google Sheets and spreadsheets in general. I'm trying to fill some cells with repeating data, and then analyze it. The data is pulled from another large spreadsheet and has ...
user avatar
3 votes
2 answers
421 views

How to make sequential list of months?

I want to fill column names with a sequential list of the last day of each month. For example, 3/31/2018, 4/30/2018, 5/31/2018, etc. Is there a formula that can do this? If cell B1 = 3/31/2018, I ...
Elliott B's user avatar
  • 266
3 votes
2 answers
6k views

How to pull last value in a Google Sheets column and populate it across another worksheet column?

This is my first post here- I hope this is the right place for it, apologies in advance if it isn't. Context: I have a password protected presentation that I need to give users access to, but only ...
user avatar
3 votes
3 answers
664 views

How to remove duplicate words in a cell only if longer than a certain number of characters?

I need to remove a duplicate text in a cell but only if it is longer than 4 characters. I have this formula that only works for any types of duplicate words: =join(" ",unique(transpose(split(A1,", ")...
Max Pacini's user avatar
3 votes
2 answers
93 views

If a cell value is TRUE then retrieve another cell's value

In Google Sheets I have a formula in Column V that returns "Paid" or "To Pay" depending on whether a checkbox in Column U is checked: =IF(U2=True, "Paid", "To Pay&...
Customer Services's user avatar
3 votes
1 answer
255 views

Add values between two dates in Google Sheets

So I've already found this question answered several times around here but for some reason, despite essentially copy and pasting the answers it still doesn't work for me. I'm trying to add ...
julian's user avatar
  • 31
3 votes
1 answer
6k views

Query returning results into merged cells in Google Sheets

Short Question: I have a query function returning an array over merged cells. Instead of displaying all of the values in the array, some of the data is hidden in merged cells where only the first ...
kviLL's user avatar
  • 364
3 votes
1 answer
168 views

Script to place duplicate Google sheet beside the sheet it copies (instead of the end)

Is there any way to modify my script to have the sheet it's copying insert the new sheet immediately to the right of the one it's copying? I have tons of tabs in the file, and it's starting to get ...
Tamarissa's user avatar
3 votes
1 answer
210 views

How can I pull a value from one column based on the values of another column?

When the value in the "Amount Owed" column becomes less than 0, I want the value in the "Year" column to appear under "Year Paid Off." For example, if the "Amount Owed" dropped below zero at "Year" 1,...
William Pratt's user avatar
3 votes
1 answer
3k views

Format telephone numbers, keeping only digits

I have a spreadsheet that has phone numbers in the cells that are typed out like this: +1(313)313-3333 and I need these numbers to all be plain and look like this 3133133333 (with no 1 in front). ...
Michelle Harris's user avatar
3 votes
1 answer
2k views

Any way to separately Validate and create a Dropdowns in Google Sheets?

Sample Scenario: Sheet 1 has a 3 Dropdowns from sheet 2 Sheet 2 has two lists, {"A";"B"}, and a second dynamic list that copies the first IF the value doesn't already appear on sheet 1 The behaviour ...
Void Singer's user avatar
3 votes
3 answers
2k views

Summing values from multiple sheets with names specified in cells

I'm attempting to sum unknown quantities of data that is contained in several sheets. The amount of sheets isn't known either. Thus far, I've simply been using the indirect command on a column with an ...
Tock's user avatar
  • 147
3 votes
0 answers
2k views

How to find all Google Docs (or Sheets) with comments?

In Google Docs/Sheets, when making a copy of a file, the comments don't get copied over. There is a plugin (Copy Comments) that makes a copy-with-comments for Docs, but it's one document at a time, ...
Alicja Z's user avatar
  • 173
3 votes
1 answer
171 views

Selecting a single column from all rows for chart range

I want to specify a certain column from all rows (omitting the first few) to be the range for my chart. Currently I input this to specify the range: L6:L (note: this automatically changes to L6:L20 ...
Shazz's user avatar
  • 131
3 votes
0 answers
6k views

Google sheets query returns "loading..."

I've put together a web application that relies on a series of Google components. Google Forms collects data from users Google sheets saves the data (automatically) Additional "calculated" columns ...
grayob's user avatar
  • 229
3 votes
1 answer
2k views

Simultaneously sort multiple ranges on a single sheet in varying orders

I am trying to find a way using a script if possible (or formula) that will allow me to reduce the number of operations that I have perform to sort data in a particular google spreadsheet. Currently, ...
Max's user avatar
  • 31
3 votes
2 answers
14k views

How to get value of cell by row key and column key

Suppose I have a workbook with two worksheets, data and view. data is structured in "database" style, i.e. with a single header row and unique keys in the first column, e.g.: Country GDP ...
user avatar
3 votes
1 answer
6k views

Can I precisely position charts in Google Sheets?

I am using Google Sheets to create a "Monthly Report" spreadsheet for a product, and am attempting to make an attractive, compelling experience for the consumers of the report. In this spreadsheet, I ...
user15571's user avatar
3 votes
2 answers
88 views

Filter function with multiple variables google sheets

I want to be able to use a filter function for people in NAME whose P DATE is within a specified range. However, if they have a Y under VALIDATED, I want the filter to also include names with the T ...
Kyle's user avatar
  • 31
2 votes
1 answer
43 views

Conditional formating max values over multiple rows

I have Google Sheets data in column pairs from Column B to AQ. Each column pair represents a single year with the first column containing order counts, Orders, and the second containing order totals ...
Wes B's user avatar
  • 21
2 votes
0 answers
29 views

Increase canvas size on a drawing in Google Sheets

I am using the drawing tool in google sheets to create a flowchart. My flowchart requires more space than the standard canvas size. How can increase the canvas size? I could not find an option to ...
Kisheon Alexander's user avatar
2 votes
2 answers
100 views

Keyboard shortcut to move a row in Google Sheets

In Google Sheets, what keyboard shortcut moves a row? The row should be removed from the source location and inserted into the destination location (not overwrite an existing row). In Excel, you can ...
Edward Brey's user avatar
2 votes
0 answers
33 views

Hebrew text overflowing cells and causing layout issues in Google Sheets

I am experiencing an issue with Hebrew text overflowing cells in Google Sheets. This only happens with Hebrew text, and not with English text. The text overflows and disrupts the layout of the sheet, ...
user avatar
2 votes
2 answers
36 views

Dynamic table calculations

I am attempting to create a dynamic table that will execute formulas based on a selection from a drop-down menu. I have created a test spreadsheet to support my request, which can be found here ⬅️ ⭐️ ...
Alon Hamzani's user avatar
2 votes
1 answer
50 views

Is it possible to have a pivot table automatically incorporate newly added 'Filter by' values or show the current values?

I've made a test sheet here (https://docs.google.com/spreadsheets/d/17l49Rn3ZbNx-upzBtmRtsJBHQiCKXuYPs8SMTyrcw9k/edit#gid=0) You'll notice that the pivot table IS correctly pulling in ALL the data in ...
james's user avatar
  • 123

1
2 3 4 5
36