Easily convert data to people chips and update chip format in Google Sheets

Qué está cambiando

Similar to the functionality in Google Sheets that helps you easily convert data to dropdown chips, you can now use bulk chip conversion for people chips. If you have a column of data that includes a variety of emails, Sheets will show a “Convert to people chips” suggestion when you click into your data range. By hovering over that indicator, you can preview the suggestion and then convert your data to people chips in one click. 
Convert to people chips” suggestion

In addition to the default format of display name, within the Format menu, you will now be able to update the format of your people chips to one of the following: 
  • Last name, First name 
  • Email address 
update the format of your people chips

Para empezar 

  • Admins: There is no admin control for this feature. 
  • Usuarios finales: 
    • To insert people chips on your own, type “@” followed by a name or email address. To change the format of the people chips, select a cell or cells with people chips, go to Format > Smart chips > select the desired format. 
    • To turn off this feature, go to Tools > Suggestion controls > (deselect) Enable dropdown chip suggestions. 
    •  Visite el Centro de ayuda para obtener más información sobre insertar fichas inteligentes en tus Hojas de cálculo de Google. 

Ritmo de implantación 

People Chip Formats: 
People Chip Suggestions: 

Disponibilidad 

  • Disponible para todos los clientes de Google Workspace, los suscriptores de Google Workspace Individual y los usuarios con cuentas personales de Google. 

Recursos