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.
-2
votes
0answers
38 views
Searching a Google-Apps-using organization's directory [closed]
If you're using Google Mail with an account which is part of an organization using Google Apps, typing an address fragment searches that organization's directory.
Is it possible to do the same, ...
0
votes
0answers
13 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
19 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
166 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
41 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
64 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
16 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
16 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
1answer
14 views
Only stared places are visible during route planning
I'm using several types of bookmarks - Stared places and custom made from New list holidays 2018
But why during route planning I see Stared places and there is no holidays 2018?
0
votes
0answers
21 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
32 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
61 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
45 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
32 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
16 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
694 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
185 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
81 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
18 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
159 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
435 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 ...
0
votes
0answers
14 views
Send automated email to all user of sheet from google sheet if particluar cell values matches with given no
How to send mail if any specific cell value changes = 100?
The cell values is some of other cells.
1
2
3
4
if A5=10 then send email
1
vote
0answers
246 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
32 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
14 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
29 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
26 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
231 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
26 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
241 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
73 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
100 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
397 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 ...
3
votes
0answers
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 ...
1
vote
2answers
803 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
37 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
162 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
215 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
41 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
0answers
1k 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
265 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, ...
-1
votes
1answer
26 views
Is there a currently scheduled or announced release date for the Team Drives feature on the G Suite Basic plan? [closed]
G Suite Team Drives is currently available for:
G Suite Enterprise
G Suite Business
G Suite for Education editions
My domain is on the cheaper G Suite Basic plan.
You can tell if you are on G Suite ...
1
vote
0answers
583 views
How to duplicate a graph in Google Docs and use a separate source/link of data
When I copy and paste a graph in Google Docs, it makes 2 graphs, linked to the same spreadsheet. I'm looking to make 100 identically-styled graphs and quickly modify each one by editing the data in ...
0
votes
0answers
39 views
Google Apps LDAP for my stand-alone email client?
I use Mozilla Thunderbird for email, and connect via IMAP to Google's mail servers using my account at some company. Now, the company has a general Google Apps/Google Suite account, with a domain, and ...
0
votes
0answers
176 views
G-Suite Groups - some emails from external users being sent from group address
I have set up a Team (Internet) type group from the free edition of G-Suite.
Some of the emails that are being sent to the group are arriving in my inbox with a from address as the group (rather than ...
