Skip to main content

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
1 answer
20 views

Installing Google takeout under a different Google account

The site Google Takeout allows you to back up all of your Google data to several takeout files anointing to 2GB each which can be downloaded once ready and backed up to a local pen drive and stored in ...
Joselin Jocklingson's user avatar
2 votes
1 answer
144 views

Export history from Google Podcasts

Google Podcasts will be discontinued soon. There is a way to export subscriptions, but I couldn't find more. I'd really like to export history of what I've listened already, and hopefully my queue too....
Máté Juhász's user avatar
0 votes
0 answers
26 views

This is a Google problem, always reverting the language to the location language

This would be a Google problem then. I think enough people are having this problem and getting so frustrated, me, for one. I live in Spain, but only speak English. Furthermore, I have to change ...
rose's user avatar
  • 1
1 vote
1 answer
1k views

Is there a way to set a semi-transparent background on Google Slides when using a picture as the background image? (not opaque or transparent) [closed]

Without being able to select a translucency level the words get lost on the Google Slide presentation. Is there a way to use pictures that shoe the theme of the slide without this happening? There was ...
Donna Elliott's user avatar
1 vote
0 answers
18 views

Google Sheets ladder linked with Google Drive folder

For a project at school, I have around 340 pages (170 spreads) labeled with the contents of the page/spread in the cell in a Google Sheet. I also have a Drive where every spread has a folder (ie 002-...
dom's user avatar
  • 11
0 votes
0 answers
197 views

Show items with no data in Google spreadsheet pivot table

I have a google spreadsheet. It contains multiple columns. Column A has list of Jira stories. Column D has the status of each stories. Column K has the epic ID of each of the stories in Column A. I ...
Larsen Lamington's user avatar
1 vote
1 answer
864 views

Automatically append text in cell to URL in Google Sheets

Suppose I have a Google spreadsheet with a column of codes which correspond to a URL suffix. In this case, I have papers on arXiv listed as follows: arXiv 1712.03255 2303.14090 2012.02922 How ...
Harry Chittenden's user avatar
0 votes
1 answer
346 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 ...
Sarah's user avatar
  • 35
3 votes
1 answer
29 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 ...
MKB's user avatar
  • 31
0 votes
0 answers
31 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 ...
user avatar
1 vote
1 answer
38 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?
Marc's user avatar
  • 13
1 vote
0 answers
11 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 ...
Alexander Mills's user avatar
0 votes
1 answer
3k 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 ...
gman's user avatar
  • 813
1 vote
0 answers
43 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 ...
barlop's user avatar
  • 3,153
1 vote
0 answers
58 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 ...
user2593287's user avatar
1 vote
0 answers
16 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: ...
sam 555's user avatar
  • 11
1 vote
1 answer
30 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 ...
CellbyDate's user avatar
1 vote
1 answer
167 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(...
dea's user avatar
  • 63
2 votes
0 answers
460 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 ...
AdamHurwitz's user avatar
0 votes
0 answers
133 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. ...
Keegan Miller's user avatar
1 vote
1 answer
126 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). ...
Dai's user avatar
  • 111
2 votes
1 answer
2k 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 ...
Genny's user avatar
  • 365
0 votes
1 answer
599 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 ...
JW2022's user avatar
  • 5
0 votes
1 answer
25 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. ...
Jeremy Wilcox's user avatar
1 vote
2 answers
2k 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 ...
Liam's user avatar
  • 11
2 votes
0 answers
182 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 ...
jerrymouse's user avatar
1 vote
1 answer
4k 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 "...
ali's user avatar
  • 13
1 vote
1 answer
37 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 ...
Klavkjir's user avatar
0 votes
0 answers
65 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 ...
Landry Ratliff's user avatar
1 vote
1 answer
272 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 ...
burger's user avatar
  • 111
0 votes
1 answer
955 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 ...
Cristian Gabriel's user avatar
1 vote
1 answer
3k 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 ...
Cz713's user avatar
  • 11
0 votes
2 answers
89 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 ...
Conor Peters's user avatar
1 vote
1 answer
466 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 ...
Milano's user avatar
  • 111
0 votes
1 answer
210 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=&...
Cristian Gabriel's user avatar
0 votes
0 answers
80 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 ...
Cristian Gabriel's user avatar
0 votes
1 answer
1k views

How to create a direct link to a gmail account that will take you to the login screen

This question seems to be asking almost the same thing, but for some reason I can't get any of the answers to fully work in my situation. I'm looking for a direct link I can put in a web app to ...
Kolichikov's user avatar
0 votes
1 answer
89 views

List of dates, repeating

I have an issue that I cant solve, hopefully someone can give some insights. So, I have a list that contains dates and the number of times something should be done, like this: Date Number of times ...
Carl-Johan Larsson's user avatar
1 vote
0 answers
151 views

How to show Google Group name in Google Drive "Who has access"?

I am new to Google Workspace and have just started using Google Groups. I created a dev group and shared some folders in Google Drive with the group. The problem is that I cannot check which group has ...
h_n's user avatar
  • 11
-2 votes
1 answer
23 views

Calculating % of conditional formatting

I've got a grid of cells filled with either a 'y' or an 'n'. I'd like to work out the percentage of the 'y's. So I need a formula that's something along the lines of: Out of this selection, divide ...
Courtney's user avatar
0 votes
1 answer
999 views

How to copy URL from cell and reference it in script formula?

I’ve been trying to get this script here to work for a while. Everything has been tested and functions as planned, only if I set the “text” variable to a fixed URL. (There are small kinks, like how it’...
IsaacFrye's user avatar
-1 votes
1 answer
17 views

How could I copy information from multiple cells that share a common feature into one cell?

I have a list of codes that are each assigned to a specific bigger case code and I would like to put a list all of the smaller codes that share one bigger case code in one cell. for example D2-D6 are ...
distressed233's user avatar
0 votes
1 answer
86 views

Google Sheet Filter and Match (List the label where a name exist.)

I have 4 game columns that contain the names of the players. I want to list the games of a particular player. A. B. C. D Basketball Bowling Billiards Badminton --...
Dominic's user avatar
2 votes
0 answers
36 views

Why are major email providers separating the username and password forms? [closed]

The trend started with Hotmail, then Gmail and Yahoo followed it. You enter only email address first, then press Next button and a new form appears for the password. Previously, there was a single ...
paki eng's user avatar
  • 170
1 vote
0 answers
108 views

Stop Gmail and Google Calendar from replacing URL's titles

From about 2-3 weeks or so Gmail and Google Calendar (and probably many more) has enabled a "helpful" feature of replacing URL with corresponding webpage's title, when those pasting URL. Is ...
trejder's user avatar
  • 2,700
0 votes
2 answers
87 views

"Count" from unspecified starting points in Google Sheets

I'm a baseball coach creating a Google Sheet to help track pitches and results for my college guys during games so they can see a lot of different information. See attached picture. I'd like the chart ...
Denny's user avatar
  • 27
0 votes
1 answer
142 views

Google Analytics redirect to provision page issue

I cannot register in Analytics. I will be redirected to the page below: https://analytics.google.com/analytics/web/provision/#/provision I even used another browser and browser private mode.
och's user avatar
  • 3
0 votes
1 answer
95 views

On Google Forms, can someone edit their response but can't add a new one?

For example "someone 1" edits their response via the link that I have added in the Google Spreadsheet (https://drive.google.com/file/d/1gtULaR5VEfuLOP4f73Z3KofsnksmpSid/view?usp=sharing), ...
Ismynr's user avatar
  • 103
0 votes
2 answers
2k views

How can I know whether I am a Google One member?

Google sent me this email: Summary of the new policies (effective June 1, 2021): If you're inactive for 2 years (24 months) in Gmail, Drive or Photos, we may delete the content in the product(s) in ...
Franck Dernoncourt's user avatar
2 votes
2 answers
581 views

Copy/multiply cell contents based on number in another cell

I have a list of items, Col. B & numbers in Col. A. I want to multiply/copy the text in cell B based on the number in their relative cell A. I.e. multiply 'B' by the number of times in 'A' Here's ...
Genny's user avatar
  • 365

1
2 3 4 5 6