{"id":524144,"date":"2022-12-09T19:57:38","date_gmt":"2022-12-09T16:57:38","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/google-sheets-is-adding-colorful-chips\/"},"modified":"2022-12-09T19:57:38","modified_gmt":"2022-12-09T16:57:38","slug":"google-sheets-is-adding-colorful-chips","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/google-sheets-is-adding-colorful-chips\/","title":{"rendered":"#Google Sheets Is Adding Colorful \u201cChips\u201d"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a42c9fa76804\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a42c9fa76804\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/google-sheets-is-adding-colorful-chips\/#%E2%80%9CGoogle_Sheets_Is_Adding_Colorful_%E2%80%9CChips%E2%80%9D%E2%80%9D\" >&#8220;Google Sheets Is Adding Colorful \u201cChips\u201d&#8221;<\/a><\/li><\/ul><\/nav><\/div>\n<h1><span class=\"ez-toc-section\" id=\"%E2%80%9CGoogle_Sheets_Is_Adding_Colorful_%E2%80%9CChips%E2%80%9D%E2%80%9D\"><\/span>&#8220;Google Sheets Is Adding Colorful \u201cChips\u201d&#8221;<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<div id=\"post-853886\">\n<div class=\"entry-content e-content\">\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-731650\" data-pagespeed-no-defer=\"\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-logo-yellow-gradient-hero.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Google Sheets logo with a yellow gradient background.\" width=\"1200\" height=\"675\"\/><\/p>\n<p>Spreadsheets are useful for a lot of things, and among those uses, there\u2019s project\/task managing. Google Sheets is one of the most easily accessible and useful spreadsheet services, and now, it\u2019s getting a little friendlier for task management purposes as well.<\/p>\n<p>Google has announced that Sheets is gaining support for dropdown chips. You can add dropdown chips to cells within your spreadsheet and assign different colors, serving as an additional visual indicator and letting you know the status of something at a glance. In a way, they look very similar to the dropdown chips that are used often in proper task-managing services like Asana and Airtable.<\/p>\n<figure style=\"width: 640px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-853895\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/12\/dropdownshipsinsheets-650x382.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"\" width=\"640\" height=\"376\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><figcaption class=\"wp-caption-text\"><span class=\"imagecredit\">Google<\/span><\/figcaption><\/figure>\n<p>The workflow for creating these chips, and all other data validation rules, has also been changed.\u00a0Now, any rules that have been established in a certain Sheets tab may be seen, edited, and new rules can be added from a sidebar view.\u00a0According to Google, this workflow is now similar to how you establish rules for named ranges, protected ranges, and conditional formatting.<\/p>\n<p>It\u2019s important to point out that Sheets <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/support.google.com\/docs\/answer\/186103?hl=en&amp;co=GENIE.Platform%3DDesktop\">already had support for dropdown items in menus<\/a>. If anything, this seems to be building on top of that by making those dropdowns easier to create, as well as adding the colored \u201cchip\u201d visual element \u2014 as of right now, they were pretty much just text items.<\/p>\n<p>This feature is rolling out now, and it should be available on everyone\u2019s Sheets within the next 15 days.<\/p>\n<p><small>Source: <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/workspaceupdates.googleblog.com\/2022\/12\/drop-down-chips-google-sheets.html\">Google<\/a><\/small><\/p>\n<\/div>\n<p><!-- .entry-content --><br \/>\n<!-- .entry-footer --><\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/853886\/google-sheets-is-adding-colorful-%E2%80%9Cchips%E2%80%9D\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;Google Sheets Is Adding Colorful \u201cChips\u201d&#8221; Spreadsheets are useful for a lot of things, and among those uses, there\u2019s project\/task managing. Google Sheets is one of the most easily accessible and useful spreadsheet services, and now, it\u2019s getting a little friendlier for task management purposes as well. Google has announced that Sheets is gaining support&#8230;<\/p>\n","protected":false},"author":1,"featured_media":524145,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google-sheets-logo-yellow-gradient-hero.png?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-524144","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/524144","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=524144"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/524144\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/524145"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=524144"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=524144"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=524144"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}