Workspace Tools

Tools

Tools

Change Owner
Drive Permissions
Copy Folder
Filename Editor

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 Google Workspace and everything Google, so we’re delighted to share the latest insights, tips and tricks with you.

Latest Tips

Stop the plus sign from generating a formula in Sheets

When you try to enter a phone number in Google Sheets or anything that starts with the plus sign, the cell will automatically create a formula. However, there’s an easy workaround so you can add the + sign in a cell followed by plain text. Before you enter the plus sign, start with a single apostrophe in the cell. This tells Google Sheets that you are trying to enter plain text and not a formula. For example: '+word+word will come out as just +word+word. Now you can enter signs in any cell without starting a formula or function.
How to share a Google Drive folder publicly

Google Workspace users have the option to publicly share files or folders stored in Google Drive. Folders shared with the public are visible to anyone who has the link or finds them through Google search. Inherently, all files within a publicly shared folder are visible to the public. Here’s how to make a Google Drive folder public: Open the folder in Google Drive, right click on it’s name and click Share. 2. From the pop up share menu, click on Get link and choose Anyone with the link. The people you share the link with won’t have to log in to see the files within the folder. You can always go back and restrict the sharing settings using the same Share menu in Google Drive. You can also try Overdrive and turn your Google Drive into a website.
Add your working location to Google Calendar

Google Workspace users can share in Calendar where they are working from on any day of the week. This feature makes organizing meetings more convenient. Available work locations are office, home, unspecified, somewhere else. Here’s how to share where you’re working from in Google Calendar: Open Google Calendar and go to Settings (top right corner). Find the Working hours and location on the left sidebar. Check the Enable working location box and specify your location for each working day. You can edit this later directly on your Google Calendar home screen. This feature is available for the following Google Workspace editions: Business Standard, Business Plus, Enterprise Standard, Enterprise Plus, Education Plus, Nonprofits, and G Suite Business.

Powered by Overdrive

Tips
Tools
Services
- Development
- Training
Add-on Apps
Blog

Workspace Tools

Workspace Tools

Stop the plus sign from generating a formula in Sheets

How to share a Google Drive folder publicly

Add your working location to Google Calendar