{"id":987517389,"date":"2025-02-06T23:10:29","date_gmt":"2025-02-06T23:10:29","guid":{"rendered":"https:\/\/workspace.trace.pt\/easily-convert-data-to-people-chips-and-update-chip-format-in-google-sheets\/"},"modified":"2025-02-06T23:10:29","modified_gmt":"2025-02-06T23:10:29","slug":"easily-convert-data-to-people-chips-and-update-chip-format-in-google-sheets","status":"publish","type":"post","link":"https:\/\/workspace.trace.pt\/es\/easily-convert-data-to-people-chips-and-update-chip-format-in-google-sheets\/","title":{"rendered":"Easily convert data to people chips and update chip format in Google Sheets"},"content":{"rendered":"<h3>Qu\u00e9 est\u00e1 cambiando<\/h3>\n<div>Similar to the functionality in Google Sheets that helps you easily <a href=\"https:\/\/workspaceupdates.googleblog.com\/2024\/05\/easily-convert-data-to-dropdown-chips-google-sheets.html\">convert data to dropdown chips<\/a>, 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 \u201cConvert to people chips\u201d 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.\u00a0<\/div>\n<div><\/div>\n<div class=\"separator\"><a href=\"https:\/\/blogger.googleusercontent.com\/img\/b\/R29vZ2xl\/AVvXsEhiQNQP_ZfplV9tPBHktaU8UF-yenitkVAMw6LqIorxv7bVBm2CdoqnIqUlSFw1ay-23ak7NpTT6jDX7rxxebBx1ZseNZ8lWjHY2QVY8Cf7z1HWcyMBDftPAytV_U_pzsEMBEmrCShU-NHJRov_S7jy7QjdJlqW2M8ACqD2WgLr4Za3HQRYSfLYINoGcq4\/s1600\/use%20the%20Convert%20to%20people%20chips%E2%80%9D%20suggestion.png\"><img decoding=\"async\" alt=\"Convert to people chips\u201d suggestion\" border=\"0\" data-original-height=\"764\" data-original-width=\"1600\" src=\"https:\/\/blogger.googleusercontent.com\/img\/b\/R29vZ2xl\/AVvXsEhiQNQP_ZfplV9tPBHktaU8UF-yenitkVAMw6LqIorxv7bVBm2CdoqnIqUlSFw1ay-23ak7NpTT6jDX7rxxebBx1ZseNZ8lWjHY2QVY8Cf7z1HWcyMBDftPAytV_U_pzsEMBEmrCShU-NHJRov_S7jy7QjdJlqW2M8ACqD2WgLr4Za3HQRYSfLYINoGcq4\/s16000\/use%20the%20Convert%20to%20people%20chips%E2%80%9D%20suggestion.png\"><\/a><\/div>\n<p><\/p>\n<div><\/div>\n<div>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:\u00a0<\/div>\n<div>\n<ul>\n<li>Last name, First name\u00a0<\/li>\n<li>Email address\u00a0<\/li>\n<\/ul>\n<\/div>\n<div class=\"separator\"><a href=\"https:\/\/blogger.googleusercontent.com\/img\/b\/R29vZ2xl\/AVvXsEhGL-KA4tsYAv6_NzXC6Qco7ShbHsU1bVymhoAuH25OErBe2kfvIiKPQ9-xdeKaEqhVyywLrcPZJ6J9o18hB8a70DX5e-nZGjxuZi1fvWR8yMQeGwQljM92-SiEu3aVmQlKDnU-Il_o9nyea_PaJiXdckT7AK12Lk5YRHY93xqn36q0vM8idtdWF5nYQyc\/s1600\/update%20the%20format%20of%20your%20people%20chip.png\"><img decoding=\"async\" alt=\"update the format of your people chips\" border=\"0\" data-original-height=\"996\" data-original-width=\"1600\" src=\"https:\/\/blogger.googleusercontent.com\/img\/b\/R29vZ2xl\/AVvXsEhGL-KA4tsYAv6_NzXC6Qco7ShbHsU1bVymhoAuH25OErBe2kfvIiKPQ9-xdeKaEqhVyywLrcPZJ6J9o18hB8a70DX5e-nZGjxuZi1fvWR8yMQeGwQljM92-SiEu3aVmQlKDnU-Il_o9nyea_PaJiXdckT7AK12Lk5YRHY93xqn36q0vM8idtdWF5nYQyc\/s16000\/update%20the%20format%20of%20your%20people%20chip.png\"><\/a><\/div>\n<p><\/p>\n<div><\/div>\n<h3>Para empezar\u00a0<\/h3>\n<div>\n<ul>\n<li><b>Admins:<\/b> There is no admin control for this feature.\u00a0<\/li>\n<li><b>Usuarios finales:\u00a0<\/b><\/li>\n<ul>\n<li>To insert people chips on your own, <i>type \u201c@\u201d 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 &gt; Smart chips &gt; select the desired format.\u00a0<\/i><\/li>\n<li>To turn off this feature, <i>go to Tools &gt; Suggestion controls &gt; (deselect) Enable dropdown chip suggestions.\u00a0<\/i><\/li>\n<li>\u00a0Visite el Centro de ayuda para obtener m\u00e1s informaci\u00f3n sobre <a href=\"https:\/\/support.google.com\/docs\/answer\/12319513?hl=en\">insertar fichas inteligentes en tus Hojas de c\u00e1lculo de Google.<\/a>\u00a0<\/li>\n<\/ul>\n<\/ul>\n<\/div>\n<div><\/div>\n<h3>Ritmo de implantaci\u00f3n\u00a0<\/h3>\n<div><b>People Chip Formats:<\/b>\u00a0<\/div>\n<div>\n<ul>\n<li><a href=\"https:\/\/support.google.com\/a\/answer\/172177\">Dominios de liberaci\u00f3n r\u00e1pida<\/a>Disponible ahora.\u00a0<\/li>\n<li><a href=\"https:\/\/support.google.com\/a\/answer\/172177\">Dominios de publicaci\u00f3n previstos<\/a>: Gradual rollout (up to 15 days for feature visibility) starting on February 18, 2025\u00a0<\/li>\n<\/ul>\n<\/div>\n<div><\/div>\n<div><b>People Chip Suggestions:\u00a0<\/b><\/div>\n<div>\n<ul>\n<li><a href=\"https:\/\/support.google.com\/a\/answer\/172177\">Dominios de liberaci\u00f3n r\u00e1pida<\/a>: Gradual rollout (up to 15 days for feature visibility) starting on February 6, 2025\u00a0<\/li>\n<li><a href=\"https:\/\/support.google.com\/a\/answer\/172177\">Dominios de publicaci\u00f3n previstos<\/a>: Gradual rollout (up to 15 days for feature visibility) starting on March 3, 2025\u00a0<\/li>\n<\/ul>\n<\/div>\n<div><\/div>\n<h3>Disponibilidad\u00a0<\/h3>\n<div>\n<ul>\n<li>Disponible para todos los clientes de Google Workspace, los suscriptores de Google Workspace Individual y los usuarios con cuentas personales de Google.\u00a0<\/li>\n<\/ul>\n<h3>Recursos\u00a0<\/h3>\n<\/div>\n<div>\n<ul>\n<li><a href=\"https:\/\/support.google.com\/docs\/answer\/12319513?hl=en\">Ayuda de Google: Inserci\u00f3n de fichas inteligentes en las hojas de c\u00e1lculo de Google\u00a0<\/a><\/li>\n<li><a href=\"https:\/\/workspaceupdates.googleblog.com\/2024\/05\/easily-convert-data-to-dropdown-chips-google-sheets.html\">Google Workspace Updates Blog: Easily convert data to dropdown chips in Google Sheets<\/a><\/li>\n<\/ul>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>What\u2019s changing 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 \u201cConvert to people chips\u201d suggestion when you click into your [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-987517389","post","type-post","status-publish","format-standard","hentry","category-noticias"],"acf":[],"_links":{"self":[{"href":"https:\/\/workspace.trace.pt\/es\/wp-json\/wp\/v2\/posts\/987517389","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/workspace.trace.pt\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/workspace.trace.pt\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/workspace.trace.pt\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/workspace.trace.pt\/es\/wp-json\/wp\/v2\/comments?post=987517389"}],"version-history":[{"count":0,"href":"https:\/\/workspace.trace.pt\/es\/wp-json\/wp\/v2\/posts\/987517389\/revisions"}],"wp:attachment":[{"href":"https:\/\/workspace.trace.pt\/es\/wp-json\/wp\/v2\/media?parent=987517389"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/workspace.trace.pt\/es\/wp-json\/wp\/v2\/categories?post=987517389"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/workspace.trace.pt\/es\/wp-json\/wp\/v2\/tags?post=987517389"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}