Tech Tip Missing Data in Spreadsheet

Missing data in a spreadsheet? This new article may help!

Google Drive, Docs, Sheets, and Slides Partial Outage

Update: As of 12:20PM, Google's Workspace Status Dashboard indicates issues are all resolved.

 Google is aware of an issue affecting some people utilizing Google Drive, Docs, Sheets, and Slides.  This issues is being worked on by Google.  You can check the Google Workspace Status Dashboard for updates on this outage.

Google Workspace: Share/View History of Docs, Sheets, and Slides Now Available

Google Workspace has released a new feature that allows you to see a list of all those who you have shared the document with as well as the last time they viewed it. 

For directions on how to access this feature please refer to this link. 

Directly Edit Microsoft Office Files with Google Docs, Sheets & Slides

What’s changing 

With Office editing, you can now edit, comment, and collaborate on Microsoft Office files using Google Docs, Sheets, and Slides. This feature brings the collaboration benefits of G Suite to Office files while streamlining workflows by eliminating the need to convert file types.

Why you’d use it 

Office editing will make it easy for G Suite users to open and edit Microsoft Office files that have been shared by partners, vendors or other teams. In cases where some members of your organization use Office while others use G Suite, this ensures seamless collaboration and eliminates the need to consider or convert file types.

Office editing brings everyone the benefits of G Suite’s real time collaboration tools and intelligence features to Office files.


End users:

• In Google Drive, double-click your Office file. This will open a preview of the file. 
• At the top, click Open in Google Docs, Sheets, or Slides. 
• From here, you can edit, share, view version history, collaborate in real-time with others, and more. 
• All changes you make will be saved to the original Office file. 

Additional details 

The following Office file types are supported: 

• Word files: .doc, .docx, .dot 
• Excel files: .xls, .xlsx, .xlsm (macro enabled Excel files), .xlt 
• Powerpoint files: .ppt, .pptx, .pps, .pot 

Note: If you edit Word, Excel, or PowerPoint documents older than Office 2007, files will be saved to a newer format when editing using Office editing. 

Note: 

If you have the Office Editing for Docs, Sheets & Slides Extension already installed it must be removed before this new feature will work:

Sign into Google Chrome Browser with your Managed Google Account

Navigate to the upper right of your screen to the Settings area

Select More Tools

Select Extensions

Locate the Office Editing for Docs, Sheets & Slides from your options of extensions and select Remove

Helpful links 

To learn more about working with Office files using Office editing, see here. 

To learn more about removing the Office compatibility app, see here. 

Partially reposted from :  Office editing makes it easier to work with Office files in Docs, Sheets, and Slides

Sheets is Updated with 3 New Features

What’s changing 

Google is introducing three new features that will help you clean up and work with your data in Sheets. These features are: 

• Remove duplicates 
• Trim whitespace 
• Compatible spreadsheet shortcuts 

Why you’d use them 

Remove duplicates: 
A highly requested feature, you can use this tool to easily remove duplicate values from your sheet, saving you time by eliminating the need to write an app script or manually remove duplicate data.

Trim whitespace: 
Sometimes when you add data to a sheet, it may not be the format you need. Now, you can easily keep your sheet standardized by using the trim whitespace feature to remove any leading, trailing, or excessive whitespace from a cell or array of data.

Compatible keyboard shortcuts: 
You can now use popular keyboard shortcuts from other spreadsheets in Sheets. These familiar shortcuts will make navigating and working with data in Sheets quicker for users.

How to get started 

• To remove duplicates from a range of data: 
• Select range of data in your sheet 
• From the toolbar, select Data > Remove duplicates. In the dialogue box, you’ll see your selected range of data. 
• Select Remove duplicates. You’ll see an additional dialogue box that details how many duplicates were removed from your dataset.
• To trim whitespaces: 
• Select a cell or range of data that contains whitespace on your sheet 
• From the toolbar, select Data > Trim whitespace 
• You’ll then see a dialogue box that details how many cells whitespace was removed from. 

• To enable compatible keyboard shortcuts: 
• Users can access keyboard shortcuts by going to Help > Keyboard shortcuts. 
• From here, you can see a list of keyboard shortcuts and their corresponding commands. Note that compatible shortcuts will be denoted with an info icon. 
• At the bottom, you can enable compatible spreadsheet shortcuts. 
• You can click “View compatible shortcuts” at the bottom right to see a complete list of all newly available shortcuts. 

Helpful links 

Keyboard shortcuts for Google Docs. 
Split text, remove duplicates, or trim whitespace in Sheets.
Separate cell text into columns. 

Availability 

Rollout details 

• These new features will be available soon.

Partially reposted from:  Three new features to format and work with data in Sheets

Week 4 Tech Showcase -Mail Merges Made Easy Using formMule

formMule

formMule  is a free addon for Google Sheets that allows you to easily send mail merges. It utilizes tags which gathers data such as email lists and names and uses that to send a personalized or tagged emails.

It is a powerful tool that provides you with the ability to:

• use auto-insert merge tags with the click of a button, making template-creation a breeze!
• use up to 10 different email templates based on specified send conditions.
• create unique case numbers on form submit for use in keying follow-ups
• grab and send form response edit URLs, and formulas copied down on form submit
• use custom spreadsheet functions RANGETOTABLE and RANGETOVERTICALTABLE which make it possible to merge tables of multiple, matching records into email bodies.

Another powerful application of formMule is to mail merge Google Form responses.


Please watch this video for additional help getting started with formMule:

For more information on formMule and how detailed instructions on how to use it, please visit this Knowledge Base Article on Mail Merging using formMule.

Please take this brief formMule for Mail Merges Survey to let us know what you think about formMule.

If you have additional questions about how to use formMule for mail merges please contact IT Services:
ITS@manhattan.edu or TEL: 718-862-7973