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.
285
questions
1
vote
1
answer
505
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 ...
1
vote
0
answers
17
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-...
- 11
0
votes
0
answers
126
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 ...
0
votes
0
answers
12
views
How to put every heading in a section to a lower tier all at once in Google Docs?
There is this section in my document that has a lot of Heading1’s, some of them having Heading2’s and Heading3’s underneath. I would like to change all these Heading1’s into Heading2’s, Heading2’s ...
- 1
2
votes
1
answer
49
views
Sum of Cells (supplementary question)
This question which specifically referred to summing a column of numbers until a break and then subtotalling on the next following line was answered very helpfully by this answer.
Supplementary to ...
0
votes
1
answer
392
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 ...
0
votes
0
answers
37
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 ...
0
votes
1
answer
256
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
59
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
27
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
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 ...
user305241
1
vote
1
answer
20
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
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 ...
- 111
0
votes
1
answer
2k
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 ...
- 793
1
vote
0
answers
20
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 ...
- 3,004
0
votes
1
answer
579
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
46
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
1
vote
1
answer
88
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
1
vote
0
answers
14
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
29
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
153
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
29
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
1
answer
117
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
2
votes
0
answers
389
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 ...
- 191
0
votes
0
answers
104
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.
...
1
vote
1
answer
107
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
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 ...
- 345
0
votes
1
answer
465
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
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.
...
1
vote
2
answers
1k
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
2
votes
0
answers
180
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 ...
- 131
1
vote
1
answer
3k
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
34
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
177
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 ...
- 479
0
votes
0
answers
63
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
1
answer
152
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
730
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 ...
1
vote
1
answer
306
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 ...
1
vote
1
answer
2k
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 ...
- 11
0
votes
2
answers
73
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 ...
1
vote
1
answer
449
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 ...
- 111
0
votes
1
answer
174
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=&...
0
votes
0
answers
60
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 ...
0
votes
1
answer
824
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 ...
- 111
0
votes
1
answer
78
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
...
1
vote
1
answer
32
views
Ordering Google accounts
Recently I created some new Google accounts, which messed up my ordering (Ex: /u/3 > /u/7).
I was wondering if I could change this ordering in the URL, as /u/1 - /u/3 are all accounts that I rarely ...
- 13
1
vote
0
answers
142
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 ...
- 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 ...
- 1
0
votes
1
answer
776
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’...
-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 ...
