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.
854
questions
0
votes
0answers
16 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
21 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
21 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
31 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?...
1
vote
1answer
51 views
Finding the longest time duration in Google Sheets
I'm trying to find the longest time value (hh:mm:ss) and I'm looking for it in column I, starting at row 5. I've already tried using the LARGE function but that outputs a decimal, not a time.
=LARGE(...
0
votes
0answers
21 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
20 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
19 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
1answer
478 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
51 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
75 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
29 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
45 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 ...
0
votes
0answers
14 views
Is there a “Basic HTML” view of Google Contacts? I'm seeking a view that loads quickly on a mobile phone's browser
I'm seeking a fast-loading view of the Google Contacts website to use in my mobile phone's browser. I'm interested in this because the website exposes some fields that the phone app does not. (For ...
0
votes
0answers
18 views
Can my app add users to G Suite accounts (belonging to different schools) on the school's behalf without Client ID and Client Secret?
My company is working on an e-learning website where schools can register and take online classes using Google Meet.
We require the following flow :
When a school registers themselves to our app, the ...
1
vote
2answers
781 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
242 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
...
0
votes
0answers
44 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
173 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
20 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
33 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
3k 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
0answers
614 views
My college manages my G-suite account, can they view my browsing history if I use a personal device on a home network while logged in?
I have found multiple sources telling me otherwise, but most are outdated by a year or two. If I am logged into my G-suite managed account on Google, and search something up on a home network and ...
0
votes
0answers
5 views
How to know IP's connected to storage in Google Cloud Services
Is there any way to know the IP's that have downloaded (or make any connection) to a public file stored in Google Cloud Services ?
0
votes
0answers
51 views
How to shared a video in Full Screen on GoogleMeet stream, without showing my picture on the side
I am part of the Helpdesk of a big corporation, and we are having a big meeting tomorrow, and as part of it, we will share a video through Google Meet stream.
Soon I realized it is not that simple, ...
0
votes
1answer
24 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
35 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 ...
3
votes
1answer
393 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
62 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 ...
-1
votes
2answers
9k 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
0answers
30 views
How to move Gmail's Navigation Menu (Inbox, Sent, etc.) to the right of the email messages?
Description
Recently, I changed my Google products language from Hebrew to English. This caused the Gmail navigation menu (the one with Inbox, Sent, Trash, etc. options) to be posed to the left of the ...
0
votes
1answer
882 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
77 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
36 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
0answers
98 views
How to authorize google “find my device” to turn ON the GPS + Data remotely?
I would like to use Google "find my device", but it only works with the location and a connection to the internet.
Xiaomi's "find my device", can turn ON the location but only it's ...
0
votes
2answers
146 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
39 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
48 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
0answers
18 views
Can't get chart to display weeks from specified day
I can't for the life of me get my chart to display every Monday (starting from 13/07, instead it displays every Sunday (starting with 12/07).The chart also starts with 6 data points (minor lines) and ...
0
votes
1answer
19 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
15 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 ...
0
votes
0answers
61 views
Get Google Meets to show my phone number as me
How can I get Google Meet to show my phone number as me? If I call in with a mobile number I just show up as an obfuscated number. I can set my phone number on my google profile, but it doesn't seem ...
0
votes
0answers
100 views
How to restore the comments on your deleted slides on Google slides
Someone made some comments on some of my google slides but those slides were deleted by some other folks. When I try to restore version history I can only get the slides not the comments, is it ...
0
votes
0answers
16 views
If I invite an existing Google user with non-Google e-mail to G Suite will their e-mail now be part of their account?
I plan to add (by inviting) some users with @my_company.com e-mail addresses to a G Suite account I'm setting up for my_company.com. The e-mail addresses for those users currently are (a) already ...
1
vote
2answers
1k 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 ...
0
votes
0answers
19 views
Use arbitrary fonts with Google apps
Is it possible to use an arbitrary font with Google Slides or other Google apps? I'm running macOS and would like to be able to use fonts I have installed for Chinese and Native American languages – ...
0
votes
0answers
1k views
What's causing this error when running Google sheets script?
Exception: The parameters (String,String,String,(class)) don't match the method signature for CalendarApp.Calendar.createEvent. (line 31, file "Copy of Code")
29 if (eventID != complete){
30 ...
