Google sheets week number code#

Google sheets week number code#

As you can see, you can also use a code to capture minutes spent doing non-running activities, like lifting or cross-training. You can use these or create codes of your own. If you’re not sure what codes to use, select the Constants and Legend tab to see what all of the acronyms in the sample spreadsheet mean. It’s a 10-week training log where you can quickly type the distance and the type of run you had on that day. Marathon Training Schedule is tailored for runners who are training for a marathon. The entries are simple and quick to make. This is one of the best workout templates for running because you can open it up in your mobile Google Sheets app.

You’ll see tabs that summarize mileage, pace, race types, and more. The Miles columns will fill out automatically, showing you the accumulated miles you’ve run this week, month, year, and since you started logging (Life).Ĭlick through the tabs of this spreadsheet to see all of the visuals Mike has created for you. Select this box (in the copy you saved to your own account) and press Delete on your keyboard to remove it.Īs mentioned above, LogRun includes the main characteristics of a run that most runners like to track. In this particular template, you’ll see a pop-up window advising you not to use the original. Save the file in a folder in your Google Sheets account, and give it any name you like. If you like the template, select File and select Make a copy.

Note: As with all other Google Sheets workout templates listed in this article, you can’t use the original. It’s a middle-of-the-road Google Sheets workout template that includes the most important aspects of your run. LogRun is a Google Sheets running log template created by Mike Kasberg. Other runners prefer to log everything from average pace, run difficulty and even notes on how they felt during the run. Many runners are pleased just logging mileage and time. Runners like to log their runs in different ways.

Just scroll to the section that matches your needs, and choose the right template for you. You’ll find these organized into categories based on the type of fitness goals you’re focused on. In this article, we’ve hand-picked the best Google Sheets workout templates available. There are plenty of Google Sheets workout templates available online to help you get started. Thankfully, you don’t have to start from scratch. Include only the exercises and workouts you need, and remove everything you don’t. But, we can solve this very easily using the CHOOSE function.With Google Sheets, you can customize a workout that fits your goals perfectly. There isn't any built-in function that performs this task in Google Spreadsheets right now. I needed to fill cells with the day of the week given a date. Basically, it allows one to select an action/value based on some input. Google Spreadsheets has a nifty function named CHOOSE which exhibits behavior like the switch statement programmers all know and love. But don't use it for getting the day of week anymore! The old post from follows below and is a great introduction to the CHOOSE function. As noted in the comments, there is an even much easier way to do this now!Īt some point Google updated the text function to take formatting parameters which makes this a cinch.