Forum Discussion
Converting excel data into a printable calendar template
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. 🙂
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. 🙂
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.
