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.

Filter by
Sorted by
Tagged with
0 votes
0 answers
9 views

Uncaught ReferenceError: Token is not defined [closed]

I'm following this tutorial - https://www.youtube.com/watch?v=XdKv5uwEk5A&list=PLS5SEs8ZftgWFuKg2wbm_0GLV0Tiy1R-n. After using the command truffle migrate --reset the blocks appear on Ganache GUI. ...
user avatar
0 votes
0 answers
16 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 ...
user avatar
0 votes
1 answer
12 views

Google sheets indirect formula question

I have a list of students that in Column A has their first name and then in following columns has their specific data that I am interested in. I have removed last names and data as it is sensitive ...
user avatar
  • 1
0 votes
0 answers
15 views

Google Sheet Crashing Error Code: Out of Memory or RESULT_CODE_HUNG

I'm a documentation manager and have a Google Sheet that serves as the primary tracker of my team's active pipeline of documents. The file is quite large and includes a lot of formulas and scripts to ...
user avatar
0 votes
1 answer
19 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 ...
user avatar
  • 3
0 votes
2 answers
28 views

Google Sheets: Sum till particular date

I have time-series data that follows no predictable entries. For example as below. Date Units 01 Jan 2022 1 05 Jan 2022 2 08 Jan 2022 1 30 Jan 2022 1 04 Feb 2022 1 10 Feb 2022 1 13 Feb 2022 2 ...
user avatar
0 votes
1 answer
16 views

Trying to stagger data on Google Sheets

I've been trying to understand how to stagger my data in sheets and could really use some support. I've made up a bunch of bullshit data and assumptions to help explain. Let's say I have the following ...
user avatar
  • 1
0 votes
0 answers
5 views

How do I add a source to Google's article feed? [migrated]

I regularly get notifications on Android from Google about news stories/articles that have obviously been sourced based on my observed interests. How do I "inform" the feed that I'd like ...
user avatar
  • 141
0 votes
1 answer
20 views

How to find duplicates within each multiline cell against a range of multiline and single line cells?

I am a novice with Google sheet, please pardon my ignorance. I inherited a data sheet that I am trying to improve. It's a massive data that continues to grow each day. The daily task: I receive a list ...
user avatar
0 votes
0 answers
35 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 ...
user avatar
0 votes
1 answer
23 views

IF formula for Multiple Rows

I'm trying to create an if formula to look at an entire column and if it matches a number of rows then add the value_if_true. So I want to look at the entire column C to see if there is a match to ...
user avatar
  • 1
0 votes
1 answer
19 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. ...
user avatar
1 vote
2 answers
33 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 ...
user avatar
  • 11
1 vote
0 answers
81 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 ...
user avatar
0 votes
1 answer
29 views

Forward event invite to new Gmail

A coworkers emails were being sent to spam when emailing people outside of our organization. This was because someone previously had the same email as her in our system and must have gotten flagged as ...
user avatar
0 votes
0 answers
10 views

My Google searches are doing too many redirects

Recently, when I try to do a Google search, it says "too many redirects" on Chrome. No Google search pages work, but everything else does, Google Drive, Google Docs... I have tried clearing ...
user avatar
0 votes
1 answer
21 views

Creating email address from scratch

I have a set of data which includes first name, last name and company URL. I have created a drop down list to choose an email format from a list of 14 variations eg firstname@url.com or firstname....
user avatar
  • 1
1 vote
1 answer
33 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 "...
user avatar
  • 13
1 vote
1 answer
28 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 ...
user avatar
0 votes
0 answers
31 views

Scraping Directory contents from Google

Does anyone know of a good way to scrape the information from the Directory in Google Contacts? I saw this How to download all directory contacts?. I tried to run it by following the steps layed out, ...
user avatar
0 votes
0 answers
41 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 ...
user avatar
  • 419
1 vote
1 answer
10 views

Google sheets validation dropdown changes option order — can I stop this?

I am trying to speed up data entry using a validation range sorted with most-recent values first. When I click the dropdown triangle, the values appear in a different order from the validation range. ...
user avatar
0 votes
0 answers
40 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 ...
user avatar
0 votes
0 answers
47 views

Can I sort by one column and if its empty use a different column?

I have a google sheet with 5 Tabs, 1 being the master calendar and 2-5 being individual class calendars. They each look like this: Class Type Name Date Open Time Open Date Due Time Due TMA Reading ...
user avatar
0 votes
0 answers
26 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" ...
user avatar
0 votes
0 answers
9 views

Google photos app synced w iOS photos

I store photos in my ios photos app. Someone sent me an email with photos attached, and in order to view them I had to install google photos. I mistakenly gave the app access to all my photos and now ...
user avatar
  • 1
0 votes
0 answers
14 views

What happens when a google search query is too long?

If a google search is attempted that is too many words, it produces the message "... (and any subsequent words) was ignored because we limit queries to 32 words." If it is even longer, ...
user avatar
1 vote
1 answer
38 views

From old to new layout in Google books

Sometimes on books.google.com the layout of the page is the old one (see figure below please). Is there a way to switch to the new one? Old New EDIT: the option suggested in the reply is not present....
user avatar
0 votes
0 answers
9 views

used my personal laptop but wife signed into google account at home

unfortunately, I used my laptop at home on my network, but my wife had logged into her work google account. I noticed that google web activity is turned off in her account, its a setting not available ...
user avatar
  • 1
0 votes
0 answers
27 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 ...
user avatar
  • 101
0 votes
0 answers
19 views

How is 40GB possible on Google Drive (not paid)(anymore)?

We've come to encounter a Google Drive account which was once paid since the data grew on it, then the payments stopped, but the data still exceeded (around 22GB total) the quota of FREE tier which is ...
user avatar
  • 419
0 votes
0 answers
41 views

Hiding Google Sheets Formulas From Viewers

I've searched everywhere on the web, but couldn't find anything that helps me. I'm looking for a way to share a google spreadsheet but I want to hide my formulas from the viewers, the importrange ...
user avatar
1 vote
0 answers
57 views

Is there a way to exclude video results from Google Search?

Sometimes I am specifically looking for a written tutorial on a subject (in a blog format, etc), but all I can find are video tutorials in Google Search results. This is especially frustrating when I'...
user avatar
0 votes
1 answer
62 views

How do I turn off YouTube search predictions? (not search history)

When I type something into youtube, it comes up with a list of suggestions of things I have not searched before. How do I turn these off?
user avatar
  • 168
0 votes
1 answer
69 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 ...
user avatar
0 votes
0 answers
25 views

Why hasn't Google bought DeepL yet?

I've been using DeepL (https://www.deepl.com/translator) as my main translator for 4 years already because it's the best one I've found. Due to how far ahead it's from Google Translate, and to the ...
user avatar
0 votes
0 answers
15 views

Google Group Mail Sending Problem (2022)

I have a Classic Google Group of 53,000 people. Up to 10 days ago, I could send an announcement-mail newsletter without any problems. I have to send 4 subjects a day. I have been using google groups ...
user avatar
  • 1
0 votes
1 answer
76 views

Sum Duration with google sheet

How can i sum duration with google sheet? I need to sum this value 1:14:127 1:14:057 1:13:938 1:13:894 I set the cell with duration "mm,ss,SSS" and i try this formula =sum(a1:a4) and =TEXT(...
user avatar
0 votes
0 answers
12 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 ...
user avatar
0 votes
0 answers
28 views

How can I see the locations having more than 1000 reviews on Google Maps, in a certain area?

I am wondering how can I see the popular locations (e.g. having more than 1000 reviews), on a certain area on Google Maps. This would be helpful when traveling quickly through a city, to find ...
user avatar
0 votes
0 answers
16 views

Google Sheets Conditional Formatting for Expiration Dates with Colors

I need to create conditional formatting for expiration dates of gift certificates: Gift certificates are valid for 60 days. Cells should stay green between days 0-30 before expiration. Cells should ...
user avatar
0 votes
1 answer
23 views

Google Sheets Formula in Series

How to Formula A2=1 B2=2 C2=3 if all are in series (123) it must be TRUE If A2=2 B2=3 C2=2 not in series it must be False
user avatar
0 votes
1 answer
19 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 ...
user avatar
0 votes
1 answer
116 views

Filter by Condition in a list using custom Formula

I've googled this various different ways, but haven't found anything that has worked. I have a list that needs to be Private filtered by condition using a custom formula in google sheets. In Sheet2 I ...
user avatar
  • 1
0 votes
2 answers
40 views

Google Sheets SUM of multiple cells which have a monetary value assigned VIA a previous row

I am wondering what the proper equation format would be in order to get Row 2 with its numbers to correctly add up to the proper monetary value based on what is in Row 1. There is 1 of each ...
user avatar
1 vote
1 answer
285 views

A suspicious app was blocked from accessing your account - How to check IP or app name?

Last days Google is sending me a "A suspicious app was blocked from accessing your account". I'm a developer and it can be one of my apps but I can't find a way to see what IP or App name is ...
user avatar
  • 111
0 votes
1 answer
49 views

Google Sheets IFS Text result based on multiple conditions FIX & SORT

I'm very new to Google Sheets and I'm trying to make find the correct formula for a text result based on multiple conditions, here is my best crack at it: =arrayformula(IFS(B9:B="",V9:V=&...
user avatar
0 votes
0 answers
24 views

How do I remove a purchased show playlist from my YouTube Library?

I purchased a series from Google Play Movies and TV. On YouTube, I added Season 1 of the show as a playlist, but there is no option to "Remove From Library" (picture 1) as there usually is ...
user avatar
  • 168
0 votes
0 answers
41 views

How to create a google sheets formula to return a value based on % values in other cells & weighted average formula? (FIXED)

I've been trying to create a scoring system for expected stock market returns - Sheet I'm having problems creating a formula to firstly give stocks a score in multiple conditions for example SS I want ...
user avatar
0 votes
0 answers
18 views

I want to forbid Google Meet from changing input volume when I'm using it in Google Chrome

I am irritated to the brim that Google Chrome allows Google Meet to change the input volume on my mic when I'm using Google Meet. How do I disable that atrocious, brainless feature? Right now, I'm ...
user avatar

1
2 3 4 5
7