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.
8,719
questions
-1
votes
2
answers
4k
views
IMPORTRANGE row limit?
I have a document where I am trying to mirror some data from one Google sheet to another. I have over 1000 rows in the first document; when I use the IMPORTRANGE formula it works fine as long as the ...
-1
votes
1
answer
559
views
How do I reference the value of multiple cells from one spreadsheet to another?
The real kicker here is that I only want to reference certain cells if a cell has been selected.
I am creating a "leads" Spreadsheet on Google. Once a target has been contacted, their information ...
- 3
-1
votes
1
answer
2k
views
Changing the text of an entire column to uppercase [duplicate]
I want Google spreadsheets to automatically uppercase text inputted into a cell.
I'm using the following code and receiving circular dependency errors:
=ARRAYFORMULA(UPPER(C5:C))
I'm inputting text ...
mathisnotmyforte
-1
votes
1
answer
205
views
Formula for adding columns of a row till the last column in Google Spreadsheet
I want to sum the columns of a row and display the sum in the last column. As shown in the example below sum of each row is displayed in column TOTAL
COL1 COL2 COL3 COL4 TOTAL
...
Meena Chaudhary
-1
votes
1
answer
1k
views
Cursor position in Google Spreadsheet
In a google Spreadsheet the cursor is always behind the last letter not in front. How can I change that?
-2
votes
1
answer
41
views
How to resize Google Sheets column to width of selected cell?
When I double-click the right border of a column's header, the column will be resized according to the largest width of all its cells.
How to resize instead according to the width of the contents of ...
- 6,043
-2
votes
2
answers
623
views
What Add ons are available to give Google Sheets features similar to Excel Tables and Structured References?
This article: https://support.office.com/en-us/article/Using-structured-references-with-Excel-tables-F5ED2452-2337-4F71-BED3-C8AE6D2B276E describes the use of structured references. I hadn't heard ...
-2
votes
1
answer
306
views
Investing.com data uploaded but i am not able to use the data for email alerts.kindly help me [closed]
I have configured to fetch the data on every 1 min from investing wesite.
The table data is fetching from website. while trying to update date when 15 minutes status D column change to either strong ...
-2
votes
1
answer
391
views
Google Spreadsheet Find and replace Script
I really need a script to perform the following result when there is K present in the a range "B1:B7".
Data is :-
A B C
12.2K
13.30K
15.19K
17.19K
12
The ...
-2
votes
1
answer
2k
views
How to sort names in column alphabetically ignoring "The", "An" & "A"... and then pull names (skipping duplicates) into another tab [closed]
This is for a Movie Have/Want list using Google Sheets.
Problem 1:
Column A is the movie Title. I would like to be able to sort the movie titles alphabetically but ignore when a movie title begins ...
-2
votes
1
answer
4k
views
Insert Text Google Spreadsheet [closed]
How do you enter text boxes in a google doc spread sheet?
In google doc excel spreadsheet, I want to skip a few spaces between words. Google doc allows me to insert spaces, but when I am finished ...
-2
votes
2
answers
1k
views
Not getting sub date granularity in Google Sheets trend lines
My data is in variable increments, anywhere from six to eight hours apart like so:
1-1-2011 00:00:00 100
1-2-2011 00:00:00 103
1-3-2011 00:00:00 107
1-4-2011 00:00:00 109
1-4-...
- 155
-2
votes
2
answers
40
views
How do I copy names marked with an asterisk * from one column to another another?
I've got a list of student names in Column A. I need to copy the names that are followed by an asterisk * (I've highlighted them in the screenshot) into the * Seniors column D. Is there a formula I ...
- 1
-2
votes
1
answer
56
views
Google Sheets Import XML
I'm trying to import the price from this products website: https://www.mobilesentrix.com/lcd-assembly-with-steel-plate-pre-installed-replacement-for-iphone-xr-aftermarket-aq7
But struggling to use the ...
- 1
-2
votes
1
answer
71
views
Extract a code from the end of a text string that contains Chinese characters in Google Sheets
I have the following situations and want to solve it with 1 formula:
extract FV3883 and 38 from the string
originals NMD_R1 女款 白蛇紋FV388338
extract VN0A3WM1TUT and 35 from the string
Sk8-Hi Reissue CAP ...
- 1
-2
votes
1
answer
41
views
Help on making Google Sheets script quicker and more efficient
I have the following script, and I would like to know if there is anyway to make it more efficient? It works great, but takes a little time to do what it needs to do. Mainly is there a way to condense ...
-2
votes
1
answer
68
views
i can't find the problem to this formula
=UNIQUE(QUERY({IMPORTRANGE("1xWx1FRfvCfmvYi9Sb7Gh5lIAb-NAt0RG0h-e_HKmxjU","APP Directory!A2:U");IMPORTRANGE("1xWx1FRfvCfmvYi9Sb7Gh5lIAb-NAt0RG0h-e_HKmxjU","APP ...
- 1
-2
votes
1
answer
704
views
Exponential Moving Average
What is the formula of Exponential Moving Average (EMA) in Google sheet ?
How it can be used to calculate Share market stock EMA of different period. Eg 5, 21, 50 Days.
Can anyone share Demo sheet.
-2
votes
1
answer
292
views
Show insignificant zero
I want, when I write a Number in a Cell, that the zeros are still visible. In a Google sheet.
e.g. when I write 1.050, or 1.0 or 1.2000 there should stay exactly that.
Not 1.05; 1; 1.2 or something ...
- 1
-2
votes
1
answer
386
views
Setting ImportRange on a delay
Is it possible to set a timer or delay for the importrange function on Google Sheets?
-2
votes
1
answer
5k
views
OnEdit not working when edit
I'm having an issue with this code and hope you could help me. I'm trying to run a script that builds a Data Validation when a cell is edited. I can tell it reads all the information but when I try to ...
-2
votes
1
answer
2k
views
Change labels of Google spreadsheet [duplicate]
I would like to change Google spreadsheet header labels. I would like to change A,B,C... to more detailed descriptions. How do I achieve this?
- 243
-2
votes
1
answer
1k
views
How to get proper "weighted" average of one column's data based on number values found in another column? [duplicate]
I'm trying to get the true average "position" in Google (as per Google Search Analytics data) for specific search query filters (e.g., all queries containing "xyz")
Here's a link to my spreadsheet ...
- 648
-2
votes
1
answer
986
views
Lock a column based on the date
I have an Employee attendance register in Google Sheets, wherein I want to lock the particular column/s after the date is passed over.
This feature is required for the clerk to enter the date on the ...
-2
votes
1
answer
178
views
Google Sheets double click fill down not working
If I select a cell and then double-click on the blue dot at the bottom-right of the cell, the fill-down function does not work, nothing happens.
Sometimes it does work, in other cases/columns.
The ...
- 183
-2
votes
1
answer
47
views
How to write in a proper way to skip copy the empty rows from this form? Thanks!
function ClearCellRegistroMovimientos() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var formS = ss.getSheetByName("Registro de Movimientos");
var RangeToClear = [ "F7"...
- 1
-2
votes
1
answer
31
views
Have answer cell read text different than what is displayed in cell it is pulling data from
I have the following table of data with the row of focus highlighted in red. This is being done on Google Sheets.
With the following summary page and row of interest highlighted in red
The question ...
- 1
-2
votes
1
answer
24
views
Conditioned formatting of a cell in relation to another cell
Cell B1 should be colored red if cell A1 contains a certain string.
I thing this should be possible but I don't succed.
Thank you in advance for your answer!
-2
votes
1
answer
960
views
Search for multiple words in a single cell in multipole columns in google sheets
I wrote the Indexes of my notebooks in Google sheets to make them easy to find. But the Find function only looks for one word in the Google Sheets cell.
My notes look like this:
"Chemistry class ...
- 1
-2
votes
1
answer
26
views
how do I get the sum of hours, from 13:30 to 13.5
How can I have the sum of hours and minutes? For example, I enter in A1 14:20:00 how can I have in A2 the sum that's 14.33?
-2
votes
1
answer
77
views
Is there a spreadsheet function, than means same formula as a specified cell?
In google sheets. I wish to have the same function in several cells. I could copy the function to all the other cells (this will work). However if I want to change the function, then I need to copy it ...
- 468
-2
votes
1
answer
77
views
Move cell values from one cell to another with scripts
Move cell values from one sheet to another using a button.
Consider 3 sheets.
One sheet is called "Tentative Attendees."
It contains a column of names. Say cell A1 contains "John Doe,&...
- 103
-2
votes
1
answer
460
views
Google Sheets: How can I query all names and display it in another sheet according to it's category?
So I have an employee list and a checkbox according to their skills.
How can I get the employee list and display them to another sheet?
- 97
-2
votes
2
answers
71
views
Allow users to make yes/no decisions using checkboxes
I'm looking for a way my users can interact with my scripts. I'd like to use checkboxes to work like a "yes/no" command, where the script does "A" if the checkbox is ticked, and &...
-2
votes
1
answer
44
views
Google Sheets atomisation
I hope you are all well and healthy!
I am looking for a solution in Google Sheets to automate something like this:
and it could auto generate something like this
Thank you in advance
- 1
-2
votes
1
answer
17
views
Import Values and Sort them by there Type
I have a little trouble with Google Drive sheets / forms.
I need to import the answer from one of our forms into another document. The main problem for me is now, I only need the import if the game ...
-2
votes
1
answer
16
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 ...
-2
votes
1
answer
30
views
Certain cells do not 'Work' in formulas
So I'll just dive right in. A cell(s) won't work in a formula, for whatever reason. I've tried everything, including duplicating the data to a new section in the spreadsheet, resetting the font/...
- 97
-2
votes
1
answer
30
views
How could I declare my variable C58?
I made a document for work supposed to help my everyday life. It is working Ok but I would like to add some extra features BUT I don't know much about Google scripts.
I searched on google docs help ...
-2
votes
2
answers
39
views
Formula to get the value in the cell(i,j)?
How to get the value in the cell(i,j) of a sheet named 'Sheet X' in Google Spreadsheets? (line i, column j)
- 109
-2
votes
1
answer
203
views
Count in Query not returning anything
When I use the syntax:
=query(Clients!A:J,"select H where (H='Yes')",-1)
I only get "Assigned" as a result, no # of records.
-2
votes
1
answer
1k
views
Conditional data input validation in Google Spreadsheet
I have spreadsheet that contains three pages:
Projects
Tasks
Tasks are related to Projects
Calendar
Related to Projects and Tasks.
When I select Project in Calendar and go to Task drop down I ...
- 243
-2
votes
1
answer
70
views
How to extract the Account's Name according with the total of members? [closed]
For each relevant row I would like to have ColumnC populated with the value from ColumnA repeated (one above the other) in the C cell the number of times there are separate (one above the other) ...
- 15
-2
votes
1
answer
46
views
Input range as a concatenation [duplicate]
I want to put this
="'Other Sheet'!C"&D5
(where D5 = 1432)
in a cell and get the actual value the formula refers to rather than the formula as a string (current result).
How can I do that?
- 79
-2
votes
1
answer
12k
views
Freeze Image in Google Spreadsheets
I have a spreadsheet (see screenshot below). I want to freeze the image so when I scroll down, the image always stays visible while text rows are scrolled. How can I do this?
- 9
-2
votes
0
answers
28
views
Apply formula to a numeric part of cell value [duplicate]
In a Google Spreadsheet, I have a column of task IDs, with values like T1, T2, T13 (i.e. all values starting with the same text). I would like to use a formula on the values of these cells (for ...
- 769
-2
votes
1
answer
1k
views
Use regexmatch to determine if one cell's content contains another's
I want use a cell in regexmatch as regular_expression parameter.
My goal is to draw green background for A1 if B1 contains A1 inside of it. How to do this with regexmatch?
- 105
-2
votes
2
answers
22
views
i want that webp urls are arranged in the same order as jpg urls
webp urls have the same names as jpg urls. i want that webp urls are arranged in the same order as jpg urls. they're in Y2:Y17 in google sheets. jpg urls are in Y2:Y9 and webp urls are in Y10:Y17. ...
-2
votes
1
answer
113
views
Create a dropdown list that only shows items marked as unused! [closed]
I created a table with the list of clients and the licenses they use in different apps, themes, scripts. And these registered licenses appear in a dropdown list so that I can select, but I would like ...
-3
votes
2
answers
231
views
How to create a "yes/no" answer based on multiple variables
I am trying to create a formula to display "PASS" or "FAIL" based on 5 other columns' information.
As long as the numbers in the 5 other columns all meet or exceed the minimums needed then it should ...
- 81