Make Your Own Dynamic Calendar In Google Sheets: Step-by-Step Tutorial

Подписаться 1,3 тыс.

Просмотров 18 тыс.

50% 1

ABOUT THIS VIDEO
Updated Tutorial (2024 Update + New Template) • Make Your Own Dynamic ...
A step-by-step tutorial on creating a dynamic calendar in Google Sheets. Whether you prefer your week starting on Sunday or Monday, this template is customizable to your preferences and automatically updates with the year, month, or day you choose.
00:00 Introduction
00:56 Use case examples
02:53 Start of tutorial
05:12 Create calendar backend
07:08 Create drop-down tabs
15:28 Create a calendar structure
LINKS MENTIONED IN THIS VIDEO
► Free Google Sheets Calendar Template www.patreon.com/posts/dynamic...
► Dynamic Calendar Template jpsdigitalpages.com/b/dHbsi
► Etsy: www.etsy.com/shop/JPSDigitalP...
WEBSITES
Official Canva Creator Profile ► www.canva.com/p/designsbydaro...
DFY Canva Templates for Coaches ► designsbydarowan.com/
Digital Planners ► jpsdigitalpages.com/
Small Business Forms ► 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
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!"

Опубликовано:

5 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 55

@Dbddigitalstudio 7 месяцев назад

Other Google Sheets Templates ► Website: jpsdigitalpages.com ► Etsy: jpsdigitalpages.etsy.com/listing/1644421469

@jcibale0304 3 дня назад

Thank you so much I just finished creating mine! 😉💕

@Dbddigitalstudio День назад

Awesome. Glad to hear this!

@trackeressentials 8 месяцев назад

This is what I was looking for, thank you Darowan!!

@Dbddigitalstudio 8 месяцев назад

You are welcome!

@spencerreyes6811 9 месяцев назад

Hello! Thank you so much for creating this tutorial 💚 this is exactly what I was looking for 😭 big help

@irenelim6798 6 месяцев назад

was so hopeless but was able to find what the problem was while i was copying your formula. Thank you for this, i just love your style. :)

@Dbddigitalstudio 5 месяцев назад

You're welcome!

@Dxsmel 8 месяцев назад

Thank you so much this was exactly what I needed ❤

@Dbddigitalstudio 8 месяцев назад

You are welcome 🙏🏾

@wilderdandelion 5 месяцев назад

thank you for this!! i was able to create mine!

@Dbddigitalstudio 5 месяцев назад

Glad I could help! You are welcome.

@deleciamccain4660 3 месяца назад

On chat GBT what did you say to make the formula? I also cant find your formula to copy and paste from.

@LaylaHobby 3 месяца назад

Hi. I followed your tutorial, thank you so much, and adapted it to my needs. however, I'm struggling to put expenses in a different color than income. Can you help me?

@sarahmaytelan5902 2 месяца назад

How about the notes. Does it save base on the month and date?

@charliegray6749 9 месяцев назад

Hello there, thanks for the great video! I have a question however, i copied your video step by step and copy and pasted the formulas from your sheet (but had to change some of the cells i think they are off by one in the sheet compared to the video) anyways - my calendar works lovley expect for the months January and February. NO matter how i try and make it work those two months show up as a #N/A error on the page but all other months work? Do you have any idea what this could be

@Dbddigitalstudio 9 месяцев назад

Thanks for your comment and kind words. I am happy to troubleshoot your sheet if you want. You can share the link to my email hello@designsbydarowan.com and I'll make a copy of it and check it out.

@jpapp15 6 месяцев назад

I loved this video!! It has helped me keep track of everything. I would like to have a new tab for each month however when I duplicate the sheet and change the month, it changes the month but not the days on the actual calendar. Do you have any advice on how to do this?

@Dbddigitalstudio 4 месяца назад

I updated the link to correct that issue. Copy the link again

@boutiquepfd 10 месяцев назад

Oh wow!! Exactly what I was looking for!!! I will create mine in French.. so, in the formula that you got from ChatGpt.. can I replace all the English month by the actual words I will have in my sheet?? or it won't work?? I would also like to learn how to create the check list part and how the cell is changing with the % done!! So brilliant!!!!!!!!!!!

@Dbddigitalstudio 9 месяцев назад

Sorry for the late response. Yes, you can replace the names but you might also need to adjust the names in the formula for it to work well. You can actually use Chatgpt for that step 😊

@user-jr7js6se2w 6 месяцев назад

Thank you so much for the video

@Dbddigitalstudio 5 месяцев назад

You are welcome!

@anaramirez8744 8 месяцев назад

Is there a way to only have it show the dates for the current month and not the previous or next month?

@Dbddigitalstudio 7 месяцев назад

They might be a way to tweak the formula to only generate the dates within that month, but I haven't played around with that option. What I have done, is to use conditional formatting to change the colors of the days from the previous or next month to something much lighter.

@boutiquepfd 10 месяцев назад

Hello, I ran into a problem. It's doing the same thing in your template. Let say within the calendar you write something in Monday field on September month.. whatever you write, when you select another month, it will show up as well. Is there a way to fix that?? I am such a newbie and I don't know how to make it work properly :(

@boutiquepfd 10 месяцев назад

Or is it suppose to be like that and the client simply duplicate the calendar in a new tab for a different month?

@Dbddigitalstudio 10 месяцев назад

There are two ways to do this. The first is to duplicate the template into a new tab for every month. Another way is to create a database tab, where all the tasks are entered. Then another calendar tab, with filter formulas that, so that the tasks from the first tab get’s filtered into the calendar tab. It takes a little longer to set up, but easier to use as there is no need to duplicate the calendar for each month.

@paulwoodruff9239 4 месяца назад

The links bring up a 403 Forbidden page. I've tried duplicating the formula by manually typing and get a parse error.

@Dbddigitalstudio 4 месяца назад

The link is now available in my Patreon page: www.patreon.com/posts/dynamic-calendar-101308634?Link&

@jbonez___ 4 месяца назад

Do you have a tutorial on how to put stuff on the calendar and have it not carry over to each month? example: Jan 1st Dr. Appt then when switched to Feb 1st it will still say Dr. Appt

@Dbddigitalstudio 4 месяца назад

Yes. I will post it this week.

@deleciamccain4660 3 месяца назад

@@Dbddigitalstudiodid you post?

@lisanance1263 5 месяцев назад

Hi, Where can I get a copy of the formula?

@Dbddigitalstudio 5 месяцев назад

Link in the description box.

@vivekkaushik9722 5 месяцев назад

Everything is was going perfectly fine and then that formula appeared and I lost everything. I tried chatgpt and different vidoes and I could move further and still stuck. Please help if you could. This is something very urgent

@Dbddigitalstudio 5 месяцев назад

The template is available for free. The link is in the description box.