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.
855
questions
0
votes
0answers
18 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 ...
0
votes
0answers
6 views
How can I easily search across content in all my Google products? [closed]
I'd like to have a single search box that searches the web, Google Drive, Google Keep, Gmail, Calendar, etc. I know it's possible to search each one manually, but that's tedious if I can't remember ...
0
votes
0answers
8 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 ...
0
votes
0answers
13 views
GSheets : How to find all GOOGLETRANSLATE formulas executed or not from external means? [closed]
I am developing a data processing app using Google Sheets and its API as backend .
In that I will upload all datas as arrays with GOOGLETRANSLATE via batchUpdate API like below
[hello_word,"Hello ...
1
vote
0answers
33 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 ...
0
votes
0answers
5 views
Multiple Local Accounts w/ GoogleDrive.app (local app) [migrated]
I am setting up a single Win10 computer that I want multiple staff (eg. 4) to have local access to, each with their own local user account.
Our organization uses Google Apps (whatever the Enterprise ...
1
vote
0answers
134 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 ...
0
votes
0answers
27 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 ...
0
votes
0answers
12 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
0answers
40 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
1answer
117 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 "+" ...
0
votes
0answers
24 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 ...
0
votes
1answer
23 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 ...
2
votes
0answers
69 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 ...
0
votes
0answers
12 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 ...
0
votes
0answers
23 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.
...
1
vote
1answer
471 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 ...
0
votes
1answer
65 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
votes
1answer
58 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?...
0
votes
0answers
28 views
How to re-enable Google Workspace email delivery
We have an old Google Workspace account (formerly G Suite) that is grandfathered with free email. I tried to add email forwarding in Google Domains and I clicked on "Disable Google Workspace and ...
0
votes
0answers
28 views
Trying to Automate invoicing using Google Forms and Sheets
I am trying to problem solve a Google spreadsheet that I use for invoices.
Currently the set up is as such. I have 4 sheets in the spreadsheet. The first sheet is linked to my google form gets its ...
0
votes
0answers
21 views
Auto-generate unique sheets when you add a new row in Google Sheets?
I'm a fairly new user to Google Sheets, I'm trying to set up a sheet whereby when you add a new line in one sheet, it creates a separate check-list sheet. So when a new user is added to the master ...
2
votes
3answers
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 ...
0
votes
0answers
9 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 ...
0
votes
0answers
61 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
0answers
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.
1
vote
1answer
284 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 ...
1
vote
1answer
126 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
1answer
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
0answers
209 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
2answers
2k 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
vote
1answer
723 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
...
1
vote
0answers
143 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?
-2
votes
1answer
818 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 ...
-3
votes
1answer
21 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
0
votes
1answer
57 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
1answer
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....
0
votes
1answer
28 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 ...
1
vote
1answer
46 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 ...
4
votes
1answer
587 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
0answers
97 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 ...
0
votes
4answers
19k 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 ...
0
votes
1answer
1k 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
1answer
153 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 ...
1
vote
1answer
46 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 ...
0
votes
2answers
335 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 ...
1
vote
0answers
46 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. ...
0
votes
1answer
71 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
1answer
21 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
1answer
21 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 ...