Forum Discussion
Converting excel data into a printable calendar template
1) Yes, that is possible. How would you want to use the event type in the calendar?
2) How would a "regular" calendar look like for you?
Thanks for the quick reply.
In my use case, I'm collecting a list of workouts related to different running races. I'm training for several races and each one has a different schedule. I'm trying to consolidate all of those in one place.
I'm attaching a spreadsheet based off your original reply.
- This was a great alternative. I tried it for our company holidays, for each country and the by month view works out great.
Katrina Thompson Then it's perhaps better you go for an other solution. I while ago I tweaked a rather poorly designed calendar template to do just what you have in mind. Originally a student assignment planner, but now it's a "Berlin Marathon" planner. See attached.
Hello - I realize some time has passed since this thread. But I'm wondering if you can help with the file you created called Berlin Mara. I'm adding some columns and one of them is a time column. When I enter it at as a time it formats to a decimal. =[@team]&" (vs) "&[@Opponent]&" "&[@Time] Is there a different way I need to write the formula so that it keep the time format?
Thank you.
hooknk If I understand you correctly you should wrap the time par of your formula in the TEXT function so that you can specify the time format. Like this:
=[@team]&" (vs) "&[@Opponent]&" "& TEXT( [@Time], "hh:mm:ss" )
Hi! I stumbled upon this old post looking for a solution. Seems your calendar "Berlin Mara" might work. I downloaded, however it seems the link to the "assignment" sheet no longer exists. I am assuming that's where I need to put my information? Any help would be appreciated.
Thank you for your time.
vdefilippo Yeah, the ASSIGNMENTS tab was renamed to EVENTS. You'll see a question about it a bit up in the thread.
And indeed, the EVENTS tab is where you enter whatever you want to see in the calendar.
Riny_van_Eekelen im jumping in this thread late, but have been reading along and this is just what i have been trying to work out. I work in a highschool and have a lot to do with calendars, have you ever created a spreadsheet that lists the events (assignments) and then can create a weekly, monthly or termly calendar but could also be filtered by faculty so they could print one?
There are quite a few steps to making the spreadsheet calendar you're looking for but it is doable. Subarrays, and filter functions. Depending on the layout you have in mind, depends on the amount of work it would take
