.png)
Google Sheets People Chips: The Ultimate Guide for 2023
In this article we will show what people chips are in google sheets. We also explain how to easily use them in different scenarios. Simply follow the steps below:
What are People Chips in Google Sheets?
People chips, also known as Smart chips in Google Sheets, enable you to label relevant individuals in your spreadsheets.
One application of this feature is when managing task assignments for a team in a project using Google Sheets. Utilizing people chips makes it more efficient to organize projects and tasks.
How to Convert E-Mails to People Chips in Google Sheets
1. Select the cell
Select the cell where you want to insert the people chip.
2. Type “@” then type the email address
When you type the ampersand symbol @, a list will immediately appear, where you can insert people, files, and events.
The list of users will appear at the top. If the list is short enough, you can jump directly to the next step. Otherwise, you need to start typing the email address to narrow down the list until you find the user to tag in the sheet.
3. Select the user from the list of contacts that appear
Once you find the user, click their email. The cell will be filled by the people chip with the name of the tagged user.
4. Give access to the user
The user tagged using a people chip may not have access to the sheet that you use. A pop-up window will appear where Google Sheets asks you if you want to grant access to the user.
Click Share if you want to give the user access to the spreadsheet.
This prompt will not show up if the tagged user already has access to the Google Sheets spreadsheet.
How to Insert Smart Chips for People
1. Right-click on the cell
A drop-down list will appear listing actions you can do to the cell.
2. Select Smart chips, then choose People
The Smart chips option is found near the end of the drop-down list. Click it.
You can insert People, Files, and Calendar events. Select People.
3. Click the user to include
A list of users you can tag will appear. Scroll down until you find the right user.\
Alternatively, you can type the email address or the name of the user to tag until the list shows the one you want to tag.
Once you find the user, click it. The cell will be filled by the people chip with the name of the tagged user.
4. Give access to the user
The user tagged using a people chip may not have access to the sheet that you use. A pop-up window will appear where Google Sheets asks you if you want to grant access to the user. CLick Share if you want to give the user access to the spreadsheet.
This prompt will not show up if the tagged user already has access to the Google Sheets spreadsheet.
FAQs
Can I Place People Chips in More Than One Cell at the Same Time?
No. If you try to do so by holding the Ctrl button to select several cells, Google Sheets will only insert the people chips at the last selected cell.
How Can I Tag Myself to the Sheet?
Simply type @me to the selected cell. Your name will appear on the sheet.
Are the Mentioned People Automatically Notified?
No. The mentioned people will only be notified if you share access to the sheet. So don’t worry if you have to quickly change the tagged users; they won’t be spammed with notifications every time you add or remove people chips to your sheets.
