need some help renaming "assignment due" as well as adding more text "projects" in dates.Student assignment planner1.xlsx
need some help renaming "assignment due" as well as adding more text "projects" in dates.Student assignment planner1.xlsx
Is this what you require ?
=IF(LEN(G6)=0,"",IF(COUNTIF(Assignments[DUE DATE],DATE(MoYear,MoMonthNum,G6))>0,INDEX(Assignments!$B$5:$B$20,MATCH(DATE(MoYear,MoMonthNum,G6),Assignments!$C$5:$C$20,0)),""))
i.e. Add assignment texts from "Assignments" ?
On dates 10/20 how would i enter multiple projects?
Try in 20th Oct
=IFERROR(IF(LEN($D$24)=0,"",IF(COUNTIF(Assignments[DUE DATE],DATE(MoYear,MoMonthNum,$D$24))>0,INDEX(Assignments!$B$5:$B$20,SMALL(IF(DATE(MoYear,MoMonthNum,$D$24)=Assignments!$C$5:$C$20,ROW($B$5:$B$20)-ROW($B$5)+1,""),ROWS($B$5:B5))))),"")
Enter with Ctrl+Shift+Enter
You will get curly brackets { } round the formula if entered OK (don't try and enter them yourself)
Drag formula down.
AWESOME!!!! thank you, got everything fixed now....
I used the above solution for the same student assignment planner template and it worked, but am now having the following problems:
1. When I change the month or year of the calendar, the formulas return FALSE instead of a blank ("") when there's assignment entered on that date in the 'Assignments' tab.
2. Is there any easier way to drag the formula across the row so I have it in all the dates on the calendar? Because the date cell we're referencing is locked (i.e. $D$24), it returns the same result across the row (instead of referencing E24, F24, etc.). If I remove the $ to 'unlock' it, will that affect the formula?
I'm trying to avoid having to manually enter the formula in every single date on the calendar. If you have solutions for either or both of these, it would be a big help! Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks