Mood, Food, Tude Weight Loss Tracker

0:00 So I wanna take this simple weight tracker and do a little bit more to it. I want to track my food, my mood, and my attitude. And I know mood and attitude probably sound similar, but let's make a copy of this and start making this really nice to use. So this is the mood, food, ' tude, weight loss tracker So the first thing we're gonna do is add some drop-down menus here. I'm not gonna add headers because we've got a really special thing going on in this weight loss tracker. If we go over to our Apps Script , we can see we are adding a new row every day and we're adding a date. So what's going on is that our dates are going to be from now and then down is going to the past. Okay? So if we, we can, we can enter a new row here, but we don't have to.

0:49 In fact, we go up to Extensions, Apps Script , and we go here and we can just run this or we can add it as a timer. I actually wanna make this a little simpler. I wanna create a function on Open that will, uh, just allow us to click New Row or even enable us to add that trigger So I'm gonna go over to bettersheets.co/snippets And here we have a custom menu , two functions . I'm gonna add that up here. What this is doing is every time we open the sheet, it's going to add this little menu and have us, give us the ability to maybe add a new row. So I'm gonna add new row here Okay, so what I've written here is a function turn on automation, and we're

1:34 gonna first turn off the automation if there is one, so we don't have double. We're going to take this new row function and add as a, as a daily trigger . This is gonna happen around 5:00 AM, 5:00 to 6:00 AM, and we need to create that turn off automation. So actually we go to here, we go this, we do function turn off automation. And here we go and find all of the triggers. For each of those triggers that's called New Row, we delete that trigger . This is the actual line of code that's doing this. And then we say, "Hey, we've turned it off." Okay, so we go to the top of our onOpen function , and we have to actually execute these two automations, but we're gonna give ourselves a nice thing.

2:21 Turn on daily automation. Actually, New… Daily New Row, I'll call it. And then I'll copy and paste this to the second item, and this is Turn Off. But I wanna add one extra thing here, which is a little icon, green and red. It's right there So we save this, and it's not gonna show up in our sheet until we refresh the sheet. So, or turn, uh, close it and open it again. And now up in our custom menu , we have add new row, which I can click that, and I think we have to authorize it the very first time we run it. Yes, yes, continue If we have any… Oh, I think we have the wrong sheet name So we had the r- sheet

3:12 name track, so let's make that work. Now let's try it again, and let's actually rename this from custom menu to weight loss Save it. Make sure that orange button goes away. Close it. Refresh And only to get that… Yeah, there's that weight loss. Let's add a new row. Now we added a new row. Perfect. But if we wanna turn on our automation, we can turn on daily new row, daily automation. Oh, I know what's going on. It said disabled first because it actually ran the other automation first. So we need to create another one that's sort of silent. So each time we run this, it's gonna give us a alert.

3:57 But if we run the turn off automation, we're gonna also get that turn off alert, which we don't want. So we create a function , copy and paste this, called silent. So we say turn off automation silent, and we just delete the alert at the end so that when we run this one, silent… So we run a turn on automation. When our turn off automation silent happens, it just happens. We could also give it a, another alert. We could say, "Oh, we've disabled all previous automations," and then another alert that says, "We have now enabled this one." Could do that. For this particular video, I'm gonna just say do it in silence.

4:43 Okay. We have now created really cool automations over here. We have our add new row if we wanna test it out, and now we wanna actually add our food and mood trackers . So we're going to have columns here, but we cannot add a header . So we need to make this very clear of what to put in which, which column. So let's put in a mood tracker. Let's just put in a dropdown I'm gonna add some emojis Good Um Tired, crying. Let's add those. Done. And I want to keep this, um, what's it called?

5:29 A drop-down pill, I think. I think. We'll move on and say let's put food here, but let's use a border instead. I'm gonna use a colored border. Let's do orange and a little thicker than we might n- normally do it There we go And we want it in the top row as well and all rows Let's add the, increase the font a little here. I do want to change it to Let's do Open Sans for now Centered. I'm gonna give it a little bit more room. So I'm gonna give each row a little bit more room. And we need to align this a little nicer in the center.

6:15 There we go. Also want to go View, Show. No grid lines is gonna be hot. Yeah, there we go. This is looking way better, way cleaner. However, we want maybe… We probably want in A and B a bit of a border Let's do a thinner border Yeah, there we go. Have something in between them just to cut them up a little bit Now we want another dropdown menu so that it's, it's mood is just an easy click. But now we want attitude. So I know mood and attitude probably sound the same, but what I'm thinking here is that mood is our internal feeling. Just a very simple good, meh, bad Our food is going to be just, you know, what did we eat today?

7:02 What are our three meals? What… Do we have any snacks? And we can write this just in McDo and muffins, really bad food. We were feeling very down. And now our attitude is going to be more about our feelings towards others. Let's add a drop-down menu We'll write at the top upbeat, then we'll say calm, then we'll have stressed, annoyed We might also add restless here, and we wanna add some nice colors. Calm might be blue, stressed might be orange, annoyed might be red, restless might be purple or something like that. Let's click Done, and copy and paste this down.

7:50 Again, this is sort of just me setting up this for myself. However, you can add interesting little things here. And what I like about it is that it's going to have sort of a heat map of, of sorts. Um, and I wanna add one extra little thing that might seem really cute, but it's going to help us a lot. Based on this word over here in the E column, I wanna highlight the whole row , because I want it to really look or l- look like a heat map and say, well, how do we really feel day to day, where we, we were annoyed, we were calm, we were upbeat, upbeat, calm, then annoyed? And is that, like, a pattern for certain days of the week

8:36 or what we're eating maybe? Or are we eating based on our feelings? That kind of thing. We wanna be tracking this, right? But we wanna be able to quickly come in here and see, okay, yeah, that's… Yeah, that's me. All right. So I'm gonna select E, Format , Conditional formatting . I'm gonna apply this range A to E, and then I'm going to say Custom formula is equals E1 equals Annoyed. And I'm gonna put a dollar sign in front of the E, and not, not the 1, just the E. What this is doing is saying gl- all of these columns look in the E column, is it annoyed? And if so, let's pick this pink.

9:22 Done. Add another rule. Do exactly the same thing, A1, E, Custom formula equals $E1 equals Calm, and you can see here we're going to just do… Is that the same… different blue? It's such a tiny different blue, it might make you annoyed. Some people it might make annoyed. Do the same thing, A, colon, E. We can do A colon E here. Custom formula is equals $E1 equals Upbeat, and we can do this for each and every one of them. If you wanna add more, you can add more here. Very simple to set up.

10:08 And now if we switch this to Calm, the whole row is colored. I don't necessarily like this orange anymore for the border, so I'm gonna change it. I'm gonna change it a little bit, a little bit smaller. I want to do maybe a gray, to be honest. And hon- honestly could do without and it would look super cute still. I don't have to do anything. I just know, okay, food column is here. And usually I'm going to say you should not have no headers . However, if we're using this every day, we know we're putting our weight here, our date here, and we're copying all this stuff. So let's see how the new row is going.

10:54 If we're adding a new row and the date, is it, is all of this stuff moving with it? What's that? Let's see. And yes, we have our drop-downs. We have our feelings. And yes, it's all working and all we have to do now every day is add in A1 our weight. So we probably did not do very well with that McDo. So we are a little annoyed today still. That did not help, right? But… Oh, maybe this is the 14th But this is really cool. This is going to help us track our mood, food, and attitude while we are tracking our weight loss, and it's give us, giving us a lot of stuff to do in the sheet

11:40 without just putting in one little number . But it helps us keep our hunger levels at bay. It helps us see what is our heat map throughout the week. This is gonna become a really, really cool asset for you if you're trying to use this as a weight loss tracker. Enjoy. 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