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.
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?
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).