{"id":987516736,"date":"2024-05-07T22:26:08","date_gmt":"2024-05-07T22:26:08","guid":{"rendered":"https:\/\/workspace.trace.pt\/easily-convert-data-to-dropdown-chips-in-google-sheets\/"},"modified":"2024-05-07T22:26:08","modified_gmt":"2024-05-07T22:26:08","slug":"easily-convert-data-to-dropdown-chips-in-google-sheets","status":"publish","type":"post","link":"https:\/\/workspace.trace.pt\/fr\/easily-convert-data-to-dropdown-chips-in-google-sheets\/","title":{"rendered":"Easily convert data to dropdown chips in Google Sheets"},"content":{"rendered":"<h3>What\u2019s changing<\/h3>\n<div>In March, we introduced the ability to insert <a href=\"http:\/\/workspaceupdates.googleblog.com\/2024\/03\/set-up-dropdown-chips-more-easily-google-sheets.html\">preset dropdown chips<\/a> that are configured for common use cases like priority or review statuses in Google Sheets. Today, we\u2019re adding a new feature that helps you quickly convert ranges of data into dropdown chips in bulk.\u00a0<\/div>\n<div><\/div>\n<div>If you have a column of data that includes a variety of data values (e.g., different project statuses like on track, paused, completed), Sheets will show a  \u201cConvert to dropdown chips\u201d suggestion when you click into your data range. By hovering over that indicator, you can preview the suggestion and then convert to dropdown chips in one click.\u00a0<\/div>\n<div class=\"separator\"><a href=\"https:\/\/blogger.googleusercontent.com\/img\/b\/R29vZ2xl\/AVvXsEhxaGF1h6dGpHs1m4W0JZpyEoM8ytHwv_qXcLv5PqDDWlnJcLCoAWg9n12318lGMwc9LNNniwajhHogq630Cr_FrCNklBZWb2ZS0OxzYg2uF1omd9Th1UUbuHfjQxeztUwNZqAesut3tOtU6vT6J_FWCUUwY5BjVsr51JURrlaNlncIkNa0yUUyOMlvzRQ\/s1600\/Easily%20convert%20data%20to%20dropdown%20chips%20in%20Google%20Sheets.png\"><\/a><\/div>\n<p><\/p>\n<div><\/div>\n<h3>Getting started\u00a0<\/h3>\n<div>Admins: There is no admin control for this feature.\u00a0End users:\u00a0To insert dropdown chips on your own, type \u201c@\u201d followed by \u201cdropdown.\u00a0To turn off this feature, go to Tools &gt; Suggestion controls &gt; (deselect) Enable dropdown chip suggestions.\u00a0Visit the Help Center to learn more about <a href=\"https:\/\/support.google.com\/docs\/answer\/12319513?hl=en\">inserting smart chips in your Google Sheets.<\/a><\/div>\n<div><\/div>\n<h3>Rollout pace\u00a0<\/h3>\n<div><a href=\"https:\/\/support.google.com\/a\/answer\/172177\">Rapid Release domains<\/a>: Extended rollout (potentially longer than 15 days for feature visibility) starting on May 7, 2024, with expected completion by May 30, 2024<a href=\"https:\/\/support.google.com\/a\/answer\/172177\">Scheduled Release domains<\/a>: Gradual rollout (up to 15 days for feature visibility) starting on May 30, 2024\u00a0<\/div>\n<div><\/div>\n<h3>Availability\u00a0<\/h3>\n<div>Available to all Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google accounts\u00a0<\/p>\n<h3>Resources\u00a0<\/h3>\n<\/div>\n<div><a href=\"https:\/\/support.google.com\/docs\/answer\/12319513?hl=en\">Google Help: Insert smart chips in your Google Sheets\u00a0<\/a><a href=\"https:\/\/workspaceupdates.googleblog.com\/2022\/05\/table-templates-and-dropdown-chips-for-google-docs.html\">Google Workspace Updates Blog: Use new table templates and dropdown chips in Google Docs to create highly collaborative documents\u00a0<\/a><a href=\"http:\/\/workspaceupdates.googleblog.com\/2024\/03\/set-up-dropdown-chips-more-easily-google-sheets.html\">Google Workspace Updates Blog: Set up dropdown chips more easily in Google Sheets<\/a><\/div>","protected":false},"excerpt":{"rendered":"<p>What\u2019s changing In March, we introduced the ability to insert preset dropdown chips that are configured for common use cases like priority or review statuses in Google Sheets. Today, we\u2019re adding a new feature that helps you quickly convert ranges of data into dropdown chips in bulk.\u00a0 If you have a column of data that [&hellip;]<\/p>\n","protected":false},"author":0,"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-987516736","post","type-post","status-publish","format-standard","hentry","category-noticias"],"acf":[],"_links":{"self":[{"href":"https:\/\/workspace.trace.pt\/fr\/wp-json\/wp\/v2\/posts\/987516736","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/workspace.trace.pt\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/workspace.trace.pt\/fr\/wp-json\/wp\/v2\/types\/post"}],"replies":[{"embeddable":true,"href":"https:\/\/workspace.trace.pt\/fr\/wp-json\/wp\/v2\/comments?post=987516736"}],"version-history":[{"count":0,"href":"https:\/\/workspace.trace.pt\/fr\/wp-json\/wp\/v2\/posts\/987516736\/revisions"}],"wp:attachment":[{"href":"https:\/\/workspace.trace.pt\/fr\/wp-json\/wp\/v2\/media?parent=987516736"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/workspace.trace.pt\/fr\/wp-json\/wp\/v2\/categories?post=987516736"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/workspace.trace.pt\/fr\/wp-json\/wp\/v2\/tags?post=987516736"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}