all right so in this video I'm going to cover the new drop downs we have in Google Sheets so
let's just get started with this example so I got this cell right here I want to
make a drop down here between yes and no so the way you can do that you click on a cell
you either go under insert and go drop down or you can go under data and data validation and
it's gonna roughly take you to the same spot so I'm just gonna go under insert and do drop down
and this is what's gonna show up so here I'm gonna type the option so I'm going to do yes
and no and to each one you can give a different color if you want so I can open this and choose
say yes to be like this color and no to be this color and then if you wanted more options
you click add another item and do that option obviously which I don't really want so if you
go on the right side of this you can remove this there might be some sort of trash can here that's
invisible for me at least but just know that on this right side we have the remove so I'm
going to go ahead and remove that because I don't want that now under this Advanced options we have
options to show warning if there's something else entered in the cell or just reject any other input
I don't want anything else to be entered in the cell so I just want the Sno so I'm going to do
that and then you got display style so you got chip arrow and plain text so Chip is what I'm
gonna do I'll show you what the Arrow does to in just a second so I'm going to do chip hit done and
what's going to happen now if you just take a look right here now I got this little what's called a
chip you can open that that gives you yes and no see with those colors I chose so if I hit yes I
got yes if I hit no I got no if you want to clear the cell you will have to just click on the white
space here and press delete on your keyboard and that should clear that selection so at this point
we got our yes and no so now I can work off of that so for example I could say if this equals yes
then maybe we want to do like 50 bonus otherwise we do zero bonus something like that
let's see if I can zoom in a little more here and that's my formula and then at this point I can
create my total I can say take this Plus this so at this point this says yes so we get 50 bonus if
I switch this to no that will basically do bonus zero you'll get your update so that's your drop
down as you can see pretty straightforward so if you want to go back and modify this you can click
on this go to data and go to data validation and that brings you to this which shows you
what validations you have applied and this is the one I did for that cell B2 so if I click on this
it goes back to the same menu you can now go back here add more options modify this Etc and if I go
to Advanced options here if I switch from Chip to Arrow so you can see what happens basically it's
not going to do that Circle chip it's basically just a cell like this with a drop down uh between
yes and no like that and as you can see that works just fine I'm going to zoom out to get to
this so as you can see we can also open this and click on this little pencil that also takes you
to the same spot to modify this so all of that is the same and if you want to just get rid of this
you can just hit remove rule and that should just remove that drop down with the validation and just
to show you what happens with that validation if I just undo this if you do have that validation in
place and you have the drop down if you remember I chose the option to reject any other input which
means if you try to for example enter something like other it will basically reject that input and
won't let you enter that so the only things I can have here is yes and no because I chose the option
here to reject any other input now if you do warning it will let you type
other things but it will give you a little warning so that's that now the other thing
I want to show you here is that you can also do this validation for a whole range so for
example if you have a table like this and you want to add a column let's say status
and I'm going to go ahead and apply the same color coding here with the
paintbrush here so here I can just select this whole range and go to insert and do a drop down
and basically you just choose your options right maybe you want status like shipped
you want pending and you want another one like canceled
something like that and then under Advanced options if you want to change any of these
other options you can I'm just going to leave it as is hit done and there it is
for this whole range now we have those drop downs to choose from between shipped canceled
and pending and it will change the color based on the selection based on what I did here and
then obviously you can go back and change that option by going under data and data validation
that brings the same menu you can open that validation and start making any
necessary changes you may have now finally the last option I'm going to cover here is
that these options you do like in this case I did like ship pending canceled right now I did
hard-coded options from this list I just type but sometimes you might want to do something
different let's say you add a tab here I'm going to call it options and here we can just
add those options we're thinking of so let's say I want shipped pending and then canceled
then I'll just call these options this top one which you don't need really but
I'm gonna do that anyways so what you could do when you do your validations
so I can go back here I'm going to do that separately here I'll do status again
and basically here I'm going to select this range go to insert and do drop down
but this time instead of doing the regular drop down here I'm going to switch this to drop down
from a range and when I do that it's going to ask me where's the range so I can click on this
click here go to that options and highlight these three options so if I okay
that does this see it picks up those options from that list and again you could choose your colors
for these different options and we could also go under Advanced options and change
all the settings like you usually can now I'm not going to do that but what I am going to
do see how this goes from A2 through A4 I'm just gonna remove the four like this
and that's going to send it all the way down in that a column so I'm going to hit done so right
now I'm at the options tab I'm going to move back to this tab where I was doing the validation and
you can see here I got my validation options and I got shipped pending canceled it looks like at some
point I lost the color when I was making changes we'll go back and fix that in a second but right
now you can see these options are basically coming from this options list so if I go here and change
some of this and maybe instead of shipped and pending I got shipped and packed so if I go back
you'll see that now this automatically updates to Pact and then I can go back and add Maybe
more options here like pending and you can see that should automatically now also show up in
this list of options and if I go back and modify this see I'm gonna repopulate some colors here
and as you can see because I just clicked on this for cell and it knows that we have all these drop
downs here that have the same validation it's basically just asking us do you want to apply
this to all of them or just this one so I want it for all of them so I'm going to do apply to all
and you can see we got our options here shipped packed canceled Etc
and yet again if you just go here and type like other as another option go back to this
you should be able to see that option pops up here too and that's another way to do this validation
to use a range from the spreadsheet so if you want to be able to just come back and add more options
like this and just automatically have them pop up in the list you could do this and of course if you
want to get rid of those again you could highlight all of these go to data go to data validation
and the one I just did was this one for f column so I'm just gonna remove the rules so again there
is probably a little Trash Can icon here if you zoom out enough but unfortunately they don't have
this handled very well right now so I'm just going to click on this that will remove that validation
and with that they're all gone and that's how this drop down multi-color validations
work in Google Sheets now if you have any questions just leave them in comments and
as always thanks for watching please subscribe and I'll see in the next one