Questions tagged [google-apps]
For questions about specific features of Google web applications for Google Apps accounts. G Suite (aka Google Suite) is the new name for Google Apps. It is a suite of products for business clients of Google. Do not use this tag for general Google applications.
853
questions
0
votes
0
answers
13
views
How do I get my husbands name and logo off my email account
when I go into my Google home account his logo of a wolf and his name appears above my email address, how do I change it to his email? Or Change the logo (picture) and put my name in.
0
votes
1
answer
30
views
Way to keep spaces in Google App Script alert?
SpreadsheetApp.getUi().alert('foo bar')
When I use this piece of code, it appears as 'foo bar', removing the additional spaces in between. is there a way coerce Google App Script to do otherwise?...
- 365
0
votes
1
answer
20
views
Conditional formatting in Google sheets to indicate overages
To help identify issues faster I am trying to add conditional formatting for column Z to turn red if the amount in that column is greater than the amount in the columns AA or AB and only if column AA ...
- 3
0
votes
0
answers
11
views
how to convert my classic google site
I have a classic google site
I need to migrate to new
But I am not able to migrate because I cant see that in my classic sites manager
I get ---
There are no sites matching the applied filter.
- 101
0
votes
1
answer
17
views
Conditional Formatting in Google Sheets doesn't work in certain cells with custom formula
Custom Formula doesn't work on certain cells.
A little background, I am making a timezone sheet for a discord where someone input the time they wanted and checks who is and is not available at that ...
- 1
0
votes
1
answer
45
views
Automatically apply a formula and a when a new row gets added via a form API
Hi I have a wordpress form, linked to a google sheet that transfers over entries as they come in, now I have some formulas applied, but I don't want to have to add the formula to each new row that ...
- 3
0
votes
0
answers
16
views
Use a Google Font in Google Slides
I would like to use a font I found on Google Fonts inside Google Slides. I tried searching for the font in the font search box, but it didn't seem to be on there. Is there any way I can add a custom ...
- 101
1
vote
0
answers
125
views
Gmail account is temporarily unavailable. "Numeric Code: 2"
I've spent some time sorting and deleting emails from my Gmail account.
Suddenly, I get an error that the gmail account is "temporarily unavailable" with "Numeric Code: 2".
We're ...
- 505
1
vote
0
answers
136
views
I have been locked out of a Google account because I changed phone numbers [duplicate]
I have an old Google account I would like to get into. I know to a certainty the following:
username
password
phone number I registered the account with
I changed phone numbers so I can't receive ...
- 45
0
votes
0
answers
29
views
Search all tabs in entire spreadsheet (Google Sheets)
I am making a simple task manager for three users in Google Sheets.
The data is added in separate project sheets:
A summary page splits all data by user (from the "Who" column), and should ...
- 1
0
votes
0
answers
13
views
Adding the contents of another cell then clearing it [duplicate]
I'm trying to get a cell from any row in column J to update the value of the E cell in the same row but cant quite figure it out. How i want it to work is someone can come along and add a quantity i....
0
votes
0
answers
42
views
Remove passwords shared between google accounts
I have 2 Google accounts, my personal @gmail.com account and my work 'Google Workspace' @[companyname].com.au account, both of which I have separate saved passwords on each account (eg. I have my ...
0
votes
1
answer
285
views
Add more Google Apps to gmail side panel
I mean to add more Google Apps to show when I click on the Waffle icon in the right side panel of Gmail.
In particular, I want to add Groups.
I know I can do two other things:
The "+" ...
1
vote
0
answers
109
views
How to give access to Google calendar - no invitation email sent
There are steps how to do so. In particular
Share a calendar with specific people
On your computer, open Google Calendar. You can’t share calendars
from the Google Calendar app.
On the left, find ...
- 949
0
votes
1
answer
29
views
Is there a way to embed a specific cell from a Google Sheets to Google Docs?
I want to fill in a sentence with blank spaces on Google Docs from information that I can provide from Google Sheets. Is this possible?
"For my student number X = [student_number], the required ...
3
votes
0
answers
183
views
Can I, How do I, stop Chrome from asking to switch/continue Google Profiles when I use another account on Gmail or GDocs
When I login to another of my Google Accounts, Chrome Asks if I want to switch/continue in that profile. I want to be able to stop this notification behaviour, because the pop up is annoying.
I do ...
- 171
0
votes
0
answers
24
views
How to forward all email except from one specific email address of my catchall on Google Domains?
Spammers have found an email on my catch-all and repeatedly send messages to it. I previously had things set up so that I would receive any message to my domain (with a wildcard). Is there a way to ...
- 11
0
votes
0
answers
29
views
Emails sent to google app alias not being marked as spam after reporting
I have a google apps account and a few alias for the same email. Usually, when I get a spam email and mark it as spam, any subsequent emails from that address will automatically go to the spam folder.
...
- 173
1
vote
1
answer
912
views
Can we make copy / download published Google Docs shared by others?
I have a Google Doc link which looks something like this:
https://docs.google.com/document/d/e/2PACX-1vTka35LEjmhp_0Fa8hUkWJazZSkGG5tO0phXt9lKrFdeh0nbPv-YyVjhsZGgGmdWWXELA9yl-ZXCesU/pub
You can ...
- 141
0
votes
1
answer
104
views
Add a new row and move data to that row when box is checked
I currently have a Google spreadsheet that keeps track of all orders and the progress:
Column 1: Order Form Sent
Column 2: Order Form Received
Column 3: Delivered to Pick Up Site
Column 4: Picked Up
...
- 1
-1
votes
1
answer
66
views
how to select and automate "copy by value" to persist data in Google Sheet
I would like to use Google Sheets as a form to query for data, select and store the data I'm interested in.
Below what I'd like to try. Please let me know if feasible, and if so, could you tell how to?...
- 99
2
votes
3
answers
2k
views
Google Spreadsheet Script Trigger: This app is blocked
I am trying to create a trigger for a script in google spreadsheet and upon trying to save the trigger I am getting the following error:
This app is blocked This app tried to access sensitive info in ...
- 194
0
votes
0
answers
10
views
Adding none-printing text in Google Docs?
I have a Google Docs document and am keen to add a line of text (perhaps in the header or footer) just to serve as a reminder for myself... but I don't want it to be visible when printing or exporting ...
user54099
0
votes
0
answers
66
views
Using a list of ID's and a List of conditions COPY and Paste
I have a spreadsheet a list of 15 spreadsheet that I have to update weekly with fresh data.
At present I do this manually however having a script will make the task so much easier.
What I have is a ...
1
vote
0
answers
12
views
What happens to my laptop after adding Google Play?
According to this Google link, one can add Google Play to his/her desktop/laptop. Could someone tell me what happens after adding? I checked my laptop and didn't notice anything different.
- 111
1
vote
1
answer
434
views
How can I import a .docx file in Google Docs?
I have uploaded a file in Google Drive which I would like to open in Google Docs.
Using the web interface of Google Drive, I right clicked on the file and then selected "Open With".
But ...
- 111
1
vote
1
answer
203
views
Why do Blogs created on Blogger show as 'Not Secure' even when Blogger is a Google Service?
I recently created a blog on Blogger and even though it is a service offered by Google, Google Chrome shows the Blog as 'Not Secure'. What is the reason? How do I make sure that people are not afraid ...
0
votes
1
answer
40
views
Is any way to generate from word April 1/4/2020 - 30/4/2020?
I have a data validation cell (F4) with the 12 months, and I have this sumifs to search for certain dates, how can I change the dates based on the cells (F4)value?
=sumifs('sheet01'!C3:C;
'...
1
vote
0
answers
310
views
How to make a call via Google Remote Desktop
I am using Google Remote Desktop to access my company laptop which has a software installed for making phone calls. Now, I would like to use that software from my pc at home to make a call.
I can hear ...
2
votes
2
answers
3k
views
copy a google form retaining responses and summary charts
I have wrongly submitted a google form to two different groups of people.
So I have created a copy of the form after generating the spreadsheet.
However, in the responses tab of the copied form, I get ...
- 1,467
1
vote
1
answer
1k
views
Google Sheets Insert Cell Values into another Cell using formula
So, I am looking to insert two cell values into one cell, one following the other.
For the following example see the Image below.
I want to put a Formula in C such that the formula would result in ab
...
- 11
1
vote
0
answers
232
views
How to make median appear in a box plot chart in Google Sheet?
I want to know how can I make the median line appear in the box plot chart?
- 111
-1
votes
1
answer
1k
views
How to select multiple individual cells on Google Sheets on my Android mobile phone?
How to select multiple individual cells on Google Sheets on my Android mobile phone?
Example:
On Windows it is possible by using the CTRL button + left mouse button click, but I did not find any ...
- 215
-3
votes
1
answer
28
views
How do you get the administrator effect off your computer so nothing is bloced on your computer
Is there anyway to remove the administrator or like overpower it
I have look everywhere but it seems like there is no possible way
- 1
0
votes
1
answer
67
views
Google Sheets interpret numbers with one decimal point as date
With locale set to Brazil (number format is 24.999,75 and date is 20/5/2017) typing a number with a point separator (.) results in different interpretations depending on the number digits after the ...
3
votes
1
answer
4k
views
What is the duration of a Google Meet URL? (personal account)
I have a personal Google account. I can create Google Meet rooms easily by clicking on the "Start a meeting" button:
The URLs created by clicking that button are like https://meet.google....
- 365
0
votes
1
answer
30
views
Google Form Specific Automatic Response
I am aware that I can add a little code to a Google Form's spreadsheet to have it auto respond to a submission. I am curious if there's a way to have a person submit the form and then have it auto ...
- 101
1
vote
1
answer
59
views
Is there a formula to automatically populate invoice with only the products that have been ordered and excludes the products not ordered?
I have a range of products in my order data sheet and I need help creating a formula that automatically fills up my Invoice sheet with only the products that were ordered.
Currently I can only ...
- 11
4
votes
1
answer
658
views
How to remove or customize Gmail's "Quick Settings" menu?
In May 2020, Google announced a change to Gmail's settings menu: a new Quick Settings menu carrying some frequently used options was added.
The announcement and full description are at https://...
1
vote
0
answers
115
views
How to keep same protections/settings when making a copy of a Google Spreadsheet? [duplicate]
I have a spreadsheet that I want to create about 100 copies of at once, all copies with different titles. I found a script that allows me to do that, all I have to do is fill out information from cell ...
- 35
0
votes
4
answers
22k
views
Why are my 2 separate Gmail accounts receiving the same emails?
If someone sending a mail to account A. Why am I receiving the same email in account B. I checked in 'setting->forward' but there is no relation between two accounts.it happening for each and every ...
- 17
0
votes
1
answer
2k
views
FedEx Tracking in Google Sheets
I work for a company that sends packages out daily. We track the numbers in a Google sheet that populates via a Google form we use.
Recently we have had some packages go missing and I have been tasked ...
0
votes
1
answer
222
views
Is there a way to verify a username.github.io subdomain (not custom domain) with Google developer console?
I've been trying to register a hobby app project at Google Developer Console. While registering the OAuth consent screen, I'm told that I must supply a domain verified with Google:
Now, since this is ...
- 133
1
vote
1
answer
57
views
Irritation caused by Google-docs autosave notification blinking
How can I disable auto-save notification (document status at the top of the screen) ? It always distracts me during typing even irritated by flickering . If you start to pay attention to that, the ...
- 13
0
votes
2
answers
427
views
Is there any way to limit editing in Google Docs?
I'm looking for any way to set the character limit in Google Docs (specifically MS Word-like text processor).
So, for example, I have a cell in the table and I want to only allow putting 2000 ...
- 11
1
vote
0
answers
53
views
How do I get rid of this weird search suggestion in the Gmail app?
I was searching the term gift card in the Gmail app, and it suggests this "sexualgoddess@clean-veri.com" for some reason. It must be in my Google history somewhere but I can't find it. ...
- 11
0
votes
1
answer
81
views
Collate Data in Google Sheets
I am trying to collate date in Google Sheets. I have multiple tabs and want to consolidate them into one tab where each row is from a different tab. If that doesn't make sense, here is my test ...
0
votes
1
answer
23
views
How to sort mutliple columns by data in one?
I have two columns A and B, A has checkboxes that when set to TRUE it fills the adjacent cell in B green and strikes the text through. I want to create a filter that sorts columns A and B by the data ...
0
votes
1
answer
23
views
Linking an Add-On to a Drawing
This must be an odd question...I've searched but haven't seen anyone else ask. It probably seems a little unnecessary, but I'm trying to assign an Add-On (not a script) to a drawing/button that would ...
- 114
2
votes
2
answers
3k
views
Disable daily notifications from Google Calendar App in Slack?
How do I prevent the Google Calendar App from sending me a daily notification about my events for the day? There is no setting provided to do this. My choices seem to be either not to have any Google ...
- 550