How to Assign in Google Sheets

Written by Emilija Google Workplace / Sheets

- 4 min read
Key Takeaways
  1. Open Google Sheets from your computer.
  2. Highlight the cells, you want to comment on.
  3. To add a comment, go to the toolbar and click Add comment.
  4. Type your comment.
  5. Somewhere in your comment, add the email address, with @ or + in front of it, of the person you want to assign it to.
  6. Click the box next to "Assign to [name]."
  7. Click Assign. 
  8. The person you assigned the action item to will get an email.

Besides being a handy tool for adding and monitoring data, Google Sheets can be a great managing tool that significantly eases the working process.

A not-so-well-known Google Sheets feature is the feature for assigning tasks to users who collaborate on the same document as you. This feature is part of the commenting option and is one of the best additions to Google Workspace collaboration tools.

The "assign" feature comes in handy when multiple users work on the same spreadsheet, and ownership of tasks can become a bit confusing.

This feature lets users quickly know who is responsible for what and which assignment needs their attention.

So, without any further ado, let’s dive into the steps of creating action items and assigning them to other users.

What are action items in Google Workspace, and how to use them?

Also included in Google format files are Action Items. The Action items can be used in Google Docs, Sheets, and Slides.

You can assign a specific task to a colleague within an action item and receive an email notification. You can also re-assign an action item to another user.

In addition, suggested action items will appear based on the content on your file.

How to assign an action item in the comments

  1. Open Google Sheets from your computer.
  2. Highlight the cells, you want to comment on.
  3. To add a comment, go to the toolbar and click the comment icon.

google sheets comment feature

  1. Type your comment and in the comment, add the email address, with @ or + in front of it, of the person you want to assign it to.
  2. Click the box next to "Assign to [name]."
  3. Click Assign.

assign task in google sheets

  1. The person you assigned the action item to will get an email.

email notification

How to re-assign tasks in Google Sheets

  1. Open Google Sheets from your computer.
  2. Click the comment you want to reassign.
  3. Click on Reply.
  4. Type your comment. Somewhere in your comment, add the email address, with @ or + in front of it, of the person you want to reassign it to.
  5. Click the box next to "Reassign to [name]."
  6. Click Reassign.

reassign google sheets

  1. The person you assigned the action item to will get an email.

Also read: How to Print Double-Sided on Google Docs, How to Group Images in Google Docs, and How to Insert Checkbox In Google Docs That Users Can Check.

How to Mark an action as done

  • In the top right corner of the comment, click Done.

What happens when action items are assigned to someone?

As we mentioned previously, that person will be notified via email that someone has assigned a task or an action item to them.

Wrapping Up

Google Workspace is getting better and more advanced as time passes. Since Google collaborative tools are easy to use yet offer advanced functionality, many users prefer them over other work means.

Google Workspace's assign feature is one of its most impressive features, as users can easily manage and work within a document without switching apps.