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.
1
vote
1answer
25 views
Can you specify an accout to use with Google's “.new” doc creation URL?
I am usually logged in to multiple Google accounts, and I have been using links like these to create sheets (docs, etc.) in the respective accounts:
https://docs.google.com/spreadsheets**/u/0**/...
1
vote
1answer
30 views
Redirect link to another Google drive video
Is there a way to redirect a link to another video in Google Drive when both are made shareable?
I ask this because I have shared someone a link to an older video and I want them to access the new ...
0
votes
1answer
59 views
Adding extra but non-aliased emails within GSuite
Have setup GSuite to handle emails for a certain domain name and have also added aliases via: Google Admin -> Users -> {User} -> User Information -> Email Aliases
However, what if I want to add an ...
0
votes
0answers
24 views
How to migrate and convert an individual Google Suite email account to Office 365 Shared Mailbox?
I'm planning to migrate my company GSuite email account to Office 365. The Office 365 will have the same domain.
My Office 365 subscription is the Business Premium, so we will have shared mailbox for ...
0
votes
0answers
17 views
G-Suite group, always use group address in replies
I want to use a g-suite group for a support address. The group will include a number of people in the company, who are authorised to respond to support requests.
I would like to set it up so replies ...
1
vote
0answers
100 views
Google sheets, data validation - how to auto-update the options from a “list in a range”
I have a dropdown in all the cells in a column. Around 150 rows. The four options inside the dropdown come from another tab (sheet), A1 to A4.
This works fine. The options are listed from that tab, ...
0
votes
0answers
5 views
G Suite Calendar Default Working Hours
As a G Suite Administrator, is it possible for me use the G Suite Administration app to set default "working hours" for all users' calendars?
0
votes
0answers
16 views
Link to Create Google Doc using Google Template and Passing Parameters
I have read thread showing how to create a new Google Doc using a link.
https://docs.google.com/a/your.domain.com/document/create
I also saw that you can pass title parameter to name the document. ...
0
votes
0answers
22 views
Script to duplicate rows but continue formulas
I feel like my script is close to the goal, yet so far.
I'd like to take the current row that the user is clicked on, and then insert multiple new rows below the current row, but also continue the ...
0
votes
1answer
793 views
How do I get Gmail to wrap my paragraph text in the default HTML mode?
I've been noticing of late that when I write paragraphs that end up needing word-wrapping as Gmail will make these lines extremely long and cause horizontal scroll bars and hence make having to read ...
0
votes
0answers
49 views
Google App to add a specific forwarding address to a user's Gmail
I wish to create a Google App that will, upon approval by the user, automatically add a specific forwarding address to their Gmail.
When trying to hit the https://www.googleapis.com/gmail/v1/users/...
0
votes
1answer
68 views
Automatically switch to another Google account during work hours?
I have two Google accounts:
personal@gmail.com
business@company.com
Is it possible to automatically change between during working hours?
Example:
Monday to Friday
08:00 - 17:00 -> business@...
0
votes
2answers
19 views
Some saved places are not shown on map
I have saved Dune of Pilat to my custom list:
If I zoom out I see my other bookmark from the same list, but there is no Dune of Pilat mark on map.
Why some bookmarks are visible and some not from ...
0
votes
1answer
18 views
Grab route from other site
Is it possible somehow grab route from others maps and use in my personal map?
For example how to grab map from this ultimatedrives site?
0
votes
0answers
54 views
Google App Script - Append Table to Google Doc
I am having an issue appending a table from a google sheet into a google doc via app script.
if(rtemp == "tblhead")
{
//http://www.googleappsscript.org/home/create-table-in-google-...
0
votes
0answers
102 views
Multi-part data validation and calling formatting in google sheets
I have a couple of questions:
Is it possible to make a conditional formatting or data validation rule such that multiple data types can be input into a cell and the cell will automatically separate ...
0
votes
0answers
149 views
Changing non-primary verified google apps domain in legacy account
We have a 2007 google apps account, where we have multiple verified additional domains on this account, Verified and not Aliases.
One of these web sites is going to be renamed, is there any way i can ...
0
votes
1answer
133 views
Using Google Apps Script add-on without publishing
I've just written my first Apps Script add-on for showing some links in a sidebar of a Docs document.
It looks like the way I created it made it bound to a specific document (the one from which I ...
2
votes
3answers
42 views
Copying data from one cell in another based on date
I have a spreadsheet, using google sheets, that I have formed into the follow metrics:
Column A is the dates of the month
Column B is the data
I want to be able to copy the data from Column B into ...
0
votes
0answers
18 views
How do you filter AdSense ads via Doubleclick for Publishers? (DFP)
I have an AdSense account and a Google DFP account. On my AdSense account I have a screen for filtering out categories of ads that looks like this:
Since DFP ad units have "AdSense inventory settings"...
0
votes
0answers
1k views
YouTube “not interested” button is missing. How can this be resolved, and bring back that button?
Whenever I search for something the "not interested" button is not there to mark a video I don't want to see.
It only appears on homepage videos, but on search videos and the videos under playing ...
0
votes
1answer
36 views
Locating third-party Google Docs web apps
I got an e-mail from Google today, warning me to "Remove risky access to your data". According to the security checkup, there are two third-party apps which "have extensive access to [my] personal ...
0
votes
0answers
240 views
G Suite with domain alias causes emails to be considered spam
A legacy G Suite associated to a dead domain has had a new working domain added as an alias. Although Google sets the From as the new domain, how can I stop Google setting the Envelope-from as the old ...
0
votes
1answer
167 views
Google Sheets - Fetch random value from array for each new line created with form
I have a Google Form that fills up a new line with values in Sheet1!, column A and column B.
I am trying to create an =ARRAYFORMULA function in column C, which will populate the C cell in each new ...
-1
votes
1answer
20 views
Can I move only a few accounts to google apps paid plan?
Is it possible to move a few free google accounts using a custom email (eg non gmail) to a paid google app plan whilst leaving all other accounts and emails as they are.
Here’s my scenario
I’ve ...
2
votes
1answer
183 views
Is the new Gmail interface available for all domain accounts?
My domain is on Google since ~2006, the name changed a few times (Google Apps initially, now I think this is G Suite) and I benefit from the free grandfathering program.
I wanted to try the new 2018 ...
2
votes
1answer
749 views
Users can't access Gmail Accounts in G-Suite [closed]
I am the Admin for the G-Suite Account. I am seeing the following in my admin (see below), but new users are getting "We are sorry, but you do not have access to Email. Please contact your domain ...
1
vote
1answer
292 views
Reference entire row data or row-by-value from other sheets
I've a Google Spreadsheet where my first sheet is a Products table.
The columns are SKU, Title, Price, Category, Type
I've some tasks in front of me where I need to create some bundles of different ...
0
votes
0answers
27 views
Google spreadsheet: Getting same result for both cells when dividing
I'm trying to divide two cells values in Google Spreadsheet, but it's weird because both cells are getting the same value.
The values to be are different and they are:
Session duration
=TEXT(P2/...
0
votes
1answer
16 views
Google spreadsheet data not showing properly in graphic
I'm using =CONCATENATE('90diaspessoas'!B16," ", TO_TEXT('90diaspessoas'!A16)) to join two cells data into one, then display the data on a graphic.
The following picture shows the result that I'm ...
-1
votes
1answer
33 views
Join two cells data - COCATENATE not working properly
I'm using the following formula to get the data of two cells:
=CONCATENATE(C2,"Dia",E2)
But it's not working properly. Take a look at the screenshots:
It should be returning the Traffic + Date, but ...
0
votes
0answers
15 views
Google and personal suggestions with shared IP
As I know, Google collects information about search requests, what YouTube videos are viewed, etc. to suggest the new content or reorder search results according to my interests. The question is: how ...
-3
votes
1answer
33 views
send mail from google sheet with given range content in simple html format to single email id— kindly help me
.
I have developed the sheet with some condition the email should be lite then only it will deliver to me in short period based on the technical details will take desition on my trade. I have ...
2
votes
1answer
57 views
Use non-linear color scale for conditional formatting in Google Sheets
In Google Sheets, when you use conditional formatting on a column with numeric values, is there a way to place a colored scale that is non-linear, but exponential, for example? I know you could ...
1
vote
1answer
345 views
How can I set up a “public” or a “team” folder in Google Drive (G suite)?
I'd like to have 2 types of folders:
A Public Folder, everyone in the company can see in their "Shared with me" section and edit
Few Team-specific folders, everyone in the team can see and edit (a
...
0
votes
0answers
29 views
Is it possible to set a formula in google spreadsheet with two variables?
I want to set a formula to calculate an equation like Y=X+5 where Y is an calculated constant value generated by another formula depending on X. is there any solution.
0
votes
0answers
306 views
Setting up a conditional auto responder from a gmail / google apps for business account ?
Is it possible to send a conditional auto responder from a gmail / google apps for business account ?
What i mean by a conditional auto responder is if someone email an email alias (email alias is a ...
0
votes
0answers
74 views
Unable to collect email address
The script is unable to extract emails get body /get plain body. Can any one guide?
function getEmails() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var labels = GmailApp.getUserLabels(), ...
4
votes
1answer
117 views
Odd Google Apps Script behavior
I have a Google Apps Script project that I have used for the past few months (successfully) and everything has worked just fine. A few weeks ago, I started getting the "Unable to load files" error ...
0
votes
1answer
645 views
Google drive keyboard shortcuts not working with non-US keyboard
Some important keyboard shortcuts in Google Drive and Google Docs seem not to work on a non-US keyboard, at least on Macs.
For example, I have a French keyboard and in Google Drive, hitting "/" opens ...
4
votes
2answers
1k views
Why is my G Suite Gmail favicon blue?
My G Suite Gmail favicon has turned blue. Now it looks like this:
What the color change mean? Is is part of a rebranding, or is it supposed to notify users about some special state of Gmail app?
Is ...
4
votes
1answer
6k views
How do I end the “ongoing call” in Google Hangouts?
I correspond with a person on a daily basis via Google Hangouts. I needed to do a screen share so I called the user for the first time and screen shared. This was great. Then I ended the call and ...
2
votes
2answers
2k views
Why does admin.google.com redirect to my university's Google Apps?
I work at a university. All students get a third party Gmail and Google Apps account but staff do not. Now I can't administer my domains that are expiring. Every time I try to go to admin.google.com ...
0
votes
0answers
19 views
Show last calculated value
I am trying to find a way to make a cell, reflect the last calculated value of a row that will permanently change.
Target cell: C5
Targeted data: D:D;
D:D is going to change according to values posted ...
2
votes
0answers
41 views
How can I share my organization Google doc “anyone with link”?
I've created documents using my business g-docs (I'm a freelancer). When I try to set the document "anyone with the link can view|comment|edit" I am only given options "anyone IN YOUR ORGANIZATION ...
1
vote
0answers
186 views
How would I set up and manage someone else G-suite without a password?
Instead of running my own (low-quality) mail server, I advice my customers to use G-Suite instead and let me do the set up. For this service I charge them. However, every now and then an edit has to ...
-1
votes
1answer
258 views
Copying JS array into Google Spreasheet introduces NOT_FOUND cells
I want to create a historic sheet in Google Spreadsheets, where I take the stock data from one sheet and I fill the historic sheet using a specific date in the script.
This is how my sheet looks like:...
1
vote
1answer
42 views
How can I insert formatted links in Google Sheet concatenations?
I am using Google Sheets to run mail merges using the script editor; it references a cell with an email address and a cell with the body of the email. I am able to concatenate a number of other ...
3
votes
1answer
2k views
How to unzip zip file on Google Drive?
I have a zip file of about 5GB on my Desktop. I am using Mac 10.12.6. I was able to upload this zip file to Google Drive and I could see it there but I could not unzip this file on Google Drive to see ...
2
votes
1answer
293 views
Google Apps account for domain suspending
I received an email from Google:
It looks like you haven’t used your Google Apps account for the domain
windyspot.com in the past 365 days. Google will suspend your account
on or after Dec 2, ...
