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!!!!!!!!!!!
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 😊
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?
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?
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
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.
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
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 :(
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.
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
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.
Other Google Sheets Templates
► Website: jpsdigitalpages.com
► Etsy: jpsdigitalpages.etsy.com/listing/1644421469
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. :)
You're welcome!
Thank you so much I just finished creating mine! 😉💕
Awesome. Glad to hear this!
This is what I was looking for, thank you Darowan!!
You are welcome!
Hello! Thank you so much for creating this tutorial 💚 this is exactly what I was looking for 😭 big help
My pleasure! Thanks for leaving a comment 🙏🏾
Thank you so much this was exactly what I needed ❤
You are welcome 🙏🏾
thank you for this!! i was able to create mine!
Glad I could help! You are welcome.
On chat GBT what did you say to make the formula? I also cant find your formula to copy and paste from.
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!!!!!!!!!!!
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 😊
thanks a lot Darowan!
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?
I updated the link to correct that issue. Copy the link again
I'm halfway through the video going strong but now I can't find the link to the formula! Am I looking in the wrong spot? 😢
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?
12:35 formula
.
How about the notes. Does it save base on the month and date?
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
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.
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
Yes. I will post it this week.
@@Dbddigitalstudiodid you post?
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 :(
Or is it suppose to be like that and the client simply duplicate the calendar in a new tab for a different month?
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.
Hi, Where can I get a copy of the formula?
Link in the description box.
Thank you so much for the video
You are welcome!
the formula simply does not work
Check the free patreon page for the updated link.
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
The template is available for free. The link is in the description box.
Is there a way to only have it show the dates for the current month and not the previous or next month?
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.
This is really great but I am struggling with the formula, please share🙏
I understand. I do have an updated formula that I will be sharing in a new tutorial. Hopefully that is easier to follow.
The links bring up a 403 Forbidden page. I've tried duplicating the formula by manually typing and get a parse error.
The link is now available in my Patreon page: www.patreon.com/posts/dynamic-calendar-101308634?Link&
I got lost in the formula
I understand. I do have an updated formula that I will be sharing in a new tutorial. Hopefully that is easier to follow.
Link for template is not working
Check the free patreon page for the updated link.
You did a disservice by not sharing that formula so we could copy it.
Check the free patreon page for the template. The formulas are in the template and you can copy it from there.
useless, i change the month the writing remains
Thanks for stopping by