Hi, your videos are very helpful! Btw, I just want to know if what will be the formula if we are going to add another tab aside from events and date? I tried adding another range into the formula, but unfortunately it doesn't Work. We would want to have two details that will appear in every date. Example Event + Name I hope you will notice this. Thank you and God bless!
Yes. One way you can do this is by applying a conditional formatting rule to the calendar cells where you set format cells if to "Text That Contains." I hope this helps.
hi, i wonder if you could make tutorial for this calendar as a business version? such as resort bookings. currently im running small resorts and usually i wrote down names in each columns
That sounds like a fascinating take on the calendar. I'd love to see what I could possibly put together for you. Would you be willing to send me an email at info@spreadsheetlife.com with more details on how you would like it to work?
Hi there! So far, I've made four different videos on calendar builds in Excel and Google Sheets, so I may not get to another event/calendar style tutorial in a while. Especially with so many other videos in my queue. But if you'd like some guidance, you can always email me at info@spreadsheetlife.com.
When you change the year, it will update all the dates as well. Since the calendar is designed to show events that appear on specific dates, everything will be updates accordingly. So if you have an event set on June 8, 2024, but you change the year to 2023, the event will not show up on June 8, 2023. The year would have to be 2024. I hope this all makes sense. Let me know if you have any other questions.
How strange. Are you storing your events in the Events tab? Or are you typing them directly into the calendar? The events must be stored in the Events tab only. I hope this helps.
You can find part one here: ua-cam.com/video/bwcughyS5PQ/v-deo.html
Hi, your videos are very helpful!
Btw, I just want to know if what will be the formula if we are going to add another tab aside from events and date? I tried adding another range into the formula, but unfortunately it doesn't Work.
We would want to have two details that will appear in every date. Example Event + Name
I hope you will notice this.
Thank you and God bless!
Send me an email at info@spreadsheetlife.com, and I can better help there.
Is it possible to add conditional formatting for the events base on its category?
Yes. One way you can do this is by applying a conditional formatting rule to the calendar cells where you set format cells if to "Text That Contains." I hope this helps.
hi, i wonder if you could make tutorial for this calendar as a business version? such as resort bookings. currently im running small resorts and usually i wrote down names in each columns
That sounds like a fascinating take on the calendar. I'd love to see what I could possibly put together for you.
Would you be willing to send me an email at info@spreadsheetlife.com with more details on how you would like it to work?
Thanks man. This channel is 🔥
Thanks so much! I'll do my best to keep it up! 😎
hello, with having this can you create a tutorial of summary of events per year e.g. events under January all in one column
thank you
Hi there! So far, I've made four different videos on calendar builds in Excel and Google Sheets, so I may not get to another event/calendar style tutorial in a while. Especially with so many other videos in my queue.
But if you'd like some guidance, you can always email me at info@spreadsheetlife.com.
Tolly useful!
😄👍
any way you could also retain the cell color?
Well one option would be to create a conditional formatting rule that highlights specific events. It just depends on how you want it to work.
How about when you change the year? The event will no longer visible when u change it
When you change the year, it will update all the dates as well. Since the calendar is designed to show events that appear on specific dates, everything will be updates accordingly. So if you have an event set on June 8, 2024, but you change the year to 2023, the event will not show up on June 8, 2023. The year would have to be 2024. I hope this all makes sense. Let me know if you have any other questions.
how to find the column number and row number at minute 3:53?
I don't quite understand your question. Could you please rephrase it for me?
My notes still copies to the following months :( .. pls help.
How strange. Are you storing your events in the Events tab? Or are you typing them directly into the calendar? The events must be stored in the Events tab only. I hope this helps.