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
0
votes
1answer
16 views

Changed the script and it stop working

I have been using this below code which was working perfect. function colorChangeCheck(e) { var sh = SpreadsheetApp.getActive().getActiveSheet(); var color = sh.getActiveRange().getBackground(); ...
0
votes
0answers
3 views

Locking Google Sheet Cells Monthly

I am using Google Sheets, and my columns are set up for each month (Jan, Feb, March, etc). I have several rows that are pulling data from other tabs in the sheet to create an at a glance master list. ...
0
votes
1answer
8 views

How do I count the amount of cells that contain a formula in Google Sheets?

I'm trying to count the amount of cells that contain a function in them without having =ISFUNCTION(cell) next to every single cell and counting the amount of cells that return TRUE. I tried to use =...
0
votes
1answer
5 views

Problems when copy pasting a sheet in google spreadsheets

I have recently started using spreadsheets in the cloud, and having some problems with the most basic of tasks. I have a location in my google drive. There there is a spreadsheet. This has only one ...
0
votes
1answer
8 views

Using Text from Cell with Validation Makes Formula Error

I have a document set up with two tabs. Tab 1 has a list of foods (one food per row) with some info on each one across the columns. Tab 2 has a cell with a data validation where you can choose a ...
0
votes
0answers
3 views

Importing addresses from Maps to Google Sheets

All I want is for addresses I type into a Google Sheet cell to automatically correct to the address listed on Google Maps -- including autofilling the zip code. So 1815 Bleecker Street would change ...
0
votes
1answer
14 views

Auto Sort Google Sheet using onEdit Function and prioritising certain cell values

I have a populated table where I add a prioritisation queue number in the final column. The identification of each row is defined be email OR SMS and the prioritsation queue is labeled as such. I ...
0
votes
0answers
10 views

Why is my Google Sheets importrange repeatedly throwing internal errors?

Today several Import Range functions in one file started throwing internal errors. I got things working and within a couple hours the same thing happened again. Have I hit some limit, or some ...
0
votes
1answer
6 views

How can I create a line chart in Gsheet if I have a pivot table with 2 rows?

I want to plot a line graph, it should have 4 series as mentioned below Car 2019 Scooter 2019 Car 2020 Scooter 2020
0
votes
0answers
9 views

How to use google sheet open xls file has chinese character correctly?

i had excel spreadsheet file which has chinese character and shows correctly under microsoft excel. unfortunately, i upload that file into my google drive and open up with google sheet; those chinese ...
0
votes
1answer
15 views

How to choose encoding when export a CSV on google spreadsheet without using Google Apps Script or Google APIs?

My goal is to export a CSV from google sheets using encoding UTF-16. Google sheets is by default exporting CSV in UTF-8 and uses commas to separate values. I would like to export the CSV in UTF-16 (...
0
votes
2answers
19 views

Google spreadsheets have a column limit?

I read that google spreadsheets have a column limit of something like 20000. However my spreadsheet does not have any column beyond AC. How can I add columns to my spreadsheet?? (in Excel this is ...
-1
votes
1answer
9 views

Autocalculate Date to match a number in a given cell

I'm trying to create a formula to calculate the date in column D4 based on the 'month & year' provided in B4 and a plain-text number given in C4 so if B4 is 02/2021 and C4 is ' 1 ' then ...
1
vote
1answer
30 views

Arrayformula to get closest non-numeric value above

I have Column A with mixed data types (numbers and strings) and in Column B I want for each numbers in Column A to display the string that is the closest above. Example: Title| 1|Title 2|Title Next ...
0
votes
1answer
11 views

Google sheet: run a script via the share link (without login)

There is a script for my Google spreadsheet so that every change in a cell is indicated by a red color marker. When users with a Google account that I have shared to the spreadsheet make changes, the ...
-1
votes
1answer
22 views

QueryByName() function from another sheet in google spreadsheet

Is it possible to use QueryByName() function using another sheet from same spreadsheet? =query(nor9609s!A1:Z500,querybyname(A1:Z1,"SELECT `Items_shopid` WHERE `Items_id`>0")) I got error ...
0
votes
0answers
11 views

Use variable in vlookup function for sheet name [closed]

Is it possible to substitute a variable instead the sheet name based on a drop down cell value? I have 12 sheet, one for every month, and would like the vlookup to change sheet based on a value in ...
0
votes
1answer
38 views

How to use a query with a combination of If and Where

I have a data base on Google sheet. See the spreadsheet at this link:https://docs.google.com/spreadsheets/d/1NGkH56Ga95osN8eBI6d5MhV7SnoEPK4Oe7ymRJVK7M0/edit#gid=1262146092 It s a copy so feel free to ...
0
votes
0answers
22 views

Pulling cryptocurrency API data using ImportJSON in Google Sheets – how to truncate & merge headers to "data type" instead of "coin name + data type"? [closed]

I'm trying to pull information from the CoinMarketCap API and have it arranged in a 2D array, with the data from all currencies being called being arranged under the same headers. I tried using the ...
0
votes
1answer
27 views

Google sheets conditional formatting to show selected text

So i've been trying to find a way to do this but struck a wall so hoping someone here might have a idea! Problem: We have a list of signatures that can be choosen with dropdown list in Google sheets. ...
0
votes
1answer
19 views

Query formula to import the data from multiple tab sheets

I am using a query to import the data from multiple sheets, however, the formula is skipping empty cells. Is it possible to not skip empty cells and keep the data in the correct cell on the Master? ...
0
votes
1answer
13 views

How to format a google sheet that's capturing google form data?

I have a google form which I linked to a google sheet via the "create spreadsheet" button on the form. Is there a way to format the resulting google sheet for current and future form ...
0
votes
2answers
24 views

Compare Two Dates and Display The Earlier One

Cells B2 and B3 each have a date entered in them. I want to compare the two dates and display the earlier date in cell C2. Or, stated another way: if B2 < B3, display B2 in cell C2 if B3 < B2, ...
0
votes
1answer
19 views

Is it possible to write a script that automatically triggers some function within a Google Sheets add-on?

I'm using some Google Sheets add-on which pulls information from API databases, and it has both a free subscription and paid subscriptions which add many additional abilities which I don't really need,...
1
vote
1answer
40 views

How to get weekly averages for workout tracker data in Google Sheets?

I am making a personal training app that uses data from Google Sheets. I want to create a formula that takes the data from a sheet of workout tracking inputs and creates a weekly average for each ...
0
votes
1answer
10 views

Want Previous WEEK VOLUME formula in Google Sheets, Please help me out [closed]

I have just try =GOOGLEFINANCE (B2,"Volume"), "weekly" Just showing na#
0
votes
1answer
26 views

How to view all possible values between two columns of data

I have columns A, and B, and I want to divide every value in A by the values in B. For example, divide 15 by all values in column B, once done, shift down and divide 57 by all values in column B etc. ...
0
votes
1answer
18 views

Getting "Exceeded maximum execution time (line 0)" error with custom code when data input increased in "History" sheet

I have a google sheet wherein there are 2 sheets named "Position" and "History" respectively. I have a custom function that takes data in the "History" sheet and arrange ...
0
votes
1answer
22 views

If any contains do X if not do Y

In trying to work out the proper formula for this. If any of these cells (A2, B4, C6, etc) contain a value >0 return -1. If not than do this IF statement. Essentially an IF ELSE statement but with ...
0
votes
0answers
11 views

Google speadsheet: run a script via the share link [closed]

There is a script for my Google spreadsheet so that every change in a cell is indicated by a red color marker. When users with a Google account that I have shared to the spreadsheet make changes, the ...
0
votes
1answer
22 views

Go to last data row in google sheets

I have a google sheet that has many pages inside. How can I go to the last data row quickly when I change the page? I tried ctrl+end but this goes to line 1007. ctrl+↓ not working either.
0
votes
2answers
15 views

Assign a default name if the cell value is null

I have a booking form, shown. I also have a template form, hidden. This script is assigned to a button to create completed bookings by copying the booking form data to a copy of the template and again ...
0
votes
1answer
17 views

Combining year date into autofill google sheet

So I am trying to create a basic daily finances tracker using google sheets. And I want to be able to have it so that yearly tabs reference a template sheet that allows you to change the year on each ...
0
votes
1answer
12 views

How to enable macros

Looking for some insight. In Google Sheets I added a series of buttons linked to macros. Works just fine for me and another user. Other users are telling me that they click the button and nothing ...
0
votes
2answers
17 views

Copy random row from one Google Sheet to another

I have 2 separate google sheets. (Lets call them Primary and Secondary) The Primary spreadsheet has 2 columns with 50 rows of data. On a set interval (weekly) I want to copy only one random row from ...
0
votes
1answer
25 views

Update a sheet row by matching a value from another sheet

I'm new to App Script and I'm trying to update an existing row by matching value coming from another sheet. Basically record all the data from the "receipt" to the "record" by ...
1
vote
1answer
28 views

How to copy a cell from Google Sheets without getting double quotes (" becoming ""), BUT keeping the \n (char(10)) line breaks

I have a couple of Google Spreadsheets I use to generate config files for things. The config file data ends up in a single cell, which is copied and pasted. Problem is Google Sheets has this odd ...
0
votes
1answer
16 views

Offset a Vlookup across multiple sheets

I recently received help on creating a formula to fill in data on a Google sheet for customer orders, this goes between sheet1 (master) and sheet2 (selected data only, depending on the reference cell)....
1
vote
1answer
40 views

How to stop google sheets resizing an image with =image("url")?

This sheet shows the problem: https://docs.google.com/spreadsheets/d/1G_SXx_poARQ4muv3wxopV-zsSOoRwdNgssrvnfFOCVg/edit?usp=sharing I have an image that is 41px by 1637px (https://i.imgur.com/dVhtrwT....
0
votes
1answer
27 views

How to sum one row of multiple selected columns where a col matches a condition, but return null string instead of "0" if no match

Say you have one spreadsheet like this: A B C D E F Timestamp Name P1 P2 P3 P4 10/17/2021 16:28:47 Asha 1.2 3 .5 3.1 10/17/2021 23:01:38 Wei 0 0 0 0 Now, in another spreadsheet, you have ...
0
votes
3answers
38 views

Extract URL from hyperlink in google sheets where there is no `hyperlink()` function being used

Ive got a hyperlink that ive copied from a website and put into a Google Sheet. If you hover over the hyperlink it shows you it is an active link and you can click it. But if you view the formula in ...
0
votes
1answer
22 views

Google sheets reference Text in Cell in Array Formula & Countif formula

So, I have a Array Formula and Countif formula in place because I need to know the total of entries in a combination of ranges. I need to know the sum of the number of cells that have "X" ...
0
votes
0answers
8 views

How to add pop up calendar depending on another cell input?

I would like to create a column of cells (assuming in Column A) for user to select the status of job, eg. In progress, Closed, KIV, while Column B is for the Date the job is closed. Column A is rather ...
0
votes
1answer
13 views

Google forms to google sheets to google doc - How to set date to display dd-mmm-yy in sheets and doc?

I'm fairly new to coding, and am trying to get my head around a problem for some work admin. I´m hoping there's a quick and simple fix to this. So as the title says, we enter info on a google form and ...
1
vote
1answer
17 views

Using OFFSET function across multiple sheets

New to Google sheets, so feel like I'm falling down somewhat of a rabbit hole trying to figure this out... I have a spreadsheet 'sheet 1' where we keep the details of our sales - Name, address, design,...
0
votes
2answers
25 views

Add constant number to query() result in Google Sheets

I've a QUERY() function that results into this automatically generated table: A B S 2 F 5 G 1 I'd like to add a constant value to each cell in column B like (let's say 3): A B S 5 F 8 G 4
0
votes
0answers
15 views

Conditional Format cell if the value is just text or a reference [duplicate]

How to Conditional Format cell in Spreadsheet based on whether the value is just text or a referenced cell from another tab
0
votes
0answers
9 views

Creating a Button that allows you to Print a select area of cells

I have a document here that I needed some help on! https://docs.google.com/spreadsheets/d/1AFcHk-5JxMxj1ma-vTmCHIwBVn81Mgmxl001k__IMT4/edit#gid=0 I'd like to create multiple buttons in one tab that, ...
0
votes
0answers
47 views

Array Formula Problem - How to Fill In Blank Rows with the Same Value before a Breakpoint which advances to the next letter

I have a Google Sheet which is grouped into segments of a TV show. So there's an A segment and then a B segment and so on ... I have allocated two columns to provide two different timing functions (...
0
votes
2answers
16 views

Removing shared files on Google Drive

I am trying to clear out google files that I do not need. They are documents my children needed for school during the COVID shutdown. I was able to remove several of them however there are some that I ...

1
2 3 4 5
148