I'd like to make a calendar a bit like this: https://youtu.be/hCMivfX5evA?t=316 where I can add a year and month, and the day will go under the corresponding day of the week based on those two pieces of information.
What are some customization options for a dynamic calendar in Google Sheets?
How do I start creating a dynamic calendar in Google Sheets from scratch?
How does using formulas benefit the creation of a dynamic calendar?
1+C4-1), "yyyy-mm-dd")&"'" ))
Hello! I need help making a dynamic/ automated calendar to organize my team's tasks. I tried youtube but it didn't give me the solutions I needed.
Expectations: Every task encoded on sheet 3 should be automatically entered in the sheet 2 with the same color scheme
Gsheet link: https://docs.google.com/spreadsheets/d/1Yc_WW5-D9E-RUB_2OWyA04qAKKIcjqbwP5qn8_zX65I/edit?usp=sharing
Thank you!
I want to take a typical dynamic calendar in sheets that will autofill the days with my plans.
My idea is that I have a secondary tab or spreadsheet with the school days in a column that will then fill the contents of the days on the calendar.
While the structure of the school calendar changes year to year (holidays, conferences, snow days, etc. can fall on different dates) the basic order of how I go through the content remains in a similar order.
But teaching is also dynamic, and some days I might do something different and push things ahead or back in the schedule. It is somewhat tedious copy-pasting the days on the calendar itself, so I want to be able to simply shift the cells up/down in a column in one maneuver.
What I've tried
I started by making a column from 1 to 180, my thought was that each of these would represent the school day number (the first day would be 1). Weekends don't count since we don't have school then.
In the next column I put the plan/content for the day. Simple enough.
My problem is I don't have the skills to formulate the dynamic calendar to:
assign the school day number to the weekdays in a given month
extend this numbering system to the next month
create a condition for filling the day with the plan/content based on that number
Now there might be a vastly easier way to go about this. Ideally I could have a tab where I have my content, and another area where I can specify the dates of weekdays where we have no school (winter break, conferences, snow days) that would allow the numbering of school days to skip these dates so they don't fill with anything other that *insert reason for no school*.
I've tried searching online, but there is just a plethora of resources showing how to make the calendar itself, but not this extra step I want to take.
Request
I am seeking advice, resources, or someone who feels that this is something they could solve themselves. Maybe something like this is already out there and I'm just struggling to find it.
The Data
I have a view only link to the current Calendar spreadsheet I've been using and tried editing to autofill with little success.
I also tried using the tableit.net to format the first 3 months of school. I'll paste it here:
|Day #|Plan|
:-:|:--|
|1|Introductions
"Get To" Know You Form|
|2|Intro to eJournal
Unit 1 Ch. 1 Act. 1|
|3|Finish Act. 1|
|4|Unit 1 Ch. 1 Act. 2|
|5|Finish Act. 2
Checkpoint 1.1.1Prep Act. 3|
|6|Unit 1 Ch. 1 Act. 3|
|7|Unit 1 Ch. 1 Act. 3|
|8|Finish Act. 3
Checkpoint 1.1.2|
|9|Unit 1 Ch. 1 Act. 4|
|10|Unit 1 Ch. 1 Act. 5
Checkpoint 1.1.3|
|11|1.1 eJournal Check|
|12|Review Day|
|13|1.1 Test|
|14|Unit 1 Ch. 2 Act. 1|
|15|Unit 1 Ch. 2 Act. 2|
|16|Finish Act. 2
Checkpoint 1.2.1|
|17|Unit 1 Ch. 2 Act. 3|
|18|Finish Act. 3|
|19|Unit 1 Ch. 2 Act. 4|
|20|Unit 1 Ch. 2 Act. 4|
|21|Unit 1 Ch. 2 Act. 4|
|22|Unit 1 Ch. 2 Act. 4|
|23|Finish Act. 4
Checkpoint 1.2.2|
|24|Unit 1 Ch. 2 Act. 5|
|25|Finish Act. 5
Start Act. 6|
|26|Finish Act. 6
Checkpoint 1.2.3|
|27|1.2 eJournal Check|
|28|Review Day|
|29|1.2 Test|
|30|Unit 1 Ch. 3 Act. 1 & 2|
|31|Finish Act. 2
Checkpoint 1.3.1|
|32|Unit 1 Ch. 3 Act. 3|
|33|Unit 1 Ch. 3 Act. 4|
|34|Checkpoint 1.3.2
Start Act. 5|
|35|Finish Act. 5|
|36|Unit 1 Ch. 3 Act. 6
Checkpoint 1.3.3|
|37|1.3 eJournal Check|
|38|Review Day|
|39|1.3 Test
Unit 2 Ch. 1 Act. 1|
|40|Unit 2 Ch. 1 Act. 2
Checkpoint 2.1.1|
|41|Unit 2 Ch. 1 Act. 3|
|42|Unit 2 Ch. 1 Act. 4|
|43|Finish Act. 4
Checkpoint 2.1.2|
|44|Unit 2 Ch. 1 Act. 5|
|45|Finish Act. 5
Checkpoint 2.1.3|
|46|Unit 2 Ch. 1 Act. 6|
|47|Finish Act. 6|
|48|Unit 2 Ch. 1 Act. 7|
|49|Finish Act. 7
Checkpoint 2.1.4|
|50|2.1 eJournal Check|
|51|Review Day|
|52|2.1 Test|
|53|Movie|
|54|End of Tri
Movie|
|55|Introductions
Unit 2 Ch. 2 Act. 1|