วีดีโอ

This method should work the same way regardless of how the dates are displayed. 😊👍 Dates are always just stored as numbers in Google Sheets. It's only the number formatting that makes them appear differently.

To filter by a specific value such as a name, check out the spreadsheet below. spreadsheetlife.com/wp-content/uploads/2024/07/Filter-Function-Example.xlsx And if you want to find a partial match, for example, filter by values that contain something, then checkout this video below. th-cam.com/video/bfM-79K1Ii4/w-d-xo.htmlsi=ilQPxy4H3XJYwd2m

@@spreadsheetlife Thank you! With the example it worked!

I'm so happy to hear that you are using the template! 😄😊

You're very welcome. Since I've already made four calendar videos (two for Excel and two for Google Sheets), I probably won't make another one for a while. But if I do, I'll be sure to include recurring tasks as you have described. I'm sorry it may be a while though.

😅😊👍

A good idea might be to write them down on a sticky note that you keep next to your computer. And then practice a bit, and it will stick in your memory in no time. After all, practice makes perfect. You've got this! 😄👍

Thank you so much for subscribing, and I will keep going for sure!! 😊👍

You're very welcome. I'm so glad you enjoyed the video! 😄

😄👍😊

Awesome!! Super glad to hear it! Thanks for letting me know. 😄

For something like this, a pivot table is probably unnecessary since you we are just performing a simple lookup. However, I will do my best to include pivot tables in future videos so you can get some good practice in. 😊👍

😄👍

Unfortunately, it will not work this way. Anything returned by the FILTER function can only be viewed but not edited or deleted. All changes must be made to the source data itself. I'm sorry that's the case.

Thank you so much for your kind words! They really mean a lot! 😊

Happy to share. So glad you enjoy the ideas, and thank you so much for the sub! 😊

That's so amazing to hear! I'm so glad it's helpful. Enjoy using the template! 😊

This is probably because you are working in an older version of Excel. Unfortunately, the FILTER function is only available in the Office 365 Version of Excel.

You're so welcome! I hope they love it! 😄👍

update: I was just being dumb and actually just needed more data points to make this happen. this is my first time really making something on excel and I am SO proud of myself

Awesome. I'm so glad you figured it out! And you should be SUPER proud of yourself. This is not a simple build. So the fact that you made it through this build is absolutely amazing!! Awesome job! 🎉🎉😄👍

There would be some similarities, but there would also be a handful of differences. I'm sorry that's the case.

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.

You're welcome! 😊

😄👍

To add events that change dynamically with the calendar, check out part two! th-cam.com/video/CBWy5MxbNO0/w-d-xo.html

Unfortunately, it cannot be used in Google Sheets. However, I am currently working on a Google Sheets version. It should be available sometime soon.

You can now find the Google Sheets version here. spreadsheetlife.com/templates/sku-generator-gs/

Hi there! I'm super glad you've enjoyed the video, but I'm sorry that you're struggling with the formula. To make it easier for me to help, send me an email at info@spreadsheetlife.com. Attach your file, and remind me what you're struggling with in the email.

@@spreadsheetlife I’ve just send you an email…🤞🏻

I got your email. You can expect a response here in a little bit!

I just wanted to express my deep gratitude for the extraordinary assistance you provided. Your valuable insights have truly opened my eyes to a fresh perspective, and the individual behind the TH-cam channel is a remarkably humble person. I never anticipated receiving such overwhelming support from you. Your kindness and generosity are truly remarkable. Please continue to inspire others with your outstanding work. 👩🏻‍💻

You just made my day. Thank you so much for your kind and heartfelt words. They mean so much to me and really encourage me to keep going and give it my all to create the best content I can. 😊

Hi there! I'm glad you enjoy my videos and have learned from them. I'm not sure how long it will be, but I am planning to make a Google Sheets version of this video in the near future.

@@spreadsheetlife Hi I wanna thank about your channel it's very helpful for me, i just wanna ask you if you can upload a video of how to make tracking files in excel (such as tracking: the task, the attendance, and so on)

Hi there! I'm thrilled to hear that you find my channel so helpful! 😊 For your question, could you be a little more specific about what kind of tracker you would like me to create? I am a little confused about your request.

@@spreadsheetlife ok let me explain it in more details.. I'm a team leader for a group and i wanna make something in excel that makes me up to date about their attendance, the time they attended the meeting whether they came in time or not , the tasks I gave them and so on and i want all this by points for example if they attended in time i gave them 2 points bonus ....I hope that i explained it in a good way ..and sorry about any mistakes in grammar or vocabulary, english isn't my first language

No need to be sorry at all. Your English is great! 😊👍 Thank you for the explanation. This sounds like a really interesting idea. It's also pretty specific. If you're open to the idea, I also do custom spreadsheet work outside of my TH-cam channel. A request like this falls more into that category rather than me making a video on it. You can send me a request at this link: spreadsheetlife.com/custom-development/ And we can figure out the details for the spreadsheet and go from there.

Excellent question! Change the formula to the following: =IF(COUNTA(F4:AJ4)=0,0,AL4/COUNTA(F4:AJ4))

😄👍😎

How interesting. I love seeing how everyone puts their own spin on things! 😄 I'm glad you enjoyed the tutorial!

You can manually type in the time within the event description, but that's about all you can do for this specific build.

I found your other comment for the part 2 video and gave you a response there. 😊👍

I do have a way you can color code specific types of events, but it is a little tedious. Send me an email at info@spreadsheetlife.com, and I can show you how to do it.

Please i also need that colour code specific types of events. Plz help me. Very urgent.

Send me an email at info@spreadsheetlife.com, and I will do my best to help.

Hi there! I found your other comment for the Part 2 video. I gave you a response there. 😊👍

I'm super glad you enjoyed the video. Unfortunately, the original design is not created to handle night shifts as you have discovered. However, it is certainly possible to update the formulas to get it to work properly. Check out this spreadsheet below. docs.google.com/spreadsheets/d/1BrmzJVE5YrI9fiqIVgzHgzEl-s1jlBbcIqf6vLTYLNQ/copy You will find that I use the IF function to check how the times are related and then the proper calculation is performed accordingly. I hope this helps.

Thanks so much! 😊 I'm glad you enjoyed the video.

Thank you so much for your kind words! I'm so glad you enjoyed the video. 😊

That's awesome!! Way to go! 😄

Unfortunately, based on this design, you'd have to type the event in manually for each occurrence. I'm sorry that's the case.

You're very welcome. I'm so glad you like the idea! 😄

That sounds awesome. Although simple, these tips will really go a long way for sure!

You're very welcome! 😊

I'm so glad you enjoyed the video and found these tips to be great! 😄👍

Thanks for watching! This particular build is not dynamic, but I'm sure I will create some other dynamic dashboards in the future for sure!

Thanks for watching! I'm so glad you enjoyed the video and also figured it out! 😄

So awesome to hear!! 😄 As for the conditional formatting formula to get the prior month to grey out, you have to type in MONTH manually when writing this formula. And be sure that you have your references and the dollar signs correct as well.

I'm so glad you found the video helpful! To filter by both month and year, check out the spreadsheet linked below. docs.google.com/spreadsheets/d/1Onm9rSnTVBtbJ5kBLGVZLF92Fj_2QFbzpyHsZ8uU7XI/copy