How to find all the files you own in Google Drive

Tips
Drive
How to find all the files you own in Google Drive

Tips

Drive
Gmail
Docs
Overdrive
Calendar
Sheets
Sites
Chrome
- How to remove the Reading list button from Chrome
Contacts
Slides
Chat
Meet
Forms
Keep
More...
- Admin
- Android
- Images
- iOS
- Migration
- Scripts
- Security

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

How to find all the files you own in Google Drive

Did you know that you can search Google Drive for files that are owned by you, or others? You can use this feature to separate your files from the ones owned by your colleagues or external users. Take advantage of this search feature to save time. Google Drive is an online storage service that allows Google Workspace to store and share files. The service syncs documents, images, and other files across all of the user's devices, including mobile phones, tablets, and computers. Google Drive allows you to organize files inside standard folder hierarchies, as well as locate folders and files using traditional navigation techniques (e.g. clicking down through a folder hierarchy). However, it is usually faster to use Google Drive's fantastic search capabilities. To find all the files owned by you within your company’s Google Drive, click on the search box and enter creator: followed by your email address. For example, creator: [email protected] . You can use this trick with any email address from within your company’s domain (e.g. creator: [email protected] ) You can also use the advanced search filters such as Location, File Type, Last Modified, and Labels to narrow your search. You can now find files in Google Drive more precisely and faster with this advanced search tip. For more Google Drive search shortcuts check out this tip . Ask for help or share your Google Drive tips with the community on our dedicated Google Workspace forum .
How to count characters in Google Sheets

When you’re using Google Sheets for work or school, you may have to deal with text data. Unlike Google Docs, the spreadsheet app from Google doesn’t have a built-in character counter. However, there’s a dedicated Google Sheets function to count characters. Counting characters in Google Sheets is easier than you may think. The LEN function can be used in many situations to count characters in a spreadsheet. Count all characters in a cell Type in the LEN function and make a reference to the cell you want to count. This method is used to count all characters, including letters, numbers, spaces, punctuation marks, etc. Example: =LEN(A2) Count characters and ignore spaces The LEN function counts all characters, including spaces. If you want the count to ignore spaces and punctuation marks, you can add the SUBSTITUTE function to the syntax; the main purpose of this function is to replace one character with another, so we’re using it in order to replace spaces and other punctuation marks with nothing. Example: =LEN(SUBSTITUTE(A3, " ", "")) Count all characters in a column The LEN function doesn’t work with a range of cells, but you can add the SUMPRODUCT function to sum up the characters in a range. Example: =SUMPRODUCT(LEN(A2:A9)) Remember that the LEN function counts all characters, including spaces. If you want removed spaces and punctuation marks, simply use the SUMPRODUCT function to add up the results from the counting column. Example: =SUMPRODUCT(B2:B9) If you still have questions about counting characters in Google Sheets, ask our community of Google Workspace power users!
How to Avoid Getting Removed from Google Meet Calls

Google Meet is used by many organizations on a daily basis for quick calls or virtual meetings. Google Calendar meetings automatically receive a Meet link which guests can use to join the virtual meeting room. Google is working to make the app more efficient and constantly introduce new features. The “leave empty calls” feature can remove you from a meeting when you're the only person in it. Let's say you enter a team meeting and no one arrives within five minutes: a pop-up message will appear, asking if you're still there and if you'd prefer to wait or hang up. You will be instantly thrown out if you do not answer within two minutes. Although this feature can prevent people from leaving meeting tabs open and accidentally broadcasting their video and audio feeds, some of us find it irritating. With this feature enabled, you will be kicked out of the meeting if your colleagues are a few minutes late. This option is enabled by default, but you can switch it off via Google Meet settings. Disable the “Leave empty calls” feature to prevent Google Meet from kicking you out of meetings and keep a regular meeting pinned as tabs. Open any Google Meet room and click on the three dots from the right corner of your camera feed. 2. Click on Settings. 3. Navigate to the General settings tab and switch off the “Leave empty calls” toggle. Your new settings are automatically saved, so you can just close the settings window. On mobile devices, open the Google Meet apps and select the account you want to switch off the feature for. Go to Settings and tap on the “Leave Empty Calls” option. What do you think about this feature? Visit our Google Workspace community forum and share your thoughts with other Google Meet users.

Powered by Overdrive

Tips
- Drive
- Gmail
- Docs
- Overdrive
- Calendar
- Sheets
- Sites
- Chrome
- Contacts
- Slides
- Chat
- Meet
- Forms
- Keep
- More...
Community
Tools
Services
- Development
- Training
Add-on Apps
Blog

How to find all the files you own in Google Drive

How to find all the files you own in Google Drive

How to find all the files you own in Google Drive

How to count characters in Google Sheets

How to Avoid Getting Removed from Google Meet Calls