Forum Discussion
Solved
Complicated formula -help appreciated
Hi all! I’ve downloaded the student assignment planner template. One tab is for assignments with a column for assignment name and another column for assignment due date. No prob! The next tab is a ...
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.
OMG thank you for replying. I've attached the file. The formula I'm trying to edit is
=IF(LEN(F6)=0,"",IF(COUNTIF(Assignments[DUE DATE],DATE(MoYear,@MoMonthNum,F6))>0,"Assignment due!",""))
I was hoping to change the "Assignment due!" to pick up the Assignments tab Column B cell that corresponds with the appropriate due date
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.
Hello I have the same issue and would like to use event name as opposed to the assignment due! on the calendar. Kindly repost the revised assignment excel sheet.
You're very welcome.
As I said, there are ways it could be refined further...such as adding other columns that reflect things like priority or importance, whether it's a course for your major, other characteristics you might want to be tracking.
Could even add a date column where you give yourself not only the date the assignment is due to be turned in, but dates to start working on a major paper. (I remember back in my college days suddenly realizing on a weekend that a major paper was due the following Tuesday. I'd been researching it, but hadn't started writing. And this was in the days of typewriters, not even electric typewriters. That's how old I am.)
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!
- Thank you! I’ll wrap my head around this Monday (just have the phone over the weekend) And happy anniversary!!!!
