Notification

Bring your best ideas to life with Gemini for Google Workspace. Get tips & real-life use cases for using gen AI at work.

Create project plans with Sheets

Share your project plan

 

Project plan in Sheets.On this page


               

Want advanced Google Workspace features for your business?

Try Google Workspace today!

 

 

Create a group for your team

To make sharing easier, create a Google Group for your team.

  1. Sign in to Google Groups.
  2. At the top, click Create group.
  3. Enter information and choose settings for the group.
  4. 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.

Create a group.

Learn more at the Google Groups Help Center

Share the project plan

  1. Create a file in Google Drive, or open an existing file.
  2. In the file, click Share.
  3. In the Invite people field, enter the group's address.
  4. Select the level of access you want to provide the group: Editor, Commenter, or Viewer.
  5. Click Send.

Click Share to open the window where you add people, then click Send.

Learn more at the Google Drive Help Center

Present the project plan

Attach the project plan to a meeting invite

Make sure everyone has the latest copy of the project plan before the meeting—attach your project plan to the Google Calendar meeting invitation. Team members, both onsite and remote, can access and update it in real time. You can even spend the first few minutes of the meeting getting status updates from everyone, and updating the project plan accordingly.

  1. In Calendar, open your event.
  2. Click Add attachmentand thenGoogle Drive.
  3. Find your project plan spreadsheet and click Insert.
  4. Click Save.
Select the option to add an attachment from the bottom left.

Present the project plan in a team meeting

Present your project plan during your team meetings so everyone, including remote members, are on the same page.

  1. Join your meeting in Google Meet.
  2. In Sheets, open your project plan.
  3. At the top, click Meet and thenJust present this tab.
  4. Click the tab you want to share and click Share.

Upload the project plan to a team website

Share a master copy of your project plan on your team website. Updates to the spreadsheet automatically appear on your website.

  1. In Google Sites, open the page on your website where you want to embed the spreadsheet.
  2. At the top of the page, click Insertand thenSheets.
  3. Choose your project plan and click Insert.

Embed a spreadsheet in Sites.

Learn more at the Google Sites Help Center

Comment on the project plan

  1. On your computer, open a document, spreadsheet, or presentation.
  2. Highlight the text, images, cells, or slides you want to comment on.
  3. To add a comment, in the toolbar, click Add comment Add comment.
  4. Type your comment.
  5. Click Comment.

Open the Comment box and enter text, with the option to assign a task to someone.

Learn more at the Google Docs Editors Help Center

Chat with collaborators in a spreadsheet

  1. On your computer, open a document, spreadsheet, or presentation.
  2. At the top right, click Show chat Chat. This feature won't be available if you're the only one in the file.
    1. Tip: If there are many collaborators in the file, at the top right, to the right of the avatars, there will be a blue circle showing the number of additional collaborators. Click the blue circle and then Join chat Chat.
  3. Enter your message in the chat box.
  4. When you’re finished, at the top right of the chat window, click Close Close.

Note: All chats in Google Docs, Sheets, and Slides include anyone viewing the file. The chats aren't saved.

Open a chat.

Get notified about spreadsheet changes

If you need to know immediately when someone changes your spreadsheet, set up an email notification.

You’ll know exactly what’s changed and who to ask for details.

Set up email notifications

  1.  On your computer, open a spreadsheet in Google Sheets.
  2. At the top, click Tools and then Notification settings and then Edit notifications.
  3. In the window that appears, select "when" you want to receive notifications. Notify you when:
    • Any changes are made: Set notifications when someone makes a change to a spreadsheet.
    • A user submits a form: Set notifications when someone fills out a form.
  4. In the window that appears, select "how often" you want to receive notifications. Notify you with:
    • Email - daily digest: Send a daily summary of all changes.
    • Email - right away: Send an email for every change.
  5. Click Save.

Learn more at the Google Docs Editors Help Center

Archive your completed project plan

You can rename your completed project plan to mark it as archived and then change the permissions on it to view-only. People can view the content but won’t be able to make changes.

Rename your project plan in Sheets

  1. Open the file and at the top, click the file name.
  2. Before the file name, enter [Final] or [Archived].
  3. Press Enter.

Change access to view-only

  1. In Google Drive, right-click your project plan and click Share .
  2. To the right of the group you want to change, click the Down arrow and thenViewer.
  3. Click Save.

Back to top


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.

Was this helpful?

How can we improve it?
true
Print, save, or customize Learning Center guides

Learn how to print Learning Center guides, save them as PDFs, or customize them for your organization.

Search
Clear search
Close search
Main menu
7283251141969313248
true
Search Help Center
true
true
true
false
false