Forum Discussion

Mthammon's avatar
Mthammon
Copper Contributor
Oct 05, 2021
Solved

Populate dynamic calendar with table data

I have a dynamic calendar set up and a table with data, I need help figuring out the right formula to use to have the calendar populate with the tasks from the table.    For example, one task may b...
excel
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Oct 06, 2021

    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. 

alexisbynum's avatar
alexisbynum
Copper Contributor
Jan 19, 2023

Riny_van_Eekelen Yes! Thank you! Is there a way to remove the word assignments and replace it with “Tasks” from all the other notes and such without messing things up? 

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jan 20, 2023

alexisbynum Just enter it in the cell BR. It's just a header that is not used in any formula. And if you want you can also change the sheet name to Tasks. Formulas will update automatically.

 

Edit: Now see that are some more ASSIGNMENTS floating around that cause trouble. Attached a new version.

Resources