In version 1.1.0, I added a few dynamic ranges that are used to populate the customizable drop down lists used for the Status and Priority columns. To edit the conditional formatting rules in this worksheet, go to Home > Conditional Formatting > Manage Rules and select 'This Worksheet' from the drop-down.

You can also delete one or more of the columns if you do not need it. For example, if you prioritize your tasks in chronological order and something changes, you need to rearrange your spreadsheet rows and possibly adjust formatting.The Vertex42™ To Do List template allows you the flexibility to use whatever codes, scales, or abbreviations you want for each of the columns. It’s also not always easy to make changes. A spreadsheet doesn’t offer a good solution for this. You don’t want to over-complicate your spreadsheet-based task tracker with each of those smaller items, but you also don’t want the person assigned to the task to forget those steps. In order to complete the task, the person it’s assigned to must collect visuals from the design team, get data from your analyst, and they must have it reviewed by the legal team before it’s considered complete. Say you have a project task listed on your spreadsheet.

On a spreadsheet, tasks are reduced down to line items with limited functionality when the complexity of those tasks would benefit from the ability to include additional context and information. That’s because it lacks the features and flexibility your team needs to be at their productive best. Simplicity is good, but when it comes to keeping your team moving forward and collaborating on tasks, a spreadsheet is too pedestrian.

Todo list excel