Forum Discussion
Create autopoulating excel calendar with colour coded categories
You'd have to insert enough rows under each date row to accommodate the maximum number of events per day that you expect. Let's say that you won't have more than 8 events per day. You currently have 1 row for each day, so you'd have to insert 7 new rows under each day row.
You can then omit TEXTJOIN from the formulas:
=IFERROR(TEXTJOIN(REPT(CHAR(10),1),TRUE,FILTER(Schedule[[Title]:[Title]],(Schedule[[End Date]:[End Date]]=(DATEVALUE(B6&"-"&MoMonth&"-"&MoYear))),"-")),"")
becomes
=FILTER(Schedule[[Title]:[Title]],Schedule[[End Date]:[End Date]]=(DATEVALUE(B6&"-"&MoMonth&"-"&MoYear)),"-")
This formula will automatically spill to as many cells as needed.
Because there is now only one category per cell, you can apply conditional formatting rules - one rule for each category.
You'd have to insert enough rows under each date row to accommodate the maximum number of events per day that you expect. Let's say that you won't have more than 8 events per day. You currently have 1 row for each day, so you'd have to insert 7 new rows under each day row.
You can then omit TEXTJOIN from the formulas:
=IFERROR(TEXTJOIN(REPT(CHAR(10),1),TRUE,FILTER(Schedule[[Title]:[Title]],(Schedule[[End Date]:[End Date]]=(DATEVALUE(B6&"-"&MoMonth&"-"&MoYear))),"-")),"")
becomes
=FILTER(Schedule[[Title]:[Title]],Schedule[[End Date]:[End Date]]=(DATEVALUE(B6&"-"&MoMonth&"-"&MoYear)),"-")
This formula will automatically spill to as many cells as needed.
Because there is now only one category per cell, you can apply conditional formatting rules - one rule for each category.
- Thank you - this worked for me!!
