Forum Discussion
To do List with Columns
Hello
I have this idea for a to do list but I cannot find anything relevant on google.
So the idea is to separate the tasks in to 4 columns because over time each of those sections will have 100+ entries and it will make it easier for others to see what task is already in the spreadsheet and what task is not. Yes this can also be done with a normal table and just filter the selection/cells but in my experience people never use that function of the tables.
So I was initially thinking that I could make a cell swap columns with a simple dropdown list but I had no luck with that. And the only similar thing I could find in google was a VBA macro to move entire columns.
So I am asking a question here to see if there is an obvious thing I am missing before I spend days creating some macro to make cells swap with a status change 😄
Thanks
Gatis
If I understand correctly, you want to create a to-do list with tasks categorized into different columns, and you're looking for a way to easily move tasks between these columns. Here's a suggestion without using VBA:
- Create a Table: Start by creating a table for your to-do list. Select the range of your to-do list, and go to the "Insert" tab and choose "Table."
- Add Status Column: Add a column named "Status" to your table. In this column, you can use dropdown lists to indicate the status of each task (e.g., "To Do," "In Progress," "Completed"). You can create a data validation dropdown list for this column.
- Filter Table: Use the filter options in the header row of your table. Users can filter tasks based on the status column, making it easy to see tasks in different categories.
- Click on the filter icon in the header of the "Status" column.
- Select the status you want to view (e.g., "To Do").
This way, users can easily filter tasks based on their status without having to scroll through the entire list.
- Sort Table: You can also sort the table based on the "Status" column. This way, tasks with the same status will be grouped together.
- Click on the filter icon in the header of the "Status" column.
- Choose "Sort A to Z" or "Sort Z to A" based on your preference.
This approach doesn't involve moving entire columns but provides a dynamic and user-friendly way to organize and view tasks based on their status. Users can quickly filter and sort tasks without needing to understand or use advanced Excel features. The text was revised with the AI.
Additional Link: Microsoft Templates for todo list
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.
- Hi NikolinoDE
Apologies for the late reply.
I already have a few lists where there is one big table and you can filter the selections.
But the big problem is in a team of 30+ people not everyone does. Even if they know how to do it. So you just end up with many duplicate requests.
That's why I was thinking 4 pre filtered lists would do wonders.
