Insert smart chips Google Sheets

Insert smart chips in your Google Sheets to include information about:

• Users with Gmail or Google Workspace email addresses
• Other Google Docs, Sheets, or Slides files
• Google Calendar events
• Places and map directions
• Google Finance entities
• YouTube videos
• Ratings

With a smart chip in your spreadsheet, you can hover on or click a chip for more information.

Add smart chips

Important: When you @mention a user in a smart chip, they don't automatically get access to your document. To let another user get access, share your document.

1. On your computer, open a spreadsheet in Google Sheets.
2. Enter "@".
3. To narrow your options, select from the pop-up list or enter:
   • Letters
   • Numbers
   • Symbols
4. To add a:
   • People smart chip: Enter a name or email.
   • File smart chip: Enter the file name or related keywords.
   • Event smart chip: Enter the calendar event name or related keywords.
   • Place smart chip: Enter a place, address, or location.
   • Finance smart chip: Enter the name of the Google Finance entities, like stocks, mutual funds, or currencies.
   • Rating chip: Enter “Rating” and click on the chip to select a zero to five star rating from dropdowns.
5. To view the information, hover over the smart chip.

Tip: You can insert chips of different types together with text in one cell. Currently calculation reference to cells with multiple chips is not supported.

Use @ to insert dates more easily

1. On your computer, open a spreadsheet in Google Sheets.
2. To insert dates, select an option:

• Enter “@” then under the “Dates section,” select from the pop-up list.
• Input:
  • @date: Opens the date picker
  • @today: Shows today’s date
  • @yesterday: Shows yesterday’s date
  • @tomorrow: Shows tomorrow’s date
  • A relative date, like @monday, @next tuesday, or @last wednesday

Tip: To open the date picker, double-click a date.

Convert emails, links & more to smart chips

[Add people smart chips]

[Add file smart chips]

[Add event smart chips]

[Add place smart chips]

[Add finance smart chips]

[Add YouTube smart chips]

[Add rating smart chips]

Tips:

• You can make format changes to chips, such as:
  • Color
  • Size
  • Font style
• To remove formatting, at the top, click Format Clear formatting.

Add dropdown chips

You can add and customize dropdown chips that display multiple options.

Add or edit a dropdown

1. On your computer, open a spreadsheet in Google Sheets.
2. Select an option:
   • Enter “@.” In the Menu, under the components section, click Dropdowns.
   • At the top, click **Insert ** Dropdown.
   • Click **Data ** **Data validation ** Add rule .
   • Right click on a cell ** Dropdown**.
3. To make changes to a dropdown, click the dropdown and select an option.
4. To edit a dropdown's options, click the dropdown Edit button .

Learn more about how to create an in-cell dropdown list.