How To Plan An Event's Day Based on Individual Schedules

0:00 We want to figure out which days are the best to do practice or plan any kind of event on a specific day. And we have a bunch of people that want to say yes or no or sometimes to this. And we've created this rubric, I would say, which says each person should fill in their own personal yes sometimes or never on each person, on each day. And then at the top we have and at the top we have a heat map that shows us Generally speaking, what are the better days, and which days to avoid. So let's build this from scratch. We're going to need a header row . We'll make it dark here, and we'll make it here. We need a name. We need Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, and Sunday. You can also augment this. You can put more things here if you want to break up morning, evening. Let's delete the extra rows. Let's delete the extra columns. And fill in a few names. Create a 2x2 Priority Matrix Automatic Weekly Calendar View

0:46 There. We're going to create a drop down menu for each one. Drop down. First one is going to be yes. Then sometimes. We want to add another item. Never. We want to color code these yes, green, sometimes yellow, and red for never. Never. Click done. We can then copy and paste this all the way down. It's actually delete some extra rows and let's fill it out. What I like to do here though is make sure that it, what I like to do is I don't like the chips, so I'll change these all to arrows done. I will actually also center everything up. both vertically and horizontally. So let's fill in a few of these. Let's make some sometimes. Give it a little bit more space. And let's start counting. So we're going to have yes at the top. Sometimes and then never. And then never. Here we're going to do equals count if, and we're going to Create a Self-Adding Dropdown Menu Are Google Sheets sexy now? Dropdown Chips might do the trick! Create Dropdown Menu

1:34 count the range of B5 colon B. The criterion is going to be A. Just clicking A1. Now, we want to copy and paste this all the way down, so what we're going to need to do is, we are going to hold the A column, so we're going to put a dollar sign in front of the A. And we also want to put a dollar sign in front of the five here because we don't want the first row to change as we copy paste it. So now as we copy paste it, we can see that this is the exact formula we want. We want, yes, sometimes calculated here, and the B5 is also staying. So copy paste that there, and copy paste that all the way across, and then copy paste all of them. So now we have our numbers. We have three yeses here, two yeses, you can see this going. Let's fill in a few more and add some nevers. So we can see that's working as well. Now for the heatmap . Move Cells to New Row with Formula Figure Out Frequency of Numbers Count First Digit of Cell

2:20 Let's give everything a little bit more space. We're going to select just the yes and sometimes rows for now. We're going to go to format , conditional formatting . And instead of a single color , we want a color scale . We want to click on the add. Default format of this coloring. We just want to make sure that it is white to green. Cause we want the highest number to be the darkest green click done. Then we're going to, then what we want to do is select the never add another rule. Make sure that it is the correct range we're applying to. And again, go to color scale, but click on the green color scale here and change this to white to red because we want to show up the darkest red as nevers. And that is our max value here. Click done. So as we select maybe some more nevers here, they will automatically come up red, and the darker red is going to be the days to avoid, and the Brighten Up Your Checklist Automatically The Simplest Bestest Checklist in Google Sheets IF All Above Are Filled Conditional Formatting

3:09 darker green is going to be the days that where most people can avoid. Practice or join an event or something like that. We just have, and that makes it really easy for each individual person to give their own schedule, but be able to analyze this objectively from the top, just an overall number . And that's how you get event days or schedule an event based on people's attendance ability.