Naughty or Nice? - Google Sheets' New Dropdown Chips

<div>0:00 So you're trying to apply naughty or nice to a list of names and you don't want to type in naughty or nice.<br>0:08 Well, you can use now Google Sheet's new dropdown interface in order to select this. So let me show you. This just rolled out very recently.<br>0:18 We go to insert and we can insert a dropdown . Now over here we have some options. Are Google Sheets sexy now? Dropdown Chips might do the trick! Button Styles Select Random From List in Google Sheets

The moment that you apply this dropdown , it only applies it to B one, but we can actually change this right here, apply to range B one to B or B, colon B, and it'll apply to the entire range .<br>0:36 The entire column and the dropdown options are gonna be naughty. We just changed this to naughty and we changed this to Nice.<br>0:44 And the cool thing is that instead of doing dropdown plus conditional formatting , we can actually do that right here in the dropdown menu.<br>0:54 We can say naughty and nice and we can color code these right away and we can hit done. Are Google Sheets sexy now? Dropdown Chips might do the trick! How To Color Code Rows Based on Drop-down Value

And now we have this pretty cool interface that has rounded corners.<br>1:03 This looks a lot like Air Table , doesn't it? Pretty cool interface. Pretty new, different way to do dropdowns now in Google Sheets.</div> Are Google Sheets sexy now? Dropdown Chips might do the trick! Gmail Declutter Engine How to Change Dropdown Colors and Gray Out Rows in Google Sheets with Apps Script