Student Assignment Planner = Help!

[khumber]

Does anyone know how to edit the template so the description of the assignment appears in the month and week view rather than Assignment Due! text? Thank you :-)

[FDibbins]

Umm which template? I doubt many members have their crystal balls out at the moment lol

If this is a purchased template, contact the vendor.

[khumber]

Am using standard excel template. I need the event description to appear in the month view and weekly view calendar rather than returning "assignment due" for every event. Thanks

[FDibbins]

Try this...
=IF(LEN(C6)=0,"",IF(COUNTIF(Assignments[DUE DATE],DATE(MoYear,MoMonthNum,C6))>0,INDEX(Assignments!$B:$B,MATCH(DATE(MoYear,MoMonthNum,C6),Assignments!$C:$C,0)),""))

I changed the bolded part

[khumber]

Thank you, that worked. If I have multiple events on one day, do you have any suggestions on how I can get it to display the multiple events please?

[Pete_UK]

How many events are you likely to have each day?

Pete

[khumber]

Hi Pete, probably maximum of 6, want to use it for students to record assignments/exams, extra curricular activities and part time work.

Thanks.

[Pete_UK]

Do you intend to use it for a number of students (perhaps having a drop-down to select a particular student), or will each student have their own file? In your Assignments sheet you do not have a column to identify the student.

I've done a number of these calendar files, so I can probably amend one easily enough to suit your purposes - please attach another file showing what data you intend to use.

Hope this helps.

Pete

[FDibbins]

Try this, using a helper column in Assignments sheet (I used E)...
E4=B4&IF(C4=C5," & "&E5,"")
copied down.

Provided all your dates are in order, this will starts accumulating Descriptions for you (from the bottom up so the 1st entry will have all classes).

You could then use column in my this in my suggested formula, instead of col B...
=IF(LEN(C6)=0,"",IF(COUNTIF(Assignments[DUE DATE],DATE(MoYear,MoMonthNum,C6))>0,INDEX(Assignments!$E:$E,MATCH(DATE(MoYear,MoMonthNum,C6),Assignments!$C:$C,0)),""))

[khumber]

Hi Peter, plan is that each student has their own spreadsheet and continues to add events to it throughout the school year. Cheers, Kylie

[FDibbins]

Did you try my updated suggestion?

[khumber]

Yes, that did work, just what I needed.... thank you so much for your help.

[FDibbins]

Happy to help

[Brinabop]

Hi FDibbins, I get a circular reference error when I add the helper column. Was there an update after this suggestion?

[AliGW]

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread