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.
keatoh Sorry, I know nothing about Google sheets. Can't help you there.
I am struggling trying to modfy the Campaign Report Out Sample, AlexisCal2 and MHammon cal.
Can you add a tab of a calendar to this excel report?
I want it to show column q = "Calendar View" from the tab in the calendar box.
https://docs.google.com/spreadsheets/d/1q4bn1qEhDh_LVxTwCcHqExaKnF6I3ngW/edit?usp=drive_link&ouid=112637984442810321185&rtpof=true&sd=true
- create the calendar view in tab two
How about calendar view in outlook or android calendar? KBick1987 I'll send you a private message.
Riny_van_Eekelen I can't figure out how to upload my Excel.
I was trying to use your other files where it had a calendar view on one tab and the data on the second tab.
The file that i sent over, has the headers for coding purposes and loaded it to that sheet. I was hoping you can grab those first two rows and put it in an excel tab 1, then create the calendar view in tab two. In the calendar view, i wanted to see the text from column M- I can't figure out how to upload my Excel. I wanted to create a new tab with the calendar view. So I grabbed my headers for coding purposes and loaded it to that sheet
Kbick1987B Yes it does, but how does this relate to the question and/or files used in this thread?
Better to describe your specific question in relation to the data in your file in a new thread.
Riny_van_Eekelen does this one work?
https://docs.google.com/file/d/1q4bn1qEhDh_LVxTwCcHqExaKnF6I3ngW/edit?usp=docslist_api&filetype=msexcel
Kbick1987B I get "Unauthorised" when I try to open your file.
