Loved the step by step. Planning to homeschool and this is exactly what I needed to keep track. ❤

@spreadsheetlife

Ай бұрын

Awesome! So glad you found this video helpful! 😊

This is great! Going to start building and tweaking to fit my needs, but this is perfect! Thank you so much!

@spreadsheetlife

3 ай бұрын

So glad that found this video and that it's helpful!! Good luck with the build!! 😄👍

This was a wonderful step by step guide. It works perfectly!! Thank you!

@spreadsheetlife

Ай бұрын

So glad you enjoyed it and successfully completed it! 😄👍

This is great! thanks a lot! can you also add if i want to see per month on the summary tab please. thanks

@spreadsheetlife

Ай бұрын

Super glad that you found this helpful! And this should be possible. If you could send me an email at info@spreadsheetlife.com, it will be easier for me to show you how to do this there.

Thank you!!!

Thank you so much. I love your content, keep going!

@spreadsheetlife

4 ай бұрын

Thank you so much for your encouragement! I will keep it up the best I can!

This is so DOPE!

@spreadsheetlife

3 ай бұрын

😄👍😊

Thank you so muchh👍

@spreadsheetlife

27 күн бұрын

You are so welcome! 😊

thanks alot

@spreadsheetlife

6 күн бұрын

😄👍

Its very useful i did the same....tracker was superr....but i need to add sick leave and privileged leave kindly guide

@spreadsheetlife

27 күн бұрын

So glad you found this tutorial useful! If you'd like me to add custom functionality to this template or build a different type of tracker for you, you can always send me a request at this link. spreadsheetlife.com/custom-development/

this is very useful and clear to follow. thank you. but my percentage column is not properly working in the summary sheet. I have done exactly as you have shown but my C column (that reflects the D column in numbered percentage) shows up as ###### if there is any data on it. if there is no data, it just shows up as 0%. it works fine for the monthly sheets but I cant seem to find the problem for the summary sheet. could you please help?

@spreadsheetlife

2 ай бұрын

I can help for sure. Could you email me your file or a screenshot at info@spreadsheetlife.com? This way, I can more easily take a look at it for you.

This is for advanced learners

@spreadsheetlife

2 ай бұрын

I do my best to demonstrate the step-by-step process to make it simple to follow along, and I also try to include some advanced features so even seasoned Excel users have new things to learn. 😄👍

What's the formula at 14:49 if you want to consider excuses, and sick the same as absent so that the percentage will be lower when you track it? (For example: 1 present, 1 sick, 1 excuse, 1 absent, you will only get 25% of the percentage rather than 75%)

@spreadsheetlife

13 күн бұрын

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

Thanks so much, I've been trying to make an attendance tracker for ages. Is there a way to separate the percentages (yes% or no%) or make the X negligible?

@spreadsheetlife

3 ай бұрын

You're very welcome. 😊 I'm not sure what you mean by separate the percentages. Could you clarify a little for me? As for the X. If you never enter an X, and only enter Y and N, then the Attendance Tracker will still work just fine. Does this answer your question?

@pennyp9360

3 ай бұрын

Hi Thanks for responding. Is there a way to show a percentage for y and a percentage for n instead of combing them as one. Hopefully that makes sense. Im new to excel 🫤🤯

@spreadsheetlife

3 ай бұрын

Of course! Yes, this is possible. If you'd like, send me an email with your completed spreadsheet. I can add in those percentages for you on the Summary page, and then send it back to you with a brief explanation. How does that sound?

@pennyp9360

3 ай бұрын

@@spreadsheetlife That is amazing.. thanks so much!!!🙂🙂

Would this work in the exact method and with thesame formulas in Google Sheet?

@spreadsheetlife

9 күн бұрын

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

=IF(COUNTA(F4:AJ4)0,0,1-AM4/COUNTA(F4:AJ4)) What can I add to this formula in order to add a date range as a criteria as I want to make a weekly tracker?

@spreadsheetlife

Ай бұрын

What an interesting idea. To better answer your question, could you give me some more details about how you would like your weekly tracker to work?

The =sum(jan:dec!al4) formula gives me an error. Can someone advise?

@spreadsheetlife

3 ай бұрын

You are welcome to send me an email with your file attached, and I can take a look at it for you.

The =sum(jan:dec!al4) formula gives me an error too! How can I fix it

@spreadsheetlife

2 ай бұрын

Hmm...it's hard to say without more context. Send me your file at info@spreadsheetlife.com, and I can take a quick look at it for you if you'd like.

good day can you help. I want to count the X for (excused ) with my percent

@spreadsheetlife

2 ай бұрын

I will do my best to help for sure! So as shown in the video, all X (or excused absences) will be counted as Yes values essentially for the percentage. Are you wanting to have the X count as a No instead towards the percentage?

How can I only calculate the Yes's for attendance?

@spreadsheetlife

3 ай бұрын

In other words, are you asking how to write the formula so that only "Yes" counts and both "No" and "Excused" do not count?

@naailah1231

3 ай бұрын

​@spreadsheetlife Yes, just need to record the Ys. Also this tutorial was incredibly helpful ❤

@spreadsheetlife

3 ай бұрын

I'm so glad to hear that this tutorial is helpful! For the formula, change the formula at 18:50 to the following. =IF(SUM(F6:H6)=0,0,F6/SUM(F6:H6)) This will make it so only Yes will count towards the percentage.