Forum Discussion
Complicated formula -help appreciated
I hope you haven't lost interest in your original request. As you'll see in the attached, I carried through on my promise to deliver a wholly different way to do this.
I've deleted the tabs that gave a monthly or weekly calendar with the anemic "Assignment due" note where it applied.
In their place, I created a tab called "Sorted Order" which, as the name implies, lists the assignments in sorted order by date. And, when you look at the sheet itself, you'll see that I give you the ability to set a start and end date for the list, so you can determine whether it shows just the coming week, the coming month, the coming semester....whatever. You can also list assignments past.
And I've added a column in which you can make notes on the magnitude of the assignment, so that (if you choose to use it this way) you can get working on things due a month out if they require a lot of work.
It would also be fairly easy to add yet another column that just reflects Priority or Importance, and do the sort such that the top priority are listed first regardless of due dates.
Again, I need to note that the SORT and FILTER functions work only on the most recent versions of Excel, so if you're not seeing the dynamic results of changing the start and end dates, that's an indication you don't have the required version of Excel.
mathetes It appears you understand this stuff perfectly so I wanted to chime in with another question relative to this template. I really like the calendar view but just like the other person you were helping I don't want the calendar view to show "Assignment Due", I want it to show the exact text that appears in the 1st tab where assignments are entered. Any assistance would be greatly appreciated. Thank you!