In this comprehensive tutorial, we create a dynamic and recurrent calendar/planner template in google sheets. The video is broken into chapters for easier navigation.
00:00 Introduction and Overview
01:29 Setting Up the Template
02:55 Creating the Calendar Structure
08:39 Adding Dropdowns and Data Validation
15:59 Adding Calendar Formulas
18:20 Applying Color Palettes
19:47 Adding Recurring Formulas
24:04 Conditional Formatting for Tasks
27:06 Final Touches and Tips
30:30 Conclusion
Templates are available on my Patreon page to Patreon members https://www.patreon.com/DBDDigitalStudio
Template link on Patreon https://www.patreon.com/posts/dynamic-calendar-120081476?utm_medium=clipboard_copy&utm_source=copyLink&utm_campaign=postshare_creator&utm_content=join_link
*LINKS MENTIONED IN THIS VIDEO*
► *Website*: https://jpsdigitalpages.com/b/mXsRf
► *Etsy*: https://jpsdigitalpages.etsy.com/listing/1833062547
WEBSITES
Official Canva Creator Profile ► https://www.canva.com/p/designsbydarowan
DFY Canva Templates for Coaches ► https://designsbydarowan.com/
Digital Planners ► https://jpsdigitalpages.com/
Small Business Forms ► https://deedigitalstudio.com/
By using these links, you support the channel at no extra cost. Thanks for your support!
*FOLLOW ME ON SOCIAL MEDIA*
Instagram ► @designsbydarowan
Twitter ► @designsbydarowan
*CONTACT ME*
For business inquiries or collaborations, please email me at: hello@designsbydarowan.com
Formula Link - https://docs.google.com/document/d/1r3pE9XIbbnmdQNVdfalqT9d1NFZexj5nhgeBYnvXIFM/edit?usp=sharing
*AFFILIATE DISCLAIMER*
Please note that some links in this description may be affiliate links. If you use these links to purchase a product or service, I may receive a small commission at no additional cost. I only recommend products or services that I personally use and believe will provide value to my viewers. I appreciate your support!"