We help IT Professionals succeed at work.

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.

Windows 11 all the updates, Outlook keeps asking for my password, I use gmail, and have outlook download and delete from google. for some reason it is now asking for the "password" that I just changed Saturday, it's been working just fine till this morning, I use Nord Vpn. any suggestions?
0
hi,

want to install google hangouts meet on windows 10 PC, seems can't !

seems only for Android host, any idea on how to fix it for PC ?
0
I just created a new free Gmail account.  I have to email about 100 people. When I’m trying to do it it won’t go through. No one has received any of my messages. Is there a reason why? I would think it’s under the limit.
0
I have a database that generates an excel file. I have to copy to my desktop then upload to my google drive shared folder. Is there a way to upload the file right to my google drive shared folder. I dont see an option save to google drive or something simialar
Thanks
0
When I right click on a file then select send to Google Drive. Google Drive opens up but the file does not get downloaded into the Drive nor I get any prompt asking me where I need to save it? Can someone help me please?
Thank you,
Basem Khawaja
0
Interesting challenge for everyone this is actually a difficult one.   Has anyone worked with google phones lately?  They have added a feature that prevents phones from getting factory'ed without forcing a new factory restore to continue without entering googles old account information that was previously associated with the phone.   I guess its a new security feature that allows users to setup their account (personal or business related) using a password or pattern swipe to continue to login.  

Having said that we have a bunch of google phones that are "bricked" because even after the phone is factory'ed it still remembers the last account that was setup and will not let the phone setup be complete without entering the credentials of the last user.  

The impossible question is there any way to get around this so the phone can be recycled for someone else?
0
Hello Experts,

in plain English...

if "yes" is selected, move row to a different sheet.
also add the current date into the Col. and
now calculate the total days between col A & G and display results in H

for some reason it doing the calctulation for the row above, not the current row that has just been populated.

any ideas please?

function onEdit(event) {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var s = event.source.getActiveSheet();
  var r = event.source.getActiveRange();

  if(s.getName() == "Active Jobs" && r.getColumn() == 7 && r.getValue() == "yes") {
    var row = r.getRow();
    var numColumns = s.getLastColumn();
    var targetSheet = ss.getSheetByName("Completed Jobs");
    var target = targetSheet.getRange(targetSheet.getLastRow() + 1, 1);
    //This puts the completion date into the last column of data currently col G
    targetSheet.getRange(targetSheet.getLastRow(),numColumns  + 0).setValue(new Date());
    //Calculates the turn around time in days for column I on the Completed sheet
    targetSheet.getRange(targetSheet.getLastRow(),numColumns  + 1).setFormula("=DATEDIF(R[0]C[-7],R[0]C[-1],\"D\")+1");
    s.getRange(row, 1, 1, numColumns).moveTo(target);
    s.deleteRow(row);
  }
}

Open in new window



https://docs.google.com/spreadsheets/d/1X4M2G0f7MEpDETrVIZ2kU9MJAFC8K9jR9ZqKOijYDN0/edit?usp=sharing
0
I have a Gmail mailbox attached to an user in G-Suite that's in the name of an organisation, not a person's name, so the "FirstName LastName" format doesn't apply. Google doesn't allow for one of these fields to be blank either, so just to get around this, I've had to put the first half the org name in First Name, and other other half in Last Name. But is there a way around this? I can't imagine I'm the only one faced with this problem.

I can change from "First Last" to "Last, First", but this doesn't help because I cannot have the First or Last fields blank.
0
hello i have this script which i would like to use on my google sheet so that if a data in column A is over 6 days then it will colour the cell as red.
Unfortunately its not throwing any errors so i don't know what it wrong with it but its not working.

function checkDate() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName("Active Jobs");
  var dates = sheet.getRange("A:A").getValues();
  for(var i=0;i<dates.length;i++) {
    var d = dates[i][0];
    var isNotString = typeof d != "string";
    if(isNotString) {
      var today = new Date();
      d.setHours(0,0,0,0);
      today.setHours(0,0,0,0);
      var diff = (today - d)/(24*60*60*1000);
      var cell = sheet.getRange("A" + (i+1) + ":A" + (i+1));
      if(diff>=6)
        cell.setBackgroundRGB(255,0,0);
      else
        cell.setBackground("white");
    }
  }
}

Open in new window


can anyone see what might be wrong here please?
0
I have an ""UNRESOLVED"" question about Google Drive Backup and Sync[ GDBS ]. I would like to reclaim the space that was used up by the C Drive when I downloaded the GDBS. Please refer to the Unresolved question via the link below.

****https://www.experts-exchange.com/questions/29172829 ****


Thank you,
Basem Khawaja
0
Hello, I have the following script for a google sheets. I would like the row of data to be copied down to the next available (empty) row and then the original data to be cleared, ready for the the next input.

function saveButton() {
  var ss = SpreadsheetApp.getActive();
  // [START modifiable parameters]
  var sourceRange = ss.getRange('Active Jobs!A2:F2');
  var targetRange = ss.getRange('Active Jobs!A3:F3');
  // [END modifiable parameters]
  sourceRange.copyTo(targetRange);
  ss.toast('Data copied to ' + targetRange.getSheet().getName() + '. ' +
    'To undo, press Control+Z (on a Mac, ⌘Z).', 'Action button - Save');

  var ss = SpreadsheetApp.getActive();
  // [START modifiable parameters]
  var rangeToClear = ss.getRange('Active Jobs!A2:F2');
  // [END modifiable parameters]
  rangeToClear.clearContent();
  ss.toast("Cleared range '" + rangeToClear.getSheet().getName() + "'!" + rangeToClear.getA1Notation() + '. ' +
    'To undo, press Control+Z (on a Mac, ⌘Z).', 'Action button - Clear');
  rangeToClear.activate();
}

Open in new window



I have two problems:

1, var targetRange = ss.getRange('Active Jobs!A3:F3');

this line needs to read... in plain english..... find the last available row and insert



2, The delete does not seem to clear the last visited cell. So the last cell that the user inputs into is F2. If the user does not click out of that cell before pressing save then this cell is ignored.

thanks for your help.

https://docs.google.com/spreadsheets/d/1qSauIqjvSEhEEZJ6z4pJUnR_HZcoMi98frAx94zl6a8/edit?usp=sharing
0
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
I have some questions related to Google Chrome.1.Why is Chrome managed by my organization. I am the only person who uses it for personal use. How can I change that?
2.Google Drive, is it supposed to be located in my user's folder? I had seen a tutorial showing that it is located in user's folder. The only place I see it is in the Bookmarks Bar in Chrome on the far left hand side in the square icon that is called Apps. Also, it is located in the send to context menu as well. How can it be added to the user's folder if that where it belongs and I don't mean as a shortcut either. FINAL question-when I right click on a file to be sent to Google drive then select Google Drive from the send to context menu "NOTHING happens, it does not get sent to the Google Drive. On the other hand I am able to upload it directly from Google Drive but that's not what I am attempting to accomplish.
Please help me figure out solutions to these questions.
Thank you,
Basem Khawaja


Chrome Managed by my Organization
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

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.