Insert smart chips in your 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 change the format of a people chip:
  1. Select the people chip you want to edit.
  2. At the top, click Format Smart chips.
  3. Select an option:
     • Default
     • Last name, First name
     • Email address
• 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.