Forum Discussion
Converting excel data into a printable calendar template
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.
monty359 That file link requires a "Sign-in". Please upload a link that gives access without logging. If that doesn't work for you, send the file to me in a direct message.
Riny_van_Eekelen I have an excel sheet of events for multiple people that I want to dump into a calendar format. Each of the 5 "attendees" would be color-coded so we can see who may be open to attend an event. I assume I need to first color-code the individuals in the excel sheet (prepared by someone else), but how do I then get the data into a calendar? Here's a sample of the current file. Thanks!
https://lochgroup-my.sharepoint.com/:x:/r/personal/patty_montgomery_lochgroup_com/Documents/Schedule%202-9-24%20Color.xlsx?d=w62fd79a3dfad447eb8566c1e1867e425&csf=1&web=1&e=kIuLZb
vdefilippo Google sheets may resemble Excel but there are quite a lot of differences. But, I'd be surprised if you can get that template working in GS. Good luck!
@Riny_van_Eekelen Well- I thought it would work- it did in excel. But I guess there's an issue when getting it into google sheets. I think it has something to do with the filters. I'll continue to see if I can figure it out.
Thanks.- My apologies.
I was able to get it into the sheet I need it to be on and it works! Thank you again! This is a wonderful tool! Have a great day. 🙂 vdefilippo Asking is free, but we are dealing with a three sheet workbook with quite a bit complexity. Not something you can 'just put into another sheet'. Perhaps better that you open a new thread explaining your dashboard and that you want to integrate some sort of calendar view in it. Not sure that the calendar in this tread is a very good one. The template it's based on is, actually, totally useless. I just made it to become slightly less useless. 🙂
- Sorry- another question. How can I incorporate this into another workbook? I have a dashboard and I'd like it to be part of that sheet. I see a simple copy paste won't do it.
vdefilippo "Inconsistent formula" is just a warning, you may ignore it. I don't see it as I turned off these background error checking messages quite irritating. Can't really tell why you get value errors in the week view. I would have to see the file.
- this is genius! It's exactly what I've been looking for. I'm pretty much a basic user of excel and I appreciate your contribution.
If you don't mind I have a few questions-
My intention is to use this as a vacation calendar. I see there is an "inconsistent formula" message in each bock. How do I fix that?
On thee week view- row 15 columns e, f, g all have "#VALUE!". How do I fix that?
