Forum Discussion
Populate dynamic calendar with table data
Mthammon The calendar template you chose isn't well suited for what you have in mind. As most templates, it's packed with tricks and treats. This particular one is full of named formulae. Neat, but near to impossible to tweak without destroying something else. But, there are templates "out there" that can do what you need. Not too long ago, I adapted such a template for another user on this forum, though it uses the rather new FILTER function. The original template just highlighted that "something was due" on a particular date without specifying what. After my adaption it actually displays the assignment(s) due on a given day.
I took a few columns from your data sheet and dumped them in the template. See if it works for you (file attached). If not, keep searching for a better template.
Riny_van_Eekelen - Appreciate your work! I downloaded the first file (MHammon cal) and noticed the weekly and monthly views. Is it possible to develop a yearly view? I manage a training program for my organization and my intent is to have various events auto-populate on a yearly calendar based on the date the individual joins the organization. Generally speaking when individuals join my organization they are employed for a minimum of 5 years. Essentially, I'm looking to create a "road map" of career progression expectations during this initial employment period. Ideally, capturing the entire five years on one tab, if possible (Jan-Dec 2024, Jan-Dec 2025, etc.)
The product that I currently have is not very user-friendly as it requires me to manually change dates or locations of the calendar for every individual event.
I tried to attach my current file but the .xlxs file format is not supported. Thanks in advance for any assistance you can provide.
MGunz_6019 Perhaps it possible but it would probably require a compete redesign. Not something I would recommend as thes kind of templates are meant to be used as they come. change a little here and there and you'll probably end-up with a mess, unless you put a lot of effort into it.
Thanks for the quick response! I started toying with the existing document by adding another tab for annual data. I have it set up the way I want it, I just don't know if there is a formula I can use to pull data from the assignments tab into the corresponding month cell on the annual calendar based solely on the month and year.
I noticed that the original file you attached was also the .xlsx format. Do you know of a reason I am not able to attach a file of the same format on this post? I attached a snip of the annual tab I'm looking to create. Thanks again.
MGunz_6019 If you can't yet upload a file, save it to a file sharing site (like Onedrive, Dropbox or similar) and copy the link that gives access to your file here or send the file to me in a direct (private) message.
MHammon Cal.xlsx works for me. Possible to convert this to Google Sheets? If can share an example would be greatly appreciated.
