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
8 views

Counting sheets viewer

How do I use Google Apps Script to find out how many "current viewer" and their status, such as 'idle' or not. I've already search thru all the question and answer, but only found how to ...
0
votes
1answer
10 views

Track highest and lowest number reached in a specific cell over a period of time in google sheets

I have a cell that references the total value of a stock portfolio. I want to figure out how I can let Google Sheets (over a period of time, say a month) automatically tell me the highest number and ...
0
votes
1answer
17 views

Create a list of names of those who answered a question correctly

I have a finished Google Form connected to a Google Spreadsheet - I want to list the names of everyone who answered a specific question correctly. I've spent a while trying to figure out how to do ...
-1
votes
0answers
10 views

Google Sheets- Drop Down + button press = addition to selected cell in drop down

Created a drop down(C1) from list of cells(A1-A10) with number value corresponding to each(B1-B10). Number Entry Box D1 is being used also. Attempting to have the selection from drop down(C1) add a ...
0
votes
0answers
7 views

Google Sheets cant get data from ImportXML on Twitch Clips [duplicate]

So I've been trying to fetch the name of the title of Twitch Clips and insert it into a cell on Google Sheets. On this example below (link to clip: https://clips.twitch.tv/...
0
votes
0answers
14 views

convert image ID in a cell to image URL [duplicate]

I am using an app of my own design that sends a signature as an image to my drive and puts the image ID into a cell. I want the actual image to go into the cell but can only do this with the URL of ...
1
vote
1answer
19 views

Apply Concatenate formula to entire column

How do I apply the formula as described here.. https://webapps.stackexchange.com/a/76395/279173 which is this part: =CONCATENATE(""&LEFT(A1,10)&" ...") to an entire ...
-1
votes
0answers
12 views

How to get a popup on google sheets/doc when certain text is input

I'm trying to create a google document with a classified theme (And no, it's not actually classified) And I want it set to where if you put certain text in a table or cell, it gives you a link to the ...
0
votes
1answer
11 views

What formula can I use to filter and copy to another sheet

Google Sheets Data Set of 70,000 contact records with multiple duplicate entries where name, address, and email may have changed Data includes: Entry ID, Entry date, First, Last, Email, Street, City, ...
0
votes
1answer
11 views

Trying to get an average amount until today's date

I'm trying to create a budget calculator in google sheets. And I'm facing a problem. I want to calculate the average amount I've spent daily until today. suppose, today is 16 July 2021 and I want to ...
0
votes
1answer
10 views

Conditional formatting with dates in Google Sheets

I'm trying to add a little functionality in my register to help me catch incorrectly entered dates. I've got a column, A, for dates where no date entered should be earlier than the previously entered ...
0
votes
1answer
19 views

Auto deleting columns when the field is blank

I have created a form that have multiple sections, skipping sections based upon an answer. I have then linked a Google Sheet to this Google Form to collect responses. These responses are auto filtered ...
0
votes
0answers
12 views

Google Sheets, concatenate cell address [duplicate]

is there a way to concatenate Not a data in the cell, but the cell address? For example: A1: =concatenate( "=B1","+23") so in A1 we had a data from B24 Looks weird.. But is there a ...
0
votes
1answer
15 views

After deleting cell contents, cell is no longer “blank” when comparing in a conditional using == “”

In my else statement below, if a cell in column G is blank I want to clear the contents (the timestamp) of another cell in column F using the event function onEdit(). However, after testing the code ...
0
votes
2answers
25 views

COUNTIF with function in criterion

I'd like to count all cells in a range where a given function evaluates to TRUE. The documentation for COUNTIF & COUNTIFS show text-matching and evaluation of =,<>,<,>, but nothing ...
0
votes
1answer
17 views

How can I use the onEdit() trigger to timestamp a cell if another cell in the same row is checked “TRUE” in apps script?

I am able to add a timestamp in column 5 using a conditional when I'm comparing the column to a number, but what I am actually trying to do is add a stamp to the corresponding cell in column 5 if a ...
0
votes
1answer
30 views

Google Sheets Query with importrange by date range

Trying this Formula: =QUERY(IMPORTRANGE("https://docs.google.com/spreadsheets/d/18r5cARjmlRsbb0VRaAS6kAMkJm1p2qe0LsPCtYLS1xA/edit?resourcekey#gid=561906440","Form Responses 1!A:X"),...
0
votes
1answer
15 views

Google Sheet multiple lookup values and return entire row

I'd like to lookup the activation type in C6 as well as the date range found in L6 and O6 on the "dashboard" tab and return the resulting rows (specifically columns E-J) from the "...
0
votes
0answers
23 views

Grouping rows by value templates

Is there any option to automatically group rows by their values if they fit certain criteria or template? For example I want to group all iOS 14* records into one and all Android 8* into other Plus ...
0
votes
0answers
33 views

Google Spread Sheet Import Question

I have some Google dorks like (Around 4000+) "site:uber.com" site:twitter.com" What I want is to fetch results/links of each search on Google. Is there any way? I add url like that and ...
0
votes
0answers
34 views

Combine multiple Google sheets that can keep updating

Okay, so I think, no one seems to have exactly the same problem as I do... I have an app writing automatically my health data into a google sheet. It does so in three different sheets inside the one ...
0
votes
0answers
18 views

Duplicate and rename a sheet (only it`s data) at fixed hr and day [duplicate]

every monday I've to make a copy of a sheet which is called week_nn, where nn is a progressive number of the current week for that sheet from its beginning. At some point of the day, we have to fix ...
0
votes
0answers
11 views

Google Sheet filter issue [duplicate]

I have a Google Sheet that collects responses from a Google Form, this collects contact details and preferred location. I shall call this workbook Feeder. In a second Google Workbook (called ...
0
votes
2answers
35 views

How can I include two formulas in a single cell in Google Sheets?

I’m in the process of making a spreadsheet of stocks that I’m watching in Google Sheets. I want to include the daily price and percentage change in a single column. I found a helpful Docs Editors ...
-1
votes
0answers
20 views

How can I show historical performance for stocks in Google Sheets?

I’m in the process of making a spreadsheet of stocks that I’m watching in Google Sheets. I want to include columns showing historical performance (1-month, 3-month, etc.) for all the stocks included ...
0
votes
0answers
17 views

Array formula works in the sheet but invalid in conditional formatting

I have a list of time intervals along with their convenience ratings. I wish to highlight intervals rated anything other than impossible which conflict with those rated impossible. I use start1 and ...
0
votes
1answer
17 views

referencing a column in a Google sheets array literal

Is there a way to refer to columns in a literal array like so: =FILTER({lengthy_arrayformula_1, lengthy_arrayformula_2}, condition referencing column 2 of the array literal in previous argument) or =...
0
votes
1answer
11 views

Dealing with data from multiple individual spreadsheets. Should data be merged OR are there better ways to deal with multiple sheets?

I have transactional data (spreadsheets) from different time periods and would like to know if there are better ways to import the data to a mastersheet, than to merge all the spreadsheets into one? ...
0
votes
1answer
18 views

importrange on google shhet

I have a question regarding the importrange() function. This is my formula: =ImportRange("1u0TjjekVHHb6shYiSWoo0W1ygxuSu2tVvLstnEE1NFo";"Juillet!I5") I have about 20 rows of data ...
0
votes
1answer
21 views

Applying conditional formatting independently to each other

Here is an example file for where I want to apply conditional formatting independently of each other First I have highlighted all males in the spreadsheet Then if they are a senior I want the text of ...
0
votes
1answer
19 views

Google Sheets - How can i collect and add values related to a value next to it in a table and add them to another table

I'm using app sheets to see what I do in a day. I select the task i am starting on the app and app sheets dumps the data into a table in google sheets. I have made an example of what this looks like. ...
2
votes
0answers
15 views

If there anyway i can check if the cell contains the result of a arrayformula()?

For example i have this in A1 : =arrayformula(B1:B100) If in A10 i accidentally enter a value (which will overlap with arrayformula result) , it will produce error in the A1 because of existing value....
0
votes
1answer
26 views

Google Sheets - Turning text in cell into an image

I was wondering if it's possible to turn text into a picture. For example the text "Arizona Cardinals" is imported automatically into a Google Sheet and that cell recognizes "Arizona ...
0
votes
1answer
12 views

Need help referencing data from another tab and inserting the result in a single cell

I am having trouble getting this to work in google sheets. I want E2 from tab "Prepack Dashboard" to reference the data in A2 and B2, match those to A2 and B2 in tab "Inventory Minimums&...
-2
votes
0answers
17 views

Clock in sheet time range

Can someone please help with this tried to get time from a range closest 5 minutes: =IF(NOW()-TODAY()<$J6:$J6,IF(NOW()-TODAY()>$J258,$J258,VLOOKUP(NOW()-TODAY(),IN,1))) Range is from 06:00 am - ...
0
votes
0answers
4 views

How to delete my Account since I'm NOT allowed to comment I'm out the door so please tell me HOW to delete my Account [migrated]

Yeah, just joined. Don't see a way to EXIT this group where it says I must have 50 to comment when I'm NOT allowed to comment even ONCE. A complete wa$te of precious time so if you know please inform ...
0
votes
1answer
14 views

Google sheets - how can I use functions to resort my table in a way charts can read it well

I'm using app sheets to see what I do in a day. I select the task I am starting on the app and app sheets dumps the data into a table in google sheets. I have made an example of what this looks like. ...
0
votes
0answers
14 views

Is there a shortcut like doc.new but defaulting to a shared Google Drive instead of My Drive?

I love the handiness of doc.new and sheet.new, but they default to creating documents in My Drive, which I then need to remember to move afterwards. Is there some URL I can bookmark that will create ...
0
votes
1answer
10 views

Send email when there is a change in column

I would like an automatic notification to be sent to several people when I entered 'Yes' in column C. I wish this would apply to Sheet1 only, not to the entire file. I have this code function ...
0
votes
1answer
35 views

Importrange internal error in Google Spreadsheet

I am trying to import data from one Google Sheet to another sheet using import range function, my data is not that large to break it only has four column and rows is 2000 than also when am importing ...
0
votes
1answer
11 views

create data validation (pulldown) from other spreadsheet

I have current spreadsheet (named as INPUT). In this INPUT , i have a sheet named USER. I share USER sheet to other users so they can write data on it (as editor). On cell A1 , i will use data ...
0
votes
1answer
14 views

Hide selected cell indicator from other users

When i shared a spreadsheet, i will see that if other users click on a cell , it will be higlighted in my end. I don't want to see this because it's quite annoying. Is it possible to disable the ...
0
votes
0answers
5 views

Is there a way to make the Google Speradsheet fetch data (ImportXML) wait a longer time to time out?

I use Google Spreadsheet to grab some data from Alexa.com However, it would time out for some cases. Is there a way to make it (the ImportXML method) wait longer?
0
votes
1answer
12 views

Unlinking checkboxes

I have 3 checkboxes. When I check one, others get checked too. How to unlink them? //Validating Permition if(shUserForm.getRange("C14").getValue() == "0"){ ui.alert("Blank ...
0
votes
0answers
16 views

Can I configure MacOS to open CSV and Excel files in Google Sheets? [closed]

Is there a way to have MacOS open CSV and Excel files in Google Sheets when you double-click them? I've tried associating the Google Sheets shortcut in Applications but that doesn't work.
0
votes
1answer
30 views

Google Sheets: Line Graph of alternating columns. 1st Column as label

Month Notes January Notes February Net Worth $500 $600 Liabilities $50 $40 Credit Cards $10 $20 Credit Card 1 $5 $10 Credit Cards 2 $5 $10 Savings & Checking $400 $500 ...
0
votes
0answers
5 views

Data Studio formula for one-to-many count

I have a large table of transaction data that I am trying to analyze. The table is formatted with a transaction having multiple rows depending on the number of items purchased (one row for each item). ...
0
votes
1answer
21 views

Return a list if 2 criteria match in Google Sheets

In an effort to organize staff training: So far I've made the pivot table, but I'd like for the pivot table to extract who needs which training, as a list in one cell. I tried using =JOIN, but I have ...
0
votes
1answer
31 views

Grab the right most value using arrayformula

I have this sheet : https://docs.google.com/spreadsheets/d/163jhtdKcC6Pu34jX9brolZDb5bm-PWqG7i-yAtNueoo/edit?usp=sharing Trying to get the right most value per row Basic formula : =FILTER(B2:2,COLUMN(...
-1
votes
1answer
23 views

How to transpose and split in Google Apps Script?

How do write script for below google form response as below time stamp Document No. Recipient Name Document transmittal ref no 7/9/2021 21:36:11 170709, 170738, 171769, 172003, 172025 Susan 20210001 ...

1
2 3 4 5
143