วีดีโอ

Which specific question are you asking about?

Hmmm...have you entered some sample transactions? If so, double check that your formulas are correct. Let me know if you need further help.

Thank you for watching! 😊

Thank you for your kind feedback. It's wonderful to know that I'm easy to follow even for those who do not speak English as their first language.

Hmmm...here's one thing you can try. Delete the checkboxes in any cells where you don't want to count the attendance. See how that works. Let me know if you have any other questions.👍

😄👍

If you don't have any assignments listed, you will get this error unfortunately. Try adding a few assignments and see if the error goes away. If not, let me know and we can take another look at it. 😊👍

Unfortunately with this design, the only way to add an event that spans multiple days is by manually entering that event for each individual day. I'm sorry that's the case.

To change the year, just select the cell containing the year, and type in the year you want which in this case is 2025. That's all there is to it! 😊👍

My biggest advice is for you to watch part 2. It will show you how to add events to the calendar that dynamically update whenever you change the year or month. 👍

Thank you so much for your kind feedback! Congratulations on finishing it!! 😄👍

I'm so glad you found this video helpful! 😊

I'm so glad you found this video helpful! 😄 For your question - to account for half days, you'd have to use numbers instead of checkboxes and then change the formulas to add up the values differently. So it would be a tedious change. I'm so sorry that's the case.

I'm so glad you enjoyed the tutorial! 😊 For your question, could you clarify a little bit for me? I apologize that I don't quite understand what you're asking.

Thanks for watching! It's so cool to hear that you can put this template to such good use! And that's a great question. So one thing you could do is use the excused absence column as a tardy column instead. That would be the easiest thing to do. Now if you want that extra column, it would take quite a bit of work to modify the template to include it. The easiest time to include it would have been at the beginning. I'm so sorry that this is the case.

@@spreadsheetlife Understood! So I could not copy the formula into an extra column on the Jan-Dec pages and again on summary, then add that 4th option to the Pull down bar on days? If you are at all willing, I could start over and rewatch the vidoe and add that in where the time would be right to do so. Thanks for the help!

Right. I mean, you could, but then you have to update things like conditional formatting on every sheet, double check your formulas, make the required changes there. It's definitely possible, but quite tedious if you're not super familiar with the template. I tell you what, since you've already built it once, send me an email at info@spreadsheetlife.com. I think I have a solution for you.

Thank you so much for letting me know. That's so incredible to hear! 😊 Thank you for watching my content and for your support.

Thank you for asking about it. So the 6 and 7 tell the SEQUENCE function to create an array that spans 6 rows and 7 columns. If you have more questions let me know. 👍

​@spreadsheetlife 6:00 why did I enter the formula like in the video but it got an error saying "VALUE"

Hmmm...have you both selected a month and entered a value for the year? If you have not done those things, it will give you an error.

Thank you so much for your kind words! 😊

Of course! Thank you so much for letting me know. I hope the template serves you well. 😄👍

Hi there. That's a good question. Yes there is. If you leave the filter buttons on the table, you can use them to quickly sort the date. If not, you can still sort the date by selecting a cell in the column you want to sort by, and then right-click and select sort. I hope this helps.

@@spreadsheetlife Thank you for your quick response!

Of course! Happy to help! 😊👍

Hey there! I saw your email and sent you a response a few minutes ago. 😊👍

I am so sorry, but with the way this template is designed, it would be quite tedious to modify the graph to show 13 months instead of 12.

I'm so glad you enjoyed the video and found it informative. 😄 That's a good question. Unfortunately, this template is not easy to modify in that way once it's been built. The best time to add more than ten habits is at the very beginning. I am so sorry that this is the case.

Thank you for your feedback! I'm so glad you enjoyed the video. 😊

I'm so sorry to hear that. If you'd like, send me a copy of your file at info@spreadsheetlife.com. Remind me where you go stuck, and I will do what I can to help. 😊👍

Yes, you would have to add more rows underneath each date, and more columns to the event table.

Yay!! I'm so glad you found this video helpful! 😄 And that's a great question. Send me an email at info@spreadsheetlife.com, and I can quickly show you how to do something like that. 👍

So this calendar is only designed to display the date. For a calendar that allows for notes and events, I put together this video instead. th-cam.com/video/bwcughyS5PQ/w-d-xo.html

That might be a stretch for what this template is capable of. Your are welcome to give it a try, but it might work out. It's hard to say without some more context.

Thank you so much for your kind words. 😊

I'm sorry this did not work for you. If you have any questions about it, I'd be happy to help. 😊👍

Thank you for watching, and for the purchase! That is a great question. You can indeed move Excel spreadsheets from one workbook file to another. What you have to do is open both workbooks, then right-click on the sheet tab that you want to move, and select Move or Copy. Under "To book", select the other spreadsheet, and click Ok. I hope this helps.

Yes, this is possible. But it will require some extra conditional formatting rules. If you're interested in learning more, send me an email at info@spreadsheetlife.com.

That's so incredible to hear!! 😄🎉 Thanks for the feedback, and I'm so glad it worked out.

I'm so glad you enjoyed the video! Thank you for watching. 😊 So this calendar in particular cannot display or hold any events. However, I did make another set of two videos that show how to create a calendar that can contain event info. You can see part one here: th-cam.com/video/bwcughyS5PQ/w-d-xo.html

Let me see if I can help. So VLOOKUP references B7 because it wants to look at the date that's in that cell and use it as the lookup value. The VLOOKUP function then references the Events table and searches for that lookup value (from B7). Once it finds that date, it returns the corresponding value in the 2nd column (because we enter a 2). So that's what is going on. Now if that makes sense, and you still can't figure it out, send me an email at info@spreadsheetlife.com, and attach your file. I will take a look at it and see if I can help! 😊

Yay!!!! 😄🎉

Thank you for your kind words! 😊

Send me a email at info@spreadsheetlife.com. Share your spreadsheet with me, and I will see if I can help. 👍

😄👍

I'm so glad you enjoyed it!! Thank you for watching! 😊

Hmmm...I'm not sure I quite understand. My best advice is for you to send me an email at info@spreadsheetlife.com with a little more detail about what you are looking for, and I will do my best to help. 😊👍

See my response to your other comment. 😊👍

I'm so glad you enjoyed the video! 😊 As for your request, let me think...hmmm...so I don't have any videos that cover creating anything that comprehensive. I will see if I can make one in the future, but for now I don't have much to offer. I do however have a few spreadsheets on my website that may help, but still nothing that involved. You can see them here: spreadsheetlife.com/product-category/google-sheets/task-management-gs/ I'm sorry I don't have quite what you are looking for at the moment.

Thank you so much for watching!! Happy New Year to you as well from Dallas, Texas!

Thank you so much for your comment and your sub!! I will do my best to keep good content coming! 😊👍

I'm so glad that you enjoy the video and the template! 😄 That's a good question. You can certainly add cell protection to cells to prevent them from changing, but it might be a more tedious process than you were hoping for. My best advice is for you to check out this article to guide you through the process: spreadsheetlife.com/spreadsheet-protection-in-google-sheets/

Thank you so much for your kind words Paul! 😊 Happy New Year to you too, and may you crush all of your New Year's Resolutions with confidence and success!!

Thanks so much! I'm glad you enjoyed the video. I'm sorry you are struggling with the formulas though. If you'd like, email me at info@spreadsheetlife.com, and attach your Excel file. I can then try to troubleshoot the problem for you.

Did you rename the table to "Events?" This might be the issue.