Google Workspace Resources

Creating a document? Create the file in AssistList’s Shared Drives to ensure that your team can access it to provide feedback. Log into your AssistList.ca account, go to Google Drive, and navigate to the appropriate team folder within Shared Drives. Then click "+ New" and create a file within that folder.

shared_drives.png

Sharing a file to team members? In Slack, send a link to Google Drive instead of attaching the file to avoid having multiple different copies floating around.

share_file.png

Collaborating on a file with team members? No need to make a copy every time you make edits, all changes are tracked in the version history.

version_history.png

Providing feedback on a team member's document? Change to "Suggesting" so that they can see your edits.

suggesting.png

Looking for a Google app? Find all our apps in the “Apps Chooser” at the top right corner of google.com or gmail.com.

apps_chooser.png

Looking for a file? Try the search bar! Google is famous for its search engine capabilities and will give search results based on the text within the file. Additional search options also allow you to search by file type, owner, location and more.

search.png

Sending a calendar invite or email to your entire team? Start typing "team-" followed by your team name to find your team's distribution list. For example, sending a recurring weekly meeting to team-marketing@assistlist.ca will automatically invite all Marketing team members, even the new ones that join in the future. Our internal team mailing lists are:

- team-all@assistlist.ca

- team-managers@assistlist.ca

- team-board@assistlist.ca

- team-community@assistlist.ca

- team-support@assistlist.ca

- team-design@assistlist.ca

- team-development@assistlist.ca

- team-healthcare@assistlist.ca

- team-marketing@assistlist.ca

- team-pc@assistlist.ca

mailinglist.png

Can’t find where the document you’re working on is stored? There’s a Move button within Google docs to quickly move your file to another location, as well as open the current folder in a new tab.

move_file.png

Ready to send your Google Form? First, click the eye icon at the top right to preview and test your form. Then, when you’re satisfied with how it looks, click Send and copy the link into Slack for other team members to fill it out. By default, Google Form responses are restricted to those logged in with their AssistList G Suite account, so check the settings if you intend for others to complete it.

Waiting for Google Form responses? Enable the “Get email notifications for new responses” setting to get alerts when someone completes the form. Also, you can “Select response destination” to export all the responses into a Google Sheet to do additional analysis on the data.

form_notifications.png

Finding it hard to navigate through a big table in Google Sheets?

1. Create a filter! Highlight the header row by clicking the row number (#3 in this example). Then go to Data > “Create a filter”. You can now sort columns alphabetically or display only cells with specific entries

2. Freeze your header row! With the header row highlighted, go to Freeze > “Up to current row”. Now as you scroll down in your data, the header row is still visible at the top!

sheet_filter.png