Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

0
votes
0answers
12 views

Blocking cell after changing it's color

I have created simple formula in google sheets which is going to be shared with many people. Sheet will be secured except few columns. I want to let those people edit cell's color in those columns. ...
0
votes
1answer
8 views

Working with multiple If statements, data validation and multiple sheets in Google Sheets

I'm working on a spreadsheet and could really use some help. I'm trying to populate cells in a main worksheet with cells from another worksheet within the spreadsheet. Currently I'm planning on ...
0
votes
1answer
13 views

Splitting multi-line cells into rows

I'd like to be able to split multi-lined cells into rows using only 1 command. I have tried using the command =transpose(split(A2," ")) but when trying to add the 'tab' key as a custom separator ...
0
votes
0answers
12 views

Google Apps Script to Copy data from Sheet1 and Paste in Shee2 Specific Columns

I am trying to copy paste data from Google sheet1 to sheet2. I can copy data from specific cells but I am not able to paste data into specific sheet2 range. My function is automatically pasting data ...
0
votes
0answers
16 views

Import Android phone SMS into Google Sheets

I would like to import some filtered SMS from my Android phone to Google Sheets. It could be done: regularly (i.e. every 20 minutes), event based, when an sms is arriving and matches one or more ...
0
votes
0answers
8 views

Automatically import a range from a different Google Sheet at HOURLY intervals

In a google sheet, I have a dynamically changing cell that updates production every few minutes. Each hour, I want to pull the new number to my alternative sheet, so that I may get the total ...
0
votes
1answer
19 views

How do I reference a string from a cell in a Google Spreadsheet formula?

I have a spreadsheet that I use to track progress completion based on the percentage of checkboxes that are TRUE (checked). The formula I use for this has 3 separate references to another sheet. I do ...
0
votes
0answers
6 views

Have column B clear itself if column A's value increase past set intervals

I have little to no experience with scripts, just start using Google Sheets. That being said I don't know if what I want is possible. I have a data sheet that keeps a continuous counting check using a ...
0
votes
0answers
15 views

Is there a way that I can flag in Google Sheets when multiple cells contain the same values?

I'm wondering if someone can help me in my battle with Google Sheets. I'm creating a rota and I want it to flag if all senior members of staff are either off or all on the same shift (either Early or ...
0
votes
0answers
6 views

Seeking formula for multiple columns where one=true and all others default to false

I have a Google Spreadsheet with check boxes in four adjacent columns. I want to drive the user to select one check box (of their choice) and have the others default to "false". The formula below ...
0
votes
0answers
21 views

Button that Creates New Row and Copies Functions/Format

I am attempting to script a button, that when pressed, will create a new row below the currently active cell and copy all of the formats and formulas from the row of the cell that is selected. I was ...
0
votes
0answers
15 views

How do I interleave rows of data in Google Sheets or Excel

I have data on several different worksheets and I want to combine into single sheet. The data is text, not numeric. I can do this work in either Google Sheets or Excel. I have: Sheet1 R1 Sheet1 ...
0
votes
1answer
23 views

How to Fix Error in Multiple Importrange

I am creating a table to display data from a combination of several Spreadsheet files by using Multiple Importrange. = QUERY ({Importrange (G3, "Sheet1! A2: D"); Importrange (G4, "Sheet1! A2: D"); ...
0
votes
1answer
10 views

Google Sheets Conditional Formatting For Dates and a Blank Row

In Google Sheets I am trying to use conditional formatting to change the format of a column of cells if the date in that column it more that 14 days before today, AND if a separate column is blank. ...
0
votes
1answer
39 views

Set formula into a cell based on content of another cell?

Google Sheets: I would like to set a formula into a cell, but this should depend on content of another cell. Example Google Sheet (anybody can edit): https://docs.google.com/spreadsheets/d/...
0
votes
1answer
20 views

Google Sheets Conditional Formatting Multiple Cells with Different Colors

I am studying for a big exam and want to set priorities using conditional formatting. For example if C90, C91, C92 are blank than the color would be white; if C90, C91 are blank but C92 is not blank ...
0
votes
0answers
18 views

timestamp for specific value change in different column

I want an automatic timestamp to appear in column D ('Receive Date') when the value in column B ('Status') is changed to 'Received'. I have the script below, but it inserts a timestamp regardless of ...
0
votes
1answer
25 views

Script that allows you to take a list and create a tab for each item in the list

I have a table with columns: PID, Project name, ... (14 Columns) like this PID Project_name Department Plan Effort estimation .... 111 Project1 qw 50 60 111 Project1 sw ...
-1
votes
0answers
15 views

Google Finance update in Google Sheets

I want close of a stock for every 15 min in Google Sheets. The previous data in intraday should be available along with the current data.
0
votes
1answer
15 views

How to name a range so that it doesn't automatically change when rows are added in between

Is there a way to name a range so that it doesn't automatically change when rows are added in between? Ex: Range1 = 'Sheet1'!K5:K36 Add a row between rows 6&7 and now this automatically changes ...
0
votes
0answers
18 views

Values of a sheet not updating

I'm trying to send data to another spreadsheet. To do it, I wrote a code which I've been using for months, but I'm trying to use the same code with another spreadsheet and suddenly the code stop to ...
0
votes
1answer
27 views

Is it possible to make a custom sort on column other than A-Z or Z-A in Google Sheets?

The Sheet has a column with cells populated by a dropdown list offering 3 choices: Good; Very Good; Rejected; In that context, it would be practical to sort the column according to a specific/custom ...
0
votes
0answers
16 views

Google Sheets Script Apply update function to only the sheet names “Analyses”

I want to apply the script below to only the sheet called "Analyses" function onEdit() { var sheetName = "Analyses"; var s = SpreadsheetApp.getActiveSheet(); // Get spreadsheet name var ...
0
votes
1answer
13 views

RAND() cause miscalculation in “Link to Sheets”

=IF($AI$2<>"",AH34,$AJ$2+($AK$2-$AJ$2)*rand()) That formula is used to freeze rand() value. I am able to "Link to spreadsheets" on Google Docs / Google Slides, but right after the copy, it ...
0
votes
0answers
11 views

Add one column after E column in all sheets [duplicate]

any ideas how can I add a Column after a determinate column in all sheets in one time?
0
votes
0answers
14 views

Google Sheets: Get the user to draw in a box

So, it's kinda difficult to explain what I actually need here. I'm trying to create an electronic register for the school I work with, but they require some specific things. I added the date picker ...
0
votes
1answer
11 views

How to set a cell is a formula equal to another cell?

I have a sheet of formulas, and I want to duplicate it several times for different data set. If I use ='Sheet1'!A1 in A1 of Sheet2, it will copy the value but the formula. Is there a way to copy ...
0
votes
0answers
14 views

Change Y-axis Series' aggregation function from Sum to Average in Google Sheets' Bar Charts

I need to do something pretty basic - change the (Y-axis) "Series"' aggregation function from Sum to Average in a Google Sheets bar chart. I see how to do so in the official documentation and in the ...
0
votes
1answer
13 views

Avoiding an authorization request for Google Scripts

I'm in the midst of trying to custom code some script that will automatically hide some sheets from some users in a shared company spreadsheet. Yesterday it seemed to be working fine, but now it seems ...
1
vote
0answers
17 views

In Google Sheets, how can I use SUBTOTAL with an IF argument?

My N column data is either "Win" or "Loss", now I'm trying to count them separately with SUBTOTAL because I utilize filters quite often. I'm trying something like this: =SUBTOTAL(103, IF($N18:$N, "...
0
votes
0answers
8 views

Using ImportXML to scrap data from SimilarWeb

I'm trying to figure out how is working the importxml function, and so far it's quite complicate. I'm trying to scrap a specific data (the unique user per months) from this website: SimilarWeb I ...
0
votes
2answers
52 views

The script does not have permission to get the active user's identity

Anyone know why this caused The script does not have permission to get the active user's identity.? I don't have any functions that asks for the user identity. So I'm a little confused. function ...
0
votes
0answers
15 views

Google Sheet - Help returning 'Top Earner' each month

I have a sheet logging participation each month by members with multiple accounts, initially used the top account to track the top earner but after adding a tab to consolidate accounts by member I'm ...
0
votes
1answer
23 views

Relative self links

I need to create a relative link (eg #gid=0&range=B10) to the doc/sheet itself. What are some solutions?
0
votes
0answers
8 views

Show counts inside histogram columns?

After creating a histogram I would like to show the exact counts inside each column, like drawn here.
0
votes
0answers
27 views

Is there a way to make Google Sheet chart in Google Slides have a transparent background?

In my Google Slide, I have linked to a chart from a Google Sheet, and I want it to have a transparent background. In my Google Sheet, on the chart, I have the background set to "None", which makes ...
0
votes
0answers
8 views

How to auto-sort from a drop down box?

Without having to manually auto sort alphabetically, how can I get it to automatically sort when creating a new project and choosing A,B,or C, from the drop down menu in the the first column. See ...
0
votes
1answer
14 views

Getting changeType Attribute in edit Trigger Google Apps Script

How can one tell the action triggered the onEdit function in Google Apps Scripting? The actions I have found to trigger it include: edit a cell delete a cell or range cut or copy a cell or range Copy ...
0
votes
0answers
21 views

How to use Sheet, Range protection and Conditional formatting simultaneously in Google Sheets?

I have created a google sheet for my sales team having two members. Gave access to them for two columns (Followup Date and Status) to fill their daily report. I have created another column '...
0
votes
2answers
18 views

Conditional Formatting IF (cell column B) THEN (cell column C)

I'm trying to format a Google Sheet to speed up some data entry at my job, tracking the cost of a few different articles, which all have a 3 letter code associated with them, so that all I have to do ...
1
vote
1answer
45 views

Add a new row to a spreadsheet, copying down formulas when a certain cell reaches a particular value

I've got a simple Google Sheet (it's literally one line), that has in A2 =now() to calculate the current time, and then a series of formulas calculating various dates/times based on the current date ...
0
votes
0answers
19 views

Google Script Reset Filters

I have what seems like an odd question. So I've been working on a spreadsheet that auto populates data based on which sheet you select in a Drop Down menu made through data validation. I also have ...
0
votes
1answer
12 views

Alternate to nested if statements (alternate posing of question)

Sample Data Sheet: https://docs.google.com/spreadsheets/d/1EIQcpzwdaoNSKEPu-F1NCUOtEjS6Ez0P73dmotClT7Q/edit?usp=sharing The end goal is to have a Month + Year show up in a single cell, based on the ...
0
votes
0answers
7 views

Pivot table - limit data source for detail report

Is it possible to prevent certain columns from appearing when a detail report is created? I have a pivot table from a range of column, most of which are hidden. I would like the detail report to only ...
0
votes
0answers
5 views

Persist Cell Selection in Google Sheets

When I am edit (not just select) a cell in google sheets, can I just keep the caret and the cell data where it is after scrolling down (i.e so it is 'off screen' instead of having that floating input ...
0
votes
1answer
23 views

Alternate to Nested IF statements

Goal here is to have the sheets search a row, then once it finds the first instance of >=0, return the cell value that contains the month+concatenate the value in the cell next to it (or any other ...
-1
votes
0answers
9 views

Google Sheets trying to see if one cell is found in another list of cells. [duplicate]

I'm trying to figure out in Google sheets whether one 7 digit number is found in a long list of 7 digit numbers. Ex; Is 7878904 found in the list of cells, if it is then output the number. It will ...
0
votes
0answers
10 views

How can I add a formula after text in the same cell in Google Sheets

I'm not really sure how to phrase this. I would like to engage a formula, following some text, in a given cell. Perhaps my attempt will make more sense. Total amount Raised by Students =sum(A11:A50) ...
0
votes
1answer
7 views

How to express a range of values with nested if loops

This is a nested if loop I wrote in google spreadsheets Whenever I enter a value for B5 between 0 and 1 like 0.5, it says there is "no match". I think there is something wrong with the last section ...
0
votes
1answer
32 views

Google Spreadsheet IMPORTXML problem to extract from a web page

I'm trying to extract the "Comestibilité" and "Remarques" parts from a page using IMPORTXML in my Google Spreadsheet but I just can't get to them, they are generated by JavaScript but I cannot figure ...