All right. At the top of our CRM or anywhere in a sheet, you want to add some kind of like weekly progress bar . I think this is a fun thing to do because we have this um automatic updating of the day, which is today, but we can wrap this with weekday. When we wrap it with weekday, it becomes a number 1 through 7. It's seven right now because it's Saturday, but on Sunday, it'll be one. On Monday, it'll be two, etc. So we can use rept repeat some text. So let's use a checkbox to repeat that seven times. And then we can add and so we need to end parenthesis then and repeat some other thing like which is going to be I

think a blank. Let's do a blank square. It's a blank square like this. And how many times are we going to repeat that? Well, we need the exact same formula this weekday today, but we do seven minus this. And at the end, we'll have seven check boxes. However, if this weekday today, I go in and I replace it with let's say the number three and also weekday today will be three. It'll look like this. So, it's checking off every day of the week. It'll have this check box and it'll show you what day of the week it is. sort of visually instead of just saying Monday, Tuesday, Wednesday, Thursday. Now, if I wanted to change in

here how it represents the weekday, I have some options. So, it is an optional and it's by default counts starting by Sunday. But now we can put a number indicating which number system to use to represent weekdays. And let's go look at it here on the right side in this help. If type is one, days are counted from Sunday. So the value of Sunday is one. If it's two, the days are counted from Monday. Type three, days counted from Monday, but the value of Monday is zero. So that's very different. If the type is 11, days are counted from Monday and the value of Monday is is one. So we need 11 in there. They say that Monday is one and Sunday is seven. So I think I'm

going to do that for now. So do 11. So, comma 11. And there I think is more intuitive that today is Saturday. So, we still have one day left of the week, quote unquote. Monday is day one. Sunday, the last check is Sunday. So, that's really interesting. I think if you're trying to make a little progress bar showing the days of the week and now you learned a little bit about weekday, check out the character playground . It is thousands of fun formulas that you can add to your sheets. Everything from Star Wars to Lord of the Rings to trackers to pickers to timers to counters. All types of stuff that plays around with characters inside of your sheets. If you want to

search through all kinds of characters, just go to betterheets.co/ char ch and you can look through all kinds of emojis. You can copy the formula ch and the exact number that it is inside of sheets. You're watching Better Sheets here on YouTube. You have two options here for your next video. Before you go, comment down below if you have any question whatsoever and I'll make future videos from those questions. But for right here, right now, one of these videos could be your next Google Sheet.