You have a large group of people going on vacation and you're still trying to decide where to go. This video is going to help you decide. It's gonna give you some cool little formulas. Even if everybody has a veto or you need at least one person to say yes to shortlist this, or you need a minimum amount of people in order to say yes, approve, whatever you want, I'm gonna show you different ways to do that And I'm going to do something with checkboxes that I don't think you ever knew you could do All right, let's say everybody has a veto, and if at least one person says no or checks this box, then we're gonna say no. So we're gonna use equals if, and here we're gonna say or, and then the logical expression is going to be all of these, so this comma, this Magical Things You Can do with Checkboxes in Google Sheets How To Hide Data with Checkboxes in Google Sheets Votes for Approval

All the way to M2. And what's gonna happen is, or is a logical expression that's gonna say any of those are checked, then what? Well, we're gonna say value of true is nope, and value of false is maybe. Maybe when we're trying to, like, shortlist this or something So the moment somebody says nope, it's noped. Okay, what if we want to say if anyone votes for this, then put it on the shortlist? Okay, we're gonna do equals Actually, we can just copy-paste this whole thing because all we have to do really is change and flip the value of if true or false. So short list and then if false One Million Checkboxes 5 Magical Ways To Use the IF() Formula in Google Sheets Votes for Approval

We're just gonna leave blank. So now as long as one person checks off, great, we got it shortlisted And but what if we need a minimum number of people to vote for it? So here what we can do is equals IF as well, and we're going to have some logical expression that will resolve to true or false. In this case, I'm gonna say COUNTIF , and the COUNTIF is gonna be C4:L4. And our criteria is gonna be true. We're counting all of the trues. And then we're gonna put a greater than two, and that means if at least three people check off, then it's gonna be true. So we can shortlist th- that. . Three people at least. So even if more people, great. Ken Asks: How can I count true and false? Answer: w/ CountIF() How can I count true and false? Votes for Approval

So what if it needs to be everyone? Well, we can take that count if, and we can say how many are here. This needs to exactly equal 10. And if everybody In here in the fifth row, if every single person votes for this, then it's on the shortlist, or in this case, it could be approved. And we put a comma here so that if it's not, what do we wanna say here? Well, we could say anything we want, or we could say nothing at all. We could say nope, and it turns a nope into a yep, approved I wanna show you one really cool trick that I think has changed my perspective of checkboxes completely. In this version, we're counting if true, but we can actually 6 Ways to Make Your Checkboxes Better How to Use Checkboxes for Approvals, and Change the Checkbox Text Votes for Approval

change the value of a checkbox . Right now, if I check a checkbox , it goes from false to true. Inside of a cell is just true or false. It's just text essentially. Well, I'm gonna select all of these check boxes, right click, and I'm going to view more cell actions and go to data validation M- I'm gonna click uncheck box. And here it says criteria check box, and it says use custom cell values . I'm gonna click that and change the checked to one and unchecked to zero I'm gonna make sure we're only on C6 to L6 for this example So we're on C6 to L6, criteria checkbox , use custom cell values one and zero, and click Done. 6 Ways to Make Your Checkboxes Better How to Use Checkboxes for Approvals, and Change the Checkbox Text Create a Radio Button From Checkboxes Using Google Apps Script Checkbox or Dropdown?

I do not want to apply to all for now, but you might want to if you're trying to do it for all of them. So now we can see up here in the formula bar that it is a value of one or zero. This is really cool because we can now sum this range C6:L6 And now we're going to get a number . Then we can easily say if the sum of that is greater than or equal to three, then true shortlist, comma nope And there, if we have one or two, it's noped until we have more than three. Really cool, right? I think this cell value changing has been awesome. You can change it to different kinds of text, approved, not Find a Value in a Range Equal, Equal, Not Equal, Not Equal - How to Tell if Two Cells are the Same or Not The Same IF All Above Are Filled Conditional Formatting

approved, help, no help, yes, no. And it can still be accessed by a user with just a single checkbox . But why I like dropdowns is because there is a null state, meaning there is no answer and somebody has to click no for it to show up. But I'm actually going to change these 'cause I don't like the pills To advanced options and change it to plain text And now I have no, I have yes, but I also have a third option which is nothing at all. That's null So this is great because then you have to see who actually voted for this or not. Did somebody vote no or vote yes or didn't vote yet? So in some instances for your vacation, you may want to use Frustrated With Sheets New Dropdown Pills? How to Use Checkboxes for Approvals, and Change the Checkbox Text Votes for Approval

any of these or all of these. Maybe there are some destinations that you're like, "We need at least half of the people to say yes to." Or there's some that you're like, "At least one person, we'll shortlist this and put it on another list to get approved." Or you wanna definitely see, without a checkbox , with a dropdown , you wanna see who actually voted for th- these things You're watching Better Sheets here on YouTube. Watch this video or this video. It's gonna make your Google Sheets better Go ahead, ask me anything down below in the comments . And I'm going to answer it in a future video become a member of Better Sheets today. . You get videos, you get sheets. So what do I have to do to get you into a brand new Google Sheet? go check it out Better Sheets Videos Checklist Absolute Basics of Google Sheets Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets. Better Letters