Votes for Approval
In this video, learn how to effectively use checkboxes and dropdowns in Google Sheets to manage group approvals, including techniques for counting votes and setting custom checkbox values.
If you ever needed the approval of a group of people, you're gonna like this one. We're gonna go over different situations...
Now, what if we wanted all of these and only all of these checked so that we actually get a yes...
So what if we want most of these to be yes or true? 'Cause these check boxes are just true or false...
to t- to three means we have an approval. So we say if, and now this count if is greater than or equal to three...
Voting for it is true. So really, what you might want to do is have a vote to show that somebody voted either yes or no...
click here and do yes or no. So I'm gonna copy and paste these And so now we have yes or no or nothing...
And now if we change it to yes, we have a count, and that count is gonna be one, two, three, four, five...
If we wanna make sure it's a majority in this particular case, it's greater than two or greater than or equal to three...
I'm gonna add a rule. I'm gonna make the range D7 JD6, sorry, to H6. And the criteria will be checkbox...
If I click on it, it's 1. So now instead of having this or or and, We actually can do sum of these if we want...
You probably didn't know it was even a possibility. You're watching Better Sheets here on YouTube...