Google Apps

Google Apps is a suite of cloud computing productivity and collaboration software tools and software. It includes Google’s popular web applications including Gmail, Drive, Hangouts, Calendar, and Docs. While these products are available to consumers free of charge, Google Apps for Work adds business-specific features such as custom email addresses at your domain and storage for documents and email.

I created a png file and saved to my google drive - from a work email. I want to use the image as part of my google signiture in my settings. When I try to publish it I get the following attached file. I am not sure how to make this public and attach it to my google signiture??? I made it public in another google drive account my own not the companies and I paste the url but no image shows up???
0
Hi Experts


Could you point which Google tool is needed to obtain the result accordingly with the image bellow?

I understand that there must be a payment for the image to look like this, however I did not identify the characteristic "Add" icons (f.e.)

To reach the advertisement, the type of service and the name of the street was informed as shown in the image.

img001
Thanks in advance!
0
New to using google drive. I have google sheets sent to me via gmail with a share option. I choose share and can see and open them under shared with me. My question is do I need to download these files into my google drive as I will be using them? Or if I choose to share from the email link will they automatically be in my google drive? Not sure the process and Thanks. I can see them under the shared with me.
0
I am new to using google sheets. I have used them on a basic level in the past to organize family trips, etc. I am working with a company that is using google sheets to cleanse data. I have always used ms excel. Is sheets as robust for this - can you use power query? Would you recommend taking the data from sheets and saving to excel then use excel to cleanse?
Also I have always exported ms excel into mysql after cleansing. Would I do the same with google sheets?
Thanks in advance.
0
Note: I am working with Google Sheets but this is almost certainly a universal formula question, so an expert in Excel will likely know how to solve this problem. Thanks.

---

I am trying to search a list of names (from another sheet) against a static list of names, and when the name is found, indicate if it's next column has a "yes" recorded.

I set up an example working sheet (tab: Agreement Check):
https://docs.google.com/spreadsheets/d/130fX-RhlHWxHHQpaKAGzrd7LPVFTM6gEdJqPQ4msTqY/edit#gid=841914493

Agreement Check tab:
Column A is a manually entered list.
Column B is temporary and not part of my end requirement but it includes a formula that checks for the existence of the column A name in tab: Cert Data
Column C should indicate Yes or nothing, as pulled from Column B (Agreement Data tab).

Agreement Data tab:
Column A-B is data pulled from a remote sheet.
Column D needs to indicated in Column C (Agreement Check tab)
Column C filters email addresses in Column A to a full name that is used to match against data in the Agreement Check tab.

My description might be overly complicated. Apologies.

The bold Column C (in Agreement Check tab) is where I am having difficulties in creating a working formula. :(

In this column for example...
Betty Lee should have a "yes" in Column C
Bobby Robinson should have nothing in Column C
and so on...

I think I'm 1/2 way to a solution because I know how…
0
Hello all,

I am looking for a way add a (dotted line) projected value into a Google Sheet chart. I am plotting two sets of numbers on a graph, but the final averages for January are incomplete, and therefore show a misleading result. The averages in columns B and C are pulled from collected data in columns P ->.

The projected value could be either calculated automatically, and based on the total number of reported values in time elapsed. Meaning that the value will continue to go up. The value equals the number of days past, up to a maximum of 50.

If automating the projection is too complicated, I will also accept inputting manual value. I can work out my own projection analysis later. Right now, I am more interested in knowing how to create a chart like my mockup; see sheet.

In the example: https://docs.google.com/spreadsheets/d/1Q2nN-MVD_iwJi2Se-PFWcNbMGb-EF6gQWQCruhnWW-Q/edit#gid=180731546
See chart experiment tab.
0
We have about 200 users in a Microsoft environment.  We would like to consider using Google G Suite as an alternative to Microsoft.

I would appreciate links to great documentation on the pros and cons, and what it would look like to begin that migration.

I found this link but I'm sure that there is a ton of great information available - which articles and white papers etc. have you found to be "the best"?

https://googleblog.blogspot.com/2009/12/tips-and-tricks-for-deploying-google.html

Thanks
0
I have a customer who has locked himself out of his gsuite account.  He created an admin and then deleted his personal account. He does not remember the admin account or password he created.  Literally, we cannot access the gsuite account.

Google's support is notroriously horrible, so I'm actually posting here.  We do have access to the DNS for the domain and we can add CNAME/TXT record etc to prove ownership.

Does anyone have any experience with recovery using this method?

Thanks
0
I am using the IMPORTRANGE function to pull in three columns from another sheet. The columns are:

Name, Option 1, Option 2

But I need a way to filter out any names that include N/A in both columns. In other words, filter out content when two conditions are met.

I prefer a formula based solution, rather then using Conditional filtering. The solution can use hidden columns if needed. Failing that conditional formatting is acceptable.

Your assistance is appreciated. :)

Here is the working sheet:
https://docs.google.com/spreadsheets/d/130fX-RhlHWxHHQpaKAGzrd7LPVFTM6gEdJqPQ4msTqY/edit#gid=0


Thank you.
0
I was sent a gmail with an employment acceptance letter. The option is to open and fill out with google docs. I opened the doc in my google drive, edited, and saved the document on my google drive as google doc. If I go to share on the document and enter his email address will it only share that document??? or all my documents on my drive??? Is there a particular setting I should use to make sure only that document is being shared? Should I use a different process to send??? Suggestions??? Thanks
0
I have another Excel puzzle that I am trying to solve.

I am trying to convert a name column into an email list. It sound simple enough, but there is a small twist, that is, some names included preferred first names in brackets, and some names have three names. :P

Note: The names the example spreadsheet are a good representation of the list I will use IRL:
- Only first and last name, if a Western name.
- May include a preferred name in brackets, if the name is non-English - the first name in brackets will be used with the last name.
- Some names have three components.

Examples:
Column A               ->  Desired name conversion

Bobby Robinson            -> bobby.robinson@company.com      - solution found
Lin Hon (Adam) Xiao      -> adam.xiao@company.com               - solution found
Lang Lin Lee  -> langlin.lee@company.com                                  - need a fix.

So the last scenario still needs to be resolved.

The current formula (thanks to Ryan Chong), doesn't take into account a name with three parts.
For example, a name like "Lang Lin Li", converts to lang.lin.li@company.com but should be langlin.li@company.com

I was thinking that I could parse the new solved names column with a =SUBSTITUTE(G9,".","",1), but it would also have to take into account to only remove the first instance of a ".", but only when there is more than 1 "."

Is it possible to add additional complexity to the existing formula?

Current formula:
0
I have another excel puzzle that I am trying to solve.

I am trying to convert a name column into an email list. It sound simple enough, but there is a small twist, that is, some names included preferred first names in brackets. :P
This means that the preferred first names must be used.

Note: The names are strictly using the the examples in the spreadsheet, there are no other variations:
- Only first and last name, if a Western name.
- May include a preferred name in brackets, if the name is non-English.

Examples:
Column A               ->  Desired name conversion

Bobby Robinson            -> bobby.robinson@company.com      
Lin Hon (Adam) Xiao      -> adam.xiao@company.com

In the example spreadsheet (tab = email addresses), I was able to each scenario separately, but not as a single unified formula.
https://docs.google.com/spreadsheets/d/1Q2nN-MVD_iwJi2Se-PFWcNbMGb-EF6gQWQCruhnWW-Q/edit#gid=833560184

Can anyone with better skills than me, help me with a solution?

Thank you
0
I am setting up a Google Forms questionnaire to collect menu choices for a group evening meal. We are expecting 100 to 120 guests so menu choices have to be pre-selected.

I currently have it setup that you have to submit a separate form for each person attending the meal and am using a party organiser name to group the results together.

As it will be mostly families that are completing the form it would be great if one person could complete the form with a list of names and then each individual's menu choices. I would expect each family group to be less than 10 but wouldn't want to apply a restriction just in case.

There would be some basic questions, party organiser name, email etc and then would be great if it could flow as:
Guest 1, add menu choices
Add another Guest or Submit
Guest 2, add menu choices
Add another Guest or submit
etc etc

I have looked at the various templates and I notice in Google forms there are various Add-Ons that can be enabled but haven't found one that does this. Does anyone know of one that does?

Current setup generates a spreadsheet with a list of the choices which I can easily summarise for submitting to the venue.

I could set it up with pre-determined number of guests but I don't believe that would generate the summary sheet like I currently have and I have to make a decision on how many guests per submission, too few and the person completing still has to complete multiple submissions, too many and the person completing …
0
Cannot access my google groups.  Keep getting error  - The page you requested is invalid.
The returning URL is - https://accounts.google.com/ServiceNotAllowed?service=groupsinsidedomain&continue=https://groups.google.com/a/mydomain.org/d/

I found several instances of this error on Google all say that Groups is turned off and points you to this KB article,  https://support.google.com/a/answer/167096?hl=en  
However, it is already turned on
There should be some log, that I can access that tells me what is specifically what is wrong but I cannot find it.

Need some help with this
Thanks
0
Let me give you a scenario and please explain to me whats happening?  On google drive I have 4 folders called Clients, Forms, Apps and Checks.  They all show up on my google drive just fine and I'm sharing it with others.   Somehow it seems the Clients folder is also located in the Forms folder and its certainly the same one.  How is it that its showing up as a main folder in My Drive but at the same time located in the Forms folder?  Is this a sharing or permissions issue or is it marked as a favorite folder somehow?  How do I fix this issue.
0
hi experts,
trying to perform a proof of concept by clicking an IoT Device button invoking webhook or restapi. eg invoking a Jenkins build.


could you suggest some devices please? aws IoT is not available on my region.

looking for Samsung Smart Things hub. would this work? but expensive though :)
0
I have a macro that will open up google translate and return the English translation of a designated Spanish text. I can then copy the translation, activate my Excel workbook and paste it into a designated cell. What I'd like to be able to do is have additional code in the macro that will do that as well.

Here is my code. I've also attached the workbook.
Sub TranslateText()
Application.ScreenUpdating = False
Dim cel As Range, TxT As String
Set cel = [E2]
TxT = Replace(cel.Value, " ", "%20")
   [J2].Hyperlinks.Add Anchor:=[J2], Address:= _
       "https://translate.google.com/", SubAddress:="es/en/" & TxT, _
        TextToDisplay:="https://translate.google.com/#es/en/" & TxT
   '[J2].Font.ColorIndex = 2
   [J2].Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
   'Here I need code that will copy the English translation
ThisWorkbook.Activate
   'and then append it to a designated cel
'[E4].Select
'ActiveSheet.Paste
[E6].Select
Application.ScreenUpdating = True
End Sub

Open in new window

TranslatorMacro.xlsm
The link to google translate is in cell J2. The macro populates J2 with the phrase to be translated: "https://translate.google.com/#es/en/40C,%2015A%20IFE%20no%20permite%20sellecionar%20peliculas.%20Se%20congela%20y%20luego%20vuelve%20a%20menu%20inicial.%20Reset%20y%20no%20funciona"

Thanks,
John
0
Hi Techs.  I am in a new role and am using Google Sheets.  I needed to make a template for my daily report. So I made a copy of the the sheet with its' tabs, deleted the data, saved that as my Template, and the original data was completely blown away.

How can I prevent this from happening again?

* I was able to get the entire deleted sheet back by using File > "Version History" > and then saving the last version I worked on.

Thank you,
Mark
0
One of the users on our network is using Google file stream to connect to our shared Google Drive. They somehow deleted one of the folders on that shared drive but all the data is still there if we login.  It seems she lost the connecting folder.  how do I put it back?
0
I have a data sheet for a program that i'm building. I would like to be able to go down the entire data sheet and look at the 1st row to see if it has a quantity. If it does i would like for it to confirm the Vendor code in the 3rd row. If this Vendor Code = ex.(Esco) then i would like for it to add the 5th row ( Part Number and Description) and 1st row (Part Quantity) to a Purchase order page. I would like for this to happen to the entire page. What i'm seeing right now is after it finds the first row with these attributes it adds this but doesn't go any further . Is there a way to accomplish what i'm trying to do?
0
Hi Expert,
I need to get how many man and woman access the our sub domain and how to configure sub domain  for that
For example career.domainname.com
Woman - 30
Men  -14
any idea much appreciated
0
I have a Google form attached to a google sheet. The form has 4 questions, so the connected sheet has 5 columns (A-E) including the timestamp of the form submission. I'm trying to have a checkbox added in column F if data from the form is in the corresponding row. Is this possible?
The checkbox needs to be empty until a user manually checks the box, which will indicate that the data in the row has been acknowledged.
0
Old iPad running ios 10.  Where/how do i find Youtube file i downloaded?
0
I have an email account. It has the form:
my.name@domainname.org
In order to login to the email I have to browse to the domainname.org website and, in order to log in to my email I have to enter the following details:
username:  my.name@domainname.org
password: password1 [This was a password of my choosing]
Despite the fact that I provide authentication details on the domainname.org website, once I am authenticated, I am diverted to a Gmail account with the company logo in the top right corner.

I would now like to transfer all of the emails from this domainname.org (Gmail) account to another new, personal Gmail account. In order to do that I have been into the settings of my new Gmail account and used the "Import mail and contacts" process. The authentication details that I then provided in order to fetch the mail from the pop server were:
username:  my.name@domainname.org
password: password2 [This is a random-looking password provided to me by the company]
pop server: pop.gmail.com

I successfully managed to set the "Import mail and contacts" process going. Unfortunately, it only transferred two thirds of the emails. Gmail did not provide any error message. It took me a while to work out that the company Gmail has a 30GB limit whereas the new personal Gmail has a 15GB limit and when it reached 16.5GB, the import stopped.

I purchased the 100GB package. Once this was in place, the import did not start up again. When i tried to start it off again, I just ended …
0
Hello Experts,

How are you?

I use a Squid proxy connected to a routerboard / mikrotik that makes a load balance between two links.

Recently some users are reporting slow access to Google Drive, and I believe this issue may be related to load balance.

The question: Can I fix a specific routing for Google Drive? Do I need to do this URL based or can I get IP addresses from Google Drive networks?

Thanks in advance!

Best Regards
0

Google Apps

Google Apps is a suite of cloud computing productivity and collaboration software tools and software. It includes Google’s popular web applications including Gmail, Drive, Hangouts, Calendar, and Docs. While these products are available to consumers free of charge, Google Apps for Work adds business-specific features such as custom email addresses at your domain and storage for documents and email.