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.
You seem really knowledgeable on all of this and I would love any assistance you can offer. I am trying to create a dynamic calendar similar to the one you created for another user.
My list of tasks never changes so I'm looking to create a calendar that just changes the due dates based on a start date. For example, a new hire starts today. I would like Task 1 to be due 5 days after the start date, task 2 is due 3 days after task 1, etc.
APerez2329 Well, have you tried inserting two columns? One for Start and one for Number of days till due. Then in the Due date column, use a formula that sums Start and Number.