Forum Discussion
Converting excel data into a printable calendar template
My work runs about 200 events per year. These are listed in an excel spreadsheet. However they also have a word template which has the layout of an annual calendar. This means there are months acr...
Hi! I am wondering if there is a way to only show one "Type" on the calendar. For example, on the first sheet, you can apply a filter that only displays "Walk." But is there a way to only display "Walk" on the calendars on Sheets 2 and 3?
al_fa1922 There are no drop-downs in this template, other than the month and week. So, what do you mean? The filter button in Events show Race, Run Walk just because these words were entered in column D in the first sheet.
The Month and Week sheets just concatenate Type and Distance from the Events sheet in the calendar sheets.
- I'm just trying to modify the template above for something that I need it for. I am trying to have the capability of including various Types/Categories in a Master spreadsheet (i.e. the events sheet), but then being able to filter those categories so I can view a calendar for just one Type/Category. So, to relate it to the Marathon template, I would want to have Walk, Run, Race in the Events spreadsheet, but then be able to filter them so I could just view a Walk calendar or a Run calendar. Does that make sense? I am not sure if this is possible, but it would really help. Thanks!
al_fa1922 You are trying to add functionality to customised template. What you have in mind. If you only want ro show "Walk" why not create a calendar with only "Walk" entries?
- Yes, my apologies. I realized that after I sent the message. But, let's say I want to just view my "Walk" schedule on the calendar. Is there a way to filter that or change the concentration of the month and week sheets?