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.
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.
This template was so helpful! I was able to adjust it to power query all my tabs into one sheet which was great. I'm now trying to highlight today if that were the drop down calendar. Can you help with that? I'm also trying to conditional format cells with 2 assignments, is this possible?
Would you be able to provide that template to me? I am having an issue where I have multiple tasks/due dates across multiple sheets and would love to use the template Riny posted but need the tasks across all sheets to show up on the "Assignments tab" in order for the calendar views to work. I tried to do some vlook ups but its not working. I have a basic understanding of power query but have only ever done it to bring data from multiple sheets to a whole new sheet, Im not sure how you do that to bring that query to the "Assignments" sheet. Would appreciate any help!!
Apologies for not responding earlier. I somehow missed your follow-up question after my last answer. If you are still in need of help, please start a new thread, similar to what I explained below.
I'm glad you found this thread helpful, though if you want to customise the template further I would recommend that you start a new thread and share what you have created so far (upload a file here or share a link to it on OneDrive, Dropbox or similar).
