Forum Discussion
Excel Task list
Hi All,
I am having an issue finding a way to organize my task list. I have a task list with multiple tasks that is color coded by task codes. For example if on position A1 I introduce the task code "C" then the task will appear in column "task 1" as Clean. Each tasks is color coded by priority, high priority turns red, medium turns the cell orange and low turns the cell yellow. However, beyond the color coding I want all the high priority cells (in red) to always go on column labeled "task 1" since it is the first task I want done. Right now, my issue is that depending on how the task code is entered, tasks will go to any column (i.e. Task 1, Task 2, Task 3, Task4 ,etc.) But I would like that all high priority go to one column (task 1), all medium go to another column (task 2) and all low priority go to task 3. How can I fix this issue?
Thank you!
3 Replies
A sample workbook would be great to get started.
You might also consider using Planner where you have this functionality from the start:
https://planner.cloud.microsoft/
Seems you need FILTER() function. See the attached file.
=FILTER(B4:B20,C4:C20="C") =FILTER(B4:B20,C4:C20="D") =FILTER(B4:B20,C4:C20="E")Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
