There’s a tracking app for almost everything today. Each comes with their own unique features and UI/UX. However, sometimes simple is the best way to go. Google Sheets is one of the easiest and most effective ways to build and manage your to-do lists. The app is simple and easy to use. And while there are various types of to-do list apps, few are as intuitive and simple as Google Sheets. Another great bonus point of making a to-do list in Google Sheets is it’s easy to sync your list with your other G-suite apps and maybe some other software.
There are numerous benefits of making a to-do list in Google Sheets but here are some of the top ones.
Here’s a simple two-step process to create a to-do list in Google Sheets.
You’ll notice that the template comes equipped with:
You can customize all this information and also the look and feel of the to-do list as per your needs.
There you go! Making a to-do list using Google Sheets takes less than five minutes if you opt for the existing templates.
Of course, you do have the option to customize this to-do list to make it look like your own. For example, you’ll notice that when you click a checkbox, the task automatically crosses out and the cell color changes to grey. This is done via ‘conditional formatting’. To see this rule, click on ‘Format’ and then on ‘Conditional Formatting’.
Clicking on that will open up the rule for you to see or edit.
To change/customize this rule, click on it and it will expand. Here you can change the color by clicking on the “color” icon. You can remove the strikethrough if you don’t like it or you can change it to bold, italics, or underlined as per your preference. When you’re happy with the edits, click on “Done”.
You can make your to-do list a lot more personal and efficient by modifying and customizing it. Listed below are ways you can use to customize your to-do list and make it more efficient.
You have the option to edit and use your to-do list offline without downloading it. To do so, you just need to enable the functionality on your Google Chrome Browser. Here’s the step-by-step process for the same.
This will allow you to access your to-do list offline, for example, when you’re on a plane or on the road with limited internet access.
You can freeze a particular or multiple rows or a column so that every time you scroll, that row or column will never go out of view. For example, you can freeze the top row so that when you scroll down to see your tasks, you’ll know which column is for what.
Follow these steps to freeze rows and columns:
Step 1: Select the row(s) or column(s) you want to freeze.
Step 2: Click on ‘View’ in the top menu.
Step 3: Select Freeze > 1 row or 1 column to freeze any one particular row or column.
To freeze more than two rows or columns, in the freeze menu, click on “Upto Current Row (x) or Upto Current Column (x)”. The ‘X’ would be the row number or column number in which you have selected the cell.
Hiding rows or columns makes it easy to focus only on things that you want to see. For example, in your to-do if you want to permanently hide a particular task that is no longer relevant, you can do it by following the following steps:
Step 1: Select the row(s) or column(s) you want to hide
Step 2: Right-click on your mouse
Step 3: Select the “Hide” option
Hiding particular rows and columns is different than deleting. In the former, you can still access that information; it’s only hidden from your current view. Whereas, in the latter, you delete the data completely.
One of the key reasons for choosing Google Sheets to make a to-do list is the ease of use. You can easily connect your spreadsheet to other apps and sources, it’s easy to create, customize, and access. You can also share it easily and manipulate the information on it in various ways. Few physical and digital to-do list apps provide this kind of flexibility.
If Google Sheets seems too hard to keep updated, then you can use Friday.
Get a personal command center that can help you get the most out of your workday. With the daily planner, you can sync your calendar and your task list alongside your daily meetings. With Friday, you’ll have clarity on what you need to accomplish next.
Pull tasks from the task management apps you already use, like Asana, Todoist, and Trello.
That way you stay above the nitty gritty project management details and can focus on the actual tasks that need to be done.
Friday also has a Posts feature, where you can write out announcements, ideas, meeting notes, and more. By connecting to other task management apps, you can easily insert your tasks into your daily schedule to make a great to-do list.
Friday has everything right there for the day.
Start your free to-do list and roadmap your day in Friday.