Are you ready to uncover the power of People (Smart) Chips in Google Sheets? These nifty little features allow you to insert and convert email addresses into something much more. In this article, we’ll explore how to use People Chips and how to convert them back to their original email addresses. So, let’s dive in!
Purpose
Before we begin, let’s understand the purpose behind People Chips. Essentially, People Chips are email IDs formatted in a way that holds more information about the contact. Think of them as mini-profiles within your spreadsheet cells. These Chips provide additional insights about your email contacts, such as recent interactions, calendar events, and even quick ways to communicate with them. When you hover over or click on a People Chip, you’ll unlock a wealth of underlying information. It’s like having a personal assistant right at your fingertips!
How to Insert People (Smart) Chips in Google Sheets
Now that you understand the power of People Chips, let’s learn how to insert them into your Google Sheets. There are two simple methods you can use:
-
Method 1: Click on a blank cell, type the “@” symbol, and select “Insert > People chip.” From there, you can choose a contact from the drop-down list under PEOPLE or GROUP.
-
Method 2: Start by typing the required email address in a cell. Next, select “Insert > Convert to people chip.” Voila! The email address will transform into a fully functional People Chip.
But what if you encounter an error while converting an email address into a People Chip? Don’t worry, there’s a simple solution:
- Open the Contacts app.
- Select “Create contact” and add the name, email address, and other details.
- Save the changes.
- Re-type the email address in the cell and insert the People Chip as mentioned before.
How to Revert People Chips to Email Addresses in Google Sheets
Previously, there was no straightforward way to retrieve email addresses from People Chips. The only workaround was to manually copy each email address from the Chips. However, Google has come to the rescue with a new menu option for reverting People Chips back to their original email addresses.
Here’s how you can do it:
- Select the cell or range of cells that contain the People (Smart) Chips.
- Right-click to open the shortcut menu.
- Choose “View more cell actions > Remove smart chip.”
And just like that, your People Chips will transform back into simple and familiar email addresses. It’s important to note that currently, there is no formula option available for this conversion. However, the new menu option makes the process a breeze.
That’s all there is to it! Now you can harness the power of People Chips in Google Sheets, whether you’re organizing contacts, tracking interactions, or streamlining communication. Say goodbye to tedious manual copy-pasting and hello to efficient data management.
For more tips and tricks on optimizing your Google Sheets experience, visit Crawlan.com. Stay tuned for more juicy secrets, and enjoy unleashing the full potential of Google Sheets!
You may also like: How to Insert Drop-downs in Google Docs Documents.
