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
0
votes
0answers
4 views

Increase line spacing in Google Sheets [duplicate]

I am using Google Sheets and want to change the line spacing of text within a cell. cannot seem to find any information on this.
0
votes
1answer
20 views

How to transfer a cell value to another cell by pressing a button

I want to be able to click a button and the value of one cell gets transferred to another cell, and the new cell adds them up. example: If I put 5 in B6 then click the button, C5 should update to 5 ...
-1
votes
0answers
8 views

ctrl-v sometimes triggering the copy/paste warning in Google Sheets

Curious if anyone else is experiencing this. I am using google sheets in Firefox 70 on Ubuntu 18.04, and some times using ctrl-v brings up the copy/paste popup warning instead of pasting as expected. ...
0
votes
0answers
20 views

Google Sheets - Historical Data not returning yesterday

The formula below is been used to get the historical data until today: =GOOGLEFINANCE("GOOG","ALL",DATE(YEAR(TODAY())-1,1,1),"12/05/2019","DAILY") Unfortunately I don't receive today's data (until ...
0
votes
0answers
14 views

Concatenate multiple columns automatically [duplicate]

I have three columns A B C D E F G H I I want to write a formula such that it will combine the three columns, one on top of the other such that my fourth column is: A ...
0
votes
0answers
11 views

Sending edit logs from multiple Google sheet files to one “edits log” spreadsheet

I'm creating a large amount of spreadsheets in google drive, and i would like to monitor/log the changes in a single spreadsheet(eg; file/date/time/user) My goal would be to track how often and who is ...
-1
votes
0answers
11 views

12 Week Scheduled Contact Sheet

I'm trying to create a sheet that will have data imported from Zen Planner through webhooks. The data will be for new students at a martial arts academy. There are 5 of us that will be working in ...
-1
votes
0answers
14 views

Test cells to fill in others from separate sheets

I know there’s a way I just can’t process it completely right now. Can someone help me process this: I’m wanting to have cells multiple automatically populate from other sheet depending on one cell ...
1
vote
1answer
11 views

How to access the “unformatted” date in Google Sheets?

I am working with a spreadsheet that includes a row where each cell contains the date of the first day in each month in a series of years: 1-Jan-18, 1-Feb-18, 1-Mar-18, ... , 1-Dec-18, 1-Jan-19, 1-Feb-...
0
votes
0answers
8 views

New solution to identify BY as a column label instead of an identifier?

I'm new to this, so I've posted this question as an "answer" to this post QUERY error for BY column a previous solution for this issue no longer works, and I need a new way to tell google (via code) ...
0
votes
1answer
15 views

Multiple Unique Values Across Worksheets in Google Sheets

I rarely use spreadsheets, but I thought creating a workbook for a contest would be really helpful. I am not sure if what I am asking is possible without a custom function. I am grateful for any and ...
0
votes
1answer
16 views

Determining location of checkbox that activated a script?

I have hundreds of checkboxes in multiple sheets on a single Google Sheets project. When a user clicks a checkbox, I want a script to activate. In that script, I need to know what cell the checkbox ...
-1
votes
1answer
5 views

IF THEN Google Sheets - referencing different workbook

I'm hoping to do the following: Spreadsheet 1, cell A1: pull in data from cell A1 in Spreadsheet 2, but ONLY if cell B1 contains exact text of "partner". Is this possible?
1
vote
1answer
18 views

How do I use conditional formatting on one column based on certain characters in another column?

When column D has a hyphen (-) in it, I want the fill color in column H to change. What is the custom formula for that?
0
votes
1answer
37 views

Generating a list in Google sheets with checkmark filters

I've been wracking my head over this for a few days now, basically I tried to use a index/match/if/countif setup to try to get a unique list generated based on filters made by checkboxes. (not ...
0
votes
0answers
11 views

How to auto expand column with formula to bottom of sheet

I am making a credit card debt paydown sheet that I want the user to be able to add more rows and have the formulas automatically fill down the column. I tried ARRAYFORMULA but because the results of ...
0
votes
1answer
13 views

Google Sheets apply conditionnal formatting for each column

I'd like to highlight the max value in each column. Example : A B C 1 50 12 60% 2 20 84 50% 3 38 20 15% Here A1, B2, C1 will be highlighted. So I know how to do that for 1 ...
-1
votes
1answer
23 views

google sheet need formula to go backward directory of URL link

example i have data in colum https://www.mybookStore.com/images/products/80/1020/40422/2/279/howtocookegg8.jpg https://www.mybookStore.com/images/products/80/1020/40422/2/279/howtocookegg9.jpg i ...
0
votes
1answer
43 views

How to open Google docs in new tab in Firefox

When I click a Gdrive item in Firefox it always opens in the current tab. How do I get it to open in another tab. When I click on any other URL it opens in a new tab why not Google docs? In Chrome ...
0
votes
1answer
15 views

How do I prevent float/decimal numbers from converting to text in Google Sheets? (iOS)

I have a cell with the value 2.2 that is being displayed as text. I’m unable to convert the value format from text to number. Screenshot 1 shows that cell format is number Screenshot 2 shows that ...
0
votes
1answer
12 views

Using Google Apps Script in with arrayformula?

I'm using an array formula in Google Sheets to determine when a cell shows 'Expired' based on date. When the cell shows Expired, I've a script which should transfer rows with Expired to another sheet....
0
votes
1answer
16 views

How can I make some data on a Google Sheets auto-sorting but in different columns in every sheet?

If i want to sort different columns in every sheet, what do i have to change? function onEdit(event){ var sheet = SpreadsheetApp.getActiveSpreadsheet(); var editedCell = sheet.getActiveCell(); ...
0
votes
1answer
15 views

IMPORTXML not working [duplicate]

I’m trying to scrap prices from various e-commerce site. However the IMPOrtxml function is not working For instance, https://shopee.sg/Ice-Silk-2019-Men-Underwear-Cool-Breathable-Comfortable-Sport-...
0
votes
0answers
4 views

Creating a Scatter PLot with Equal Axis Scale

When creating a Scatter Plot in Google Sheet, the X and Y axes get scaled independently. Is there a way to set them to always use the same scale/units? Basically, such that given a point (10,10)...
0
votes
1answer
23 views

Google Sheets - If cell contains text that matches text from a column, return another cell

https://docs.google.com/spreadsheets/d/1GG7ekrD6CxxpowrRDm9DMvv3xHdvtAa8MHYCk4gI4D4/copy 1) If D10 (or I10 or N10) matches an exercise from the corresponding column to the right, return another cell (...
0
votes
1answer
14 views

“You do not have permission to call …” Steps to convert a custom function it into an add-on that will have permission?

I'm attempting to create a HIDE() function, which will hide either the current row, column or both based on another (true/false) value. I've already created the full function, but unfortunately it's ...
1
vote
1answer
21 views

How to bypass the restriction on scripts for people with read-only access to a Google Sheet?

Is there any way to bypass or work around the restriction that a script doesn't run for people with view-only? We have a planning where I made a script to go to today's row (which is a couple hundred ...
-1
votes
1answer
13 views

Google Sheet - Hide cell value if not authorize

I had a GSheet file with a vote system like this |user1|1|4|6| |user2|5|4|1| |user3|2|4|4| ... Actually, each user can only edit his line with cell authorization. We want to "hide" cells of other ...
3
votes
1answer
37 views

Rolling Year Formula

I have a Google sheet where I would like a score based on a rolling year figure. I have managed to do these separately using the formulas: =query(A2:B," where A >= date '"&TEXT(today()-E1,"...
0
votes
0answers
25 views

Google Sheets Error could not fetch url: [duplicate]

So I have a google sheet that tracks some parameters from an investment I am in. About 3 week ago all of my importHTLM or importXLM functions just quit working. They all say the same error of could ...
2
votes
0answers
21 views

Custom number formats in Google Sheets: Issue displaying negative numbers

Context: Looking to display large numbers used in financial reporting & analysis in an abbreviated easier-to-read format. I currently have the GS custom number format as follows: [>=999950]#,...
1
vote
1answer
23 views

Going to learn google app script for sheets. Is what I want to do with it even possible?

I recently asked this question, but there were no satisfactory answers, so I am turning to learning google scripts to do that plus the following, and I wanted to know if either or both were possible ...
0
votes
2answers
31 views

How do I find out what is slowing down google sheets?

I have a multitab google sheet that now and then slows to a crawl. The progress ribbon takes several passes to before it quits. At times the progress ribbon stops entirely for minutes at a time. This ...
3
votes
0answers
39 views

Conditional Formatting in Google Sheets

The shorter question to spare you from reading more than you need to I have a few different formulas for use in conditional formatting with custom formula in Google sheets. They are all roughly 1100 ...
0
votes
0answers
29 views

Auto-create new Sheets with specific data, copy rows and conditional formatting

I did find few scripts about how to make Google Forms result sheets to auto-create new sheets by a specific data in a cell. I did not manage to get the scripts to work - and I was wondering if ...
0
votes
0answers
16 views

Getting distance between 2 postcodes using Google Maps in Google Sheets

This topic has been brought up a few times - but i've tried every option in google sheets but it keeps returning "Imported Content is empty" on my function The code im using is below (where G23 &...
0
votes
1answer
24 views

Array Formula with N/A to print nicely when empty

We use a rather long formula something like: =ArrayFormula(JOIN(", ",UNIQUE(FILTER(SOURCERANGE!A1:A99999,SOURCERANGE!N1:N99999=A2 )))) Some cells in our table gave results and they print nicely. ...
0
votes
0answers
20 views

Google Sheets: word count for a webpage content (url) for SEO

For SEO analysis, I am using Google Sheets to extract basic data from my own webpages. I am able to access page title, description, <h1> tags, or number of characters via LEN(): =IMPORTXML(A3, ...
-2
votes
0answers
22 views

How to make last user name stamping in Google sheet?

How to make user stamp or who updated cells last user? Please help me.
0
votes
0answers
19 views

Copying data from one sheet to another and then moving down 1 row

Im using google sheets to make a check in sheet for clients, Im trying to use a macro to copy the check in data to another sheet then move down a row on the data storage sheet and reset the check in ...
-1
votes
0answers
10 views

copy and paste problem in google docs and google sheets

Why are Cut/Copy, and Paste unavailable in the Google Docs and Google Sheets in the firefox browser? FYI, I am using Ubuntu OS
1
vote
1answer
41 views

Sign-in with Google disabled for even the simplest script

I noticed one of my scripts stopped working and was trying to debug. I couldn't get anything to work. So I created a totally blank spreadsheet and a new script and I am still getting this error: I am ...
1
vote
1answer
11 views

can't locate ; syntax error

I'm writing a function to calculate the income tax burden in the UK, and the Google Apps Script page keeps giving me an error notice that there's a missing semicolon (Missing ; before statement. (line ...
2
votes
1answer
25 views

What formula could I use for conditional formatting to highlight cells in Column B if the text in Column A has a link in it?

I want to easily see what text in Column A has a link in it by looking at Column B.
0
votes
1answer
13 views

How to get Google Sheets CTRL-D “Fill Down” to behave like Excel when single cell selected

If there is a value in cell A1, CTRL-D while a single cell A2 is selected behaves differently in Excel and Google Sheets: Excel: copies cell A1 to cell A2 Sheets: nothing The Excel behavior is ...
1
vote
3answers
24 views

How do you get the address of the last non-blank cell in a column?

I use this to get the contents of the last cell in a column: =INDEX(FILTER(C:C,NOT(ISBLANK(C:C))),ROWS(FILTER(C:C,NOT(ISBLANK(C:C))))) But I want the address of that last cell. Does anyone know what I ...
-2
votes
1answer
16 views

google sheet unexplained format on a single cell

I am collecting some info for 2020 taxes, and am not sure what I did. One single cell is framed in green. When I hover over it, it shows my name. How can I fix this please, (remove it)?
0
votes
1answer
17 views

Google sheets show open or closed at the moment

There is a client’s working time, it is necessary to display the client is currently open or closed. Is it possible?
0
votes
1answer
20 views

Google script unhide sheets while running

I've encountered this problem: I've made (a rough) script (but works) that generate a random list of items, sort them and archive them, all works fine and now I want to hide the sheets where this ...
0
votes
0answers
44 views

Shared documents doesn't remove from view in Google Sheets and Docs

I'm trying to delete a file that I have accessed through a link and therefore appears in my Google Docs or Sheets. They are documents that don't appear in my Drive because it has not been explicitly ...