Sheets

Sheets

Tips
Sheets

Create, edit and collaborate better with these Google Sheets tips and tricks

Tips

Drive
Gmail
Docs
OverDRIVE
Calendar
Sheets
Sites
Chrome
Contacts
Slides
Hangouts & Chat
Google Plus
Forms
More...

Sign in with Google

Or

We won't share your email address with any third-parties.
Please see our Privacy Policy for further information.

About Us

G Suite Tips is provided by the team at OverDRIVE. We’re passionate about G Suite and everything Google, so we’re delighted to share the latest insights, tips and tricks with you.

Join in

If you’ve got a top tip then share it. We’re all ears!
Suggest a Tip

Latest Tips

Save time with scheduling features in Calendar

Save time with an easier way to schedule meetings in Google Calendar People-first scheduling makes it quick and easy to find meeting times with your colleagues. You can add rooms, a location, a video conference and add a meeting description without having to click into “More options.” When creating a new meeting in Calendar, you’ll now be able to do the following: Peek at calendars and automatically add guests: Now, when you add a calendar in the Meet with ...“Search for people” box, you can temporarily view coworkers’ calendars. Creating a new event then automatically adds those people as guests to your meeting and will sometimes even suggest a title for the meeting. More fields in the creation pop-up dialog: The Guests, Rooms, Location, Conferencing, and Description fields are now editable directly in the meeting creation pop-up dialog. Once you add your coworkers’ calendars, they’ll load right in the background, making it even easier and faster to find an available time for everyone.
Get quick access to your G Suite add-ons

Connect G Suite to your favourite workplace Add-on apps using the quick access side panel The side panel gives users quick access to Calendar, Hangouts, and Keep from an embedded side panel in G Suite. The side panel is now open for third-party developers, including apps such as Copper and Smartsheet. Once your organisation is in the beta program, you’ll be able to install G Suite Add-ons. Here’s how: Click the “+” button in the G Suite quick access side panel Select the add-on you want to feature in your side panel Click install The G Suite Add-ons you install will appear in the side panel across your G Suite apps and help you complete entire workflows without the need to switch back and forth between multiple apps. If you’re not already, Express interest in the G Suite Add-ons beta
Translate languages in Google Sheets

Translate text from one language into another with this simple formula in Google Sheets Whether you’re a student studying a new language or a tourist encountering new words, the Google Translate formula in Google Sheets provides you with an easy access list of what you know, or want to know. To get started simply enter a word in one language in a cell, and then use the formula =GOOGLETRANSLATE(cell with text, “source language”, “target language”) in another cell to translate it. You can even drag the fill handle at the bottom of the formula cell down to apply this formula to more than one cell. Here’s an example, translating English words into Spanish: =GOOGLETRANSLATE(A2, “en”,”es”) This formula works for all languages supported by Google Translate. You’ll just need to know the 2-letter code for the language, which you can find in this list .

Tags

Android iOS Migration Scripts Security Admin Images Drive Gmail Docs OverDRIVE Calendar Sheets Sites Chrome Contacts Slides Hangouts Google Plus Forms More

Website Terms of Use | Privacy | GDPR

Disclaimer

The Tools provided here are not supported under any standard support program or service. All Tools are provided AS IS without warranty of any kind.

Refractiv further disclaims all implied warranties including, without limitation, any implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the Tools and documentation remains with you. In no event shall Refractiv, its authors, or anyone else involved in the creation, production, or delivery of the Tools be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the scripts or documentation, even if Refractiv has been advised of the possibility of such damages.

Show More Show Less

Convert Google Drive and
G Suite content into web pages automatically

Android iOS Migration Scripts Security Admin Images Drive Gmail Docs OverDRIVE Calendar Sheets Sites Chrome Contacts Slides Hangouts Google Plus Forms More

OverDRIVE is a smart site
builder like no other

Discover how to turn Drive and G Suite content into web pages automatically

Register

Say goodbye to
traditional websites

Turn Drive and G Suite content into web pages automatically

Set up a site in minutes

#1 CRM for
G Suite

More...

Drive permissions

Identify and manage the sharing rights of every file from every user on your domain

G Suite Training

Get the most from your G Suite investment,
with a training solution that's just right for you.

© 2019 G Suite Tips

Powered by OverDRIVE

Tips
Tools
Add-on Apps
Blog
Events
Contact