Now you’re ready to share the project plan with your team and start collaborating.
In this section, you learn how to:
Sometimes there are sections of content you don't want your team to edit. Make certain content protected so it can't be edited, or can only be edited by specific people.
Lock critical content:
- Select the cells you want to protect.
- Click DataProtected sheets and ranges.
- Click Set permissions.
- Choose an option:
- To restrict any changes to certain people, select Restrict who can edit this range and select who can edit the cells.
- To display a warning to alert people before they make a change, select Show a warning when editing this range.
- Click Done.
Make communication easier by creating a Google Groups email list for your team. Then, instead of emailing people individually, use the group’s email address to share status updates with everyone at once.
- Sign in to Google Groups.
- In the upper-left corner, click Create group.
Enter information and choose settings for the group.
- Click Create group.
- Wait a few minutes for your new group to become active before sending a message to it. Otherwise, you might get a notification that your message couldn't be delivered.
Next, share the project plan with your team members (or with the group you created for your team).
Share a file you own or can edit:
- In Sheets, open the file you want to share.
- Click Share.
- Enter individual email addresses (or just your project team’s Google Groups address).
- Choose what kind of access you want to grant people:
- Viewer—People can view the file, but not edit or add comments.
- Commenter—Collaborators can add comments, but not edit content.
- Editor—Collaborators can add and edit content or add comments. If you want your team members to update the project plan themselves, choose this option.
- (Optional) Add a note describing the project plan.
- Click Send.
Everyone you shared the file with will receive an email with a link to it. If you gave your team members edit access, they can:
- Add or update content, like tasks, owners, and due dates.
- Filter content to show what they’re interested in.
- Insert comments addressed to specific people.
- Update the status for tasks.
- Add descriptive notes to tasks.
- In Sheets, open a spreadsheet and select the cells where you want checkboxes.
- Click InsertCheckbox.
- (Optional) To delete checkboxes, select the checkboxes you want to remove and press Delete.
Note: In formulas, unselected checkboxes have a value of FALSE (exclude) and selected checkboxes have a value of TRUE (include). You can see the value in the Formula bar. You can also change this value.
Want to see tasks assigned to you or due on a specific day? Create a filter view.
|At the top, click DataFilter viewsCreate new filter view.|
|In the top left corner, click next to Name and enter a name for the filter view.|
|Click the arrows in the column headers and select options to sort and filter the data.|
|(Optional) To email a link to the filter view, copy the URL and paste it in an email.|
|At the top right, click Close to close your filter view. Your filter view is automatically saved.|
- In Docs, Sheets, or Slides, select the text you'd like to comment on.
- Click Add comment .
- Enter your comment in the box.
- (Optional) To direct your task or comment to a specific person, enter a plus sign (+) followed by their email address. You can add as many people as you want. Each person will get an email with your comment and a link to the file.
- (Optional) To assign the comment to a specific person, check the Assign to box.
- Click Comment or Assign.
Note: If a file reaches the maximum number of comments, you can make a copy of the file without copying over any comments.
Google, Google Workspace, and related marks and logos are trademarks of Google LLC. All other company and product names are trademarks of the companies with which they are associated.