Smart chips are an excellent way to add more information and functionality to your spreadsheets in Google Sheets. You can use them to reference data from other sources, collaborate with others, and create interactive reports.

You can convert an email address or a link in a cell into a smart chip by using the Tab key on your keyboard. Here's how:

To add smart chips to your spreadsheet in Google Sheets, you can either create a new one or convert an existing cell to a smart chip.

You can Insert multiple smart chips into the same cell by placing a comma after each one. You can also combine various types of chips with text in one cell.

For example, if you select People, File, or Calendar event smart chips from the Insert menu, you will see available contacts, files, and events in the drop-down list.

You can also paste a URL into your spreadsheet, and Google will automatically offer you the option to convert it into a smart chip. Here's how:

After inserting a smart chip, you can hover the mouse over it to view details or click on it to pop up a menu with options to edit, delete, or perform data source-related actions.

Another option for adding a smart chip is to convert an existing string in a cell. You can convert a cell to a smart chip using the following methods:

By integrating smart chips, you can make your spreadsheets more versatile, ensuring data accuracy, enhancing efficiency, and boosting your overall productivity.

Image

Here's how to add smart chips through the Insert menu on the toolbar for People, File, Calendar events, Place, and Finance:

For example, after pasting a YouTube URL into a cell. Hover your mouse cursor over the link to view a preview and select Chip.

Image

If you @mention a user in a smart chip, they don't get automatic access to your spreadsheet. You have to share your Google Sheets spreadsheet for them to have access.

To add the dates, enter @, then select the date you want from the drop-down under the Dates section. Alternatively, use @date to access the date picker.

In Google Sheets, you can insert smart chips from scratch by typing the @ symbol or using the Insert menu. The various ways to insert smart chips in Google Sheets are as follows:

Image

For example, to insert a People chip, right-click on a cell with an email address. Select Smart chips and then Convert to People chip.

However, for Place and Finance smart chips, you will need to search in your Google Sheets spreadsheet and select an entity.

TechMet Carbides is an independent, privately owned company that began in 1998 with the goal of providing world-class tungsten carbide technology and products.

Google is constantly updating Sheets to enhance its functionality with new features. Among its many valuable features are smart chips, which enable you to insert interactive elements into your spreadsheet cells quickly and easily, thereby streamlining your workflow.