Questions tagged [google]
Questions about Google web applications on a broad level. If you are talking about the web search application (www.google.com, www.google.es, www.google.com.mx, etc.) use the "google-search" tag instead.
308
questions
0
votes
0
answers
4
views
Google stopwatch automatic start URL [closed]
Is it possible to have the google stopwatch start automatically? I would like to bookmark an URL and have the stopwatch start right after clicking the link.
0
votes
0
answers
8
views
Google allows to sign in using SMS, but requires only Authenticator while accessing 2-step verification settings
I have several 2-step verification options in the account, including Authenticator and SMS. Authenticator is lost. On signing-in I can successfully use SMS, but when I try to access the 2-step ...
- 111
0
votes
0
answers
33
views
Update Google Sheet Column A + B with new data without losing Column C - F data
I have a document tracking the file size of each project on my server (Column A + B) and important information about each project (Columns C - F).
I need to update the project size each month and ...
1
vote
1
answer
23
views
Is there a function on google sheets that can show where the information from a particular cell is on another sheet?
Could you kindly tell me if there is a function that can help me with this situation?
I am working with two sheets on drive and I would like to know if there is a possibility to make some sort of ...
0
votes
1
answer
75
views
How to repeat query for a range of data in google sheet
I have this table in Google sheet:
Col A (Month)
Col B (Date)
January
1/1/2023
January
1/2/2023
January
1/3/2023
And I have another table:
Col C (Dept.)
Col D (KPI)
Dep1
KPI1
Dep1
KPI2
Dep2
...
- 25
2
votes
1
answer
43
views
automatically generate new dataset from two data sheets // merge google sheets
I have two data sets:
first data set: list of clients who bought a sertain product package:
second data set: list of products for every product package:
what I need is to generate (automatically) a ...
- 35
3
votes
1
answer
21
views
Google Sheets Links between sheets
I have two sheets in one google sheets document. One is a project log with project details and the other is a customer list. I have linked the customer cell to the cell with their project. When I add ...
- 31
0
votes
0
answers
28
views
Filter multiple columns based on two criteria
So I have this 2 columns:
B (white background) A (white background)
A (white background) B (green background)
C (green background) C (green background)
And I would like to make a function ...
user305241
1
vote
1
answer
8
views
Why does google keep not show up in the Google Chrome Apps shortcut below the navbar?
I was wondering: Why does google keep not show up in the Google Chrome Apps shortcut?
Is it possible to adjust which apps getting displayed there?
- 13
1
vote
0
answers
10
views
cannot add 2-factor auth to google account [duplicate]
I have a google account, where supposedly I am super admin, but I can't seem to add 2-factor authentication. My phone number and backup email are attached to the account. But I would like to use an ...
- 111
0
votes
1
answer
99
views
How to stop Google from logging me out?
I have a Google Workspace account, every 2 weeks or so it forces me to re-login in the browser (Chrome). For some reason this never happens on my phone. My PCs/Laptops are just as secure if even more ...
- 785
0
votes
0
answers
16
views
Permanently add markers from a custom Google "My Maps" to my Google maps so visible everywhere
I have created some maps with Google My Maps that show many useful points. Best of all these allow custom colours and icons.
It is possible to see these markers on my regular Google Maps by selecting ...
- 134
0
votes
0
answers
12
views
How do I automatically embed a link to a cell in Google Sheets?
I have a large dataset (1,000+ rows) which contains three columns - grocery item, expiration date, and slot #. I only need to look at the items that are expired, so I created a filter function in a ...
0
votes
0
answers
34
views
How to scrape Google Streetview's timelapse view?
I'm trying to scrape the years available and be able to click through and grab images from google streetview's timelapse view. example url: https://www.google.com/maps/@40.7560546,-73.9869468,3a,75y,...
- 289
1
vote
0
answers
13
views
Question about appealing an account Google disabled, associated with a youtube account
I created a Google account, the intention and usage, was to test uploading youtube videos with a program. The videos had no adult or sexual content in them. Some videos had some clips of videos from ...
- 2,841
1
vote
1
answer
8
views
Prevent the cell from expanding to the size of the monitor size when highlighted or double clicked in a Google Sheets
I've applied text wrapping to my cells but every time I open my cells, it expands. I hate that actually, how can I stop doing this behaviour?
1
vote
1
answer
86
views
Add a constant number to google sheets query result
how do i get this result? i want to get the number one in every row
- 11
0
votes
1
answer
152
views
Number of Days Positive and Negative Between Two Dates?
On Google Sheets, I am trying to create a formula within a single cell that calculates the positive or negative number of days between two dates. Specifically I am trying to determine how much buffer ...
1
vote
0
answers
27
views
Bulk Check Google Results Count with Google Docs
I need to extract the number of results by a given search in google, for example:
1 I search in Google.es Dinosaurs wallpapers and it returns to me:
Approximately 77,000,000 results (0.48 seconds)
I ...
- 11
0
votes
0
answers
5
views
Unable to log in [duplicate]
My gmail account suddenly logged me out, and my phone line was terminated at the same time as well. I was unable to change my 2nd verification number to my new number, so I am having trouble logging ...
- 1
1
vote
1
answer
47
views
How to return table value?
I need to do the following:
If cell is "Situation X" then show in cell next to it value from interval and specific situation.
For example:
If cell A1 is "Situation 6" and value ...
- 11
0
votes
0
answers
17
views
Is there a formula in google sheets which fixes once a value is added?
I'm trying to see if there is a way to add a formula to a google sheets which will then fix the contents once a cell is populated.
Google Sheet Example
In this example, each week I replace the ...
- 19
1
vote
0
answers
13
views
Searching words starting with a specific letter on google? [duplicate]
I want to search for words starting with a specific letter in the same order. Is there any operator in google-dorks through which I can apply wild operations on letters instead of words?
Example: ...
- 11
1
vote
1
answer
22
views
Show most recent date a theatre is visited Google Sheets
I visit 4 theatres regularly, sometimes multiple theatres on the same day but never the same theatre on the same day. I have columns A, B and C in the picture attached.
Column A records the date a ...
- 25
1
vote
1
answer
111
views
How do I use an arrayformula to autofill a column in Google Sheets?
I have a script that automatically adds a new row to Tab 2 when a row is added on Tab 1. However I want my formulas on Tab 2 to autofill into the row that is added. Here is my formula:
=IF(AND(...
- 63
1
vote
1
answer
27
views
Dynamic and not dynamic data in the same Google Sheet
I am taking a range of names from another tab with the formula
=SORT(UNIQUE('brands check'!B9:B8228)) in column B.
I would like to add descriptions in other columns (D, E, etc.), but as soon as I add ...
- 11
1
vote
2
answers
31
views
Array Count by Week in Google Sheets
I am trying to create a running column array that counts the number of occurrences by person by week. It can't be a pivot table or separate array table but a calculated column that updates beside the ...
- 111
1
vote
1
answer
53
views
Formula to count number of cells with a name in if it matches this month
looking for a formula that will count names in one column if it matches another date column which is this month.
Column A - Name
Column B - date
Column C, Row 1 = todays date
The formula would look at ...
- 31
0
votes
0
answers
12
views
How can I match cityID from google analytics with longitiude and lattitude or a different standard?
In the google analytics data API, there is an option for cityId, "The geographic ID of the city from which the user activity originated, derived from their IP address."
The cityId matches ...
1
vote
0
answers
195
views
Google Takeout Backup Missing Google Photos Albums
Google Takeout is not showing all of the saved albums from my Google Photos account from the Takeout options menu when selecting Choose specific Photos data for your export.
There is a discrepancy of ...
- 181
0
votes
1
answer
44
views
YouTube removed the video I liked
So I have liked 1000 videos in total and it was also showing in my liked videos playlist last week. But today when I checked my liked videos playlist there were only 999 videos, but i am sure I had ...
0
votes
0
answers
27
views
Google Sheets, SumIf date in cell matches another date
I have two sheets one with date/times, and names in columns that gets populated automatically from a form submission, and a second one that has dates only across the columns with names down the rows.
...
0
votes
1
answer
49
views
Changing Data Validation drop down lists based on info in another cell?
Ok, I’ll do my best to explain this problem, as I’m not sure that what I want to do is even possible.
Assume the following: cell A1 is either going to equal “Happy” or “Sad”. In the event that A1=“...
- 1
1
vote
1
answer
77
views
How do I hide, close, or collapse the Google Help Assistant sidebar in Google Workspaces? It's covering up the page
Within Google Workspaces, the Help Assistant sidebar is always open and it blocks content on the page, and there's no obvious way to close or hide it (beyond nuking it using DevTools, of course).
...
- 111
2
votes
1
answer
1k
views
Text result of JOIN is longer than the limit of 50000 characters
Sample Sheet
I want to split a column of data, where there are multiple lines in a single cell. I want these split into rows with a formula.
I've got the JOIN formula set up for that and it works ...
- 191
0
votes
0
answers
18
views
How to approach this? Which formula should I use?
I am working on a Google Sheet in which I am classifying a "product" with an id number and I want to pull out data from another sheet that contains 2 things:
confirmation of the id
type of ...
0
votes
1
answer
146
views
Pivot Table - How to copy sum value onto another sheet
I have set up 3 sheets in Google sheets in related to budgeting/expenses.
The first contains the full budget (say Sheet A for example);
The second contains the expenses (Sheet B);
and the Third ...
- 5
0
votes
0
answers
338
views
Populate Google Sheet with Data From People Chip
I would like to create a google sheet that places different information contained in a given contact card in to separate columns with the maximum amount of automation possible.
Is this possible, and ...
0
votes
1
answer
21
views
How can i make a formula to determine payment types
I am having trouble nesting and using multiple criteria. I want a column to determine if payment type was CASH, CHECK or WAITING depending on if the cells for Check# and Payment are containing data.
...
1
vote
2
answers
617
views
Using Query to select colum based on headers
I have a sheet with a large table of data with a header for each column. I want to import a specific column to another sheet using the header name. I am using the below formula to do so (which has ...
- 11
1
vote
0
answers
173
views
Google Suite Legacy edition is going away from 1 June 2022. What are the alternatives? [closed]
I have been using Google Legacy edition (50 users) for myself and friends. I have been using YouTube, Google photos etc across all these accounts. Now I have less than 2 months to figure out what to ...
- 111
1
vote
1
answer
1k
views
sumif not working sometimes
I have read similar questions but unfortunately didn't help me.
Here is a copy (with sensitive info redacted) of my data.
Google Sheet
In column U and V I am trying to sum columns D to O if T is "...
- 13
1
vote
1
answer
31
views
Student Pilot Spreadsheet - Retrieving date of last landing
Overview
As a student pilot I try to keep record of all my flights, total hours, costs and number of landings in Google Sheets.
As a safety measure our aviation safety agency (EASA) requires pilots to ...
- 23
0
votes
1
answer
138
views
Can't login to AdMob
When I try to login into Google's AdMob I get following error:
You do not have access to the AdSense account that is connected to
your AdMob account. Learn more
Now from what I've found it all ...
- 459
0
votes
0
answers
57
views
How do I search for PDF non-embed fonts?
I am trying to upload a pdf to KDP Amazon Publishing. My book was created in google docs. I save to print PDF and upload the paperback manuscript, but it has non-standardized fonts. How do I find the ...
0
votes
0
answers
146
views
Multiple IF statements and VLOOKUP in Google Sheets
I have a IF statement VLOOKUP statement working, this took me a while but it is as follows
=IF(AX16="A091";(VLOOKUP(AZ16;Tables!$A$297:$B$309;2;FALSE)))
Basically if AX16="A091" ...
0
votes
0
answers
93
views
Adding content to Google knowledge panel
I recently verified my Google knowledge panel. As I am not a celebrity, the panel has very little info (only title and education). There is a help article on how to update the knowledge panel, but ...
- 101
0
votes
1
answer
444
views
"#NUM!" error in Google Sheets Script
When trying to Run the following script the result is always a #NUM! error - (Result is not a number) in cell "O5"
Both the cells are in currency format and I've tried changing them to ...
0
votes
1
answer
18
views
How to batch deliver Gmail inbox and labels/categories?
Is there a way for Gmail (or an extension) to delivery new messages in bulk at pre-specified times or upon request. It would be like 'send/receive' with the receive on pause. Ideally, I would like ...
- 1
1
vote
1
answer
167
views
Google Sheets ISBETWEEN nested function pulling values outside of set range
I am using a nested ISBETWEEN function with the filter function to pull a list of items that fall in a certain range. Im using this forumula:
=FILTER(U7:U,ISBETWEEN(V7:V,U5,V5))
U7:U is a list of ...
