Thank you, I took my time to follow your lectures and follow through for my usage. Your lectures is one of a kind
@spreadsheetlife
5 ай бұрын
Thank you so much for your kind compliment! I hope you enjoy using the Attendance Tracker!
@thepeytonshow4403
5 күн бұрын
This is an amazing informative video. My f4 won’t work and my sheets is telling me that I can only put two arguments max but this was amazing
@spreadsheetlife
2 күн бұрын
Thank you so much. I'm so glad you found this video so informative. I'm sorry you were having trouble with the F4 key though.
@meaganlong2055
Жыл бұрын
I really like the colors for this one! Also, it was so fun and easy to make. I like getting in the practice on Google Sheets! Can't wait for the next one!!
@spreadsheetlife
Жыл бұрын
That's so awesome to hear! Thank you for the feedback!
@SalAbraham7
10 ай бұрын
@@spreadsheetlife I have similar but students scan their card containing QR Code to track their attendanceand record it in Google Sheet similar to this one. the check is based on wings ffont and funtions
@spreadsheetlife
9 ай бұрын
That sounds pretty cool! Thanks for sharing!
@sarran09
6 ай бұрын
VERY WELL EXPLAINED STEP BY STEP. THANKS ALOT FOR GUIDANCE
@spreadsheetlife
6 ай бұрын
Thank you so much for the feedback. I'm glad you found this video helpful! 😄👍
@Stellaaahmanella
Жыл бұрын
Wonderful tutorial, thank you for being so precise and well-spoken.
@spreadsheetlife
Жыл бұрын
Thank you so much for your kind words and feedback! I'll do my best to continue creating high quality content!
@ugommauche-mbanali7532
18 күн бұрын
THANK YOU SO MUCH ! MINE TURNED OUT GREAT.
@spreadsheetlife
18 күн бұрын
That's so amazing to hear!! 😄🎉👍
@anisulislam996
6 күн бұрын
Thanks a lot.
@spreadsheetlife
5 күн бұрын
You're very welcome! 😄👍
@akr4596_
10 күн бұрын
Hi, this is great, thank you! How would I be able to add an attendance trigger function, for example: 3 occurrences of not attending within 26 weeks, 5 in 52 weeks etc or 3% over 52 weeks?
@spreadsheetlife
10 күн бұрын
You'd have to come up with a specific formula based on the specific trigger you want. If you have a specific scenario or trigger in mind, send me an email at info@spreadsheetlife.com, and I can give you a suggestion or two.
@gloriamoore5342
3 ай бұрын
What if do it monthly? i need to track attendance every Sunday of each month..and i f wanted to track it by year, would i just create a new tab by copying and pasting the info from the previous year?
@spreadsheetlife
3 ай бұрын
I may have a suggestion for you, but before that I'd like to clarify your question first. So you are trying to track the attendance for only the Sundays or each month (and no other day), and then tack that attendance over the course of the year? Is that correct?
@iamcrystal5156
7 ай бұрын
Nevermind! I realized my mistake. You have a new subscriber
@spreadsheetlife
7 ай бұрын
Glad you got it to work! And thanks so much for watching and subscribing!!
@nirvana4life66
6 ай бұрын
im having the same problem, but with adding new weeks. it stops after the 5th week. I want to add a new week at the beginning after the names. then when i add new names i would onlu drop down the row starting at the new week. I dont want it to count attendance for the new people before they joined.
@spreadsheetlife
6 ай бұрын
Send me an email, and it will be easier for me to help there than just in this comment section. spreadsheetlife.com/contact/
@vanessajackson1702
6 күн бұрын
Hey there. I loved the confidence you helped build as I toggled back and forth between your tutorial and my google sheets screen. But I 'm having a hiccup - and I don't know how the heck to troubleshoot :) Where should I go for help?
@spreadsheetlife
5 күн бұрын
That's awesome! I'm so glad that this video has helped your confidence! 😊 If you need help, send me an email at info@spreadsheetlife.com. Let me know it's you and what you question is. 👍
@parthshr7
5 ай бұрын
Crystal clear explanation
@spreadsheetlife
5 ай бұрын
😄👍
@ChuksEmmanuel
Жыл бұрын
Beautiful tutorial, thank you for being so direct and straight. Please is there a way to automate this attendance with the data coming from a google form
@spreadsheetlife
Жыл бұрын
Thank you so much for your feedback! I'm thrilled that you enjoyed the tutorial! And that is a great question. Unfortunately there is no simple and easy way to automate this attendance sheet with a Google form. It would take some time to figure out, and I'd have to make another video to provide a full answer to this question. I will make note of it, and perhaps make a follow up video in the future. But I am so sorry I cannot provide a simple answer to you in this comment.
@iamcrystal5156
7 ай бұрын
Great video! I noticed the count is stopping at certain cell. When I add additional names they're not counted in the overall count. Please help
@shivanandchauhan9334
7 ай бұрын
Your video is helpful for me and I make this.
@spreadsheetlife
7 ай бұрын
That's so awesome to hear, and I'm so glad you found it helpful!
@ClarkTucher
3 күн бұрын
Hi, I really like the organization of this spreadsheet however the issue that I'm running into is it does not account for scheduled days. Is there any way to edit it to include different scheduled days on and off for each associate?
@spreadsheetlife
2 күн бұрын
Here is one thing you can do. If you delete the checkbox for the days that someone is not scheduled, then it won't count as a Yes or a No. So just leave the checkboxes in the cells for the days that each person is scheduled, and that should do the trick I think.
@MelvinBenjamin-st1ov
5 ай бұрын
And i sincerely appreciate u for it bruv u are the best
@spreadsheetlife
5 ай бұрын
😊👍😊
@paramiwijesundara9016
2 ай бұрын
THANK YOU BROTHER. I DO IT
@spreadsheetlife
2 ай бұрын
That's awesome!! Way to go! 😄
@margarethalejandracortes8647
8 ай бұрын
Thank you so much, this was very helpful! new subscriber
@spreadsheetlife
8 ай бұрын
So glad that you found this video helpful!! 😄
@MRehan92
4 ай бұрын
Thanks a lot for this video.....❤
@spreadsheetlife
4 ай бұрын
You're very welcome! 😊👍
@85MA
Ай бұрын
Amazing work! I followed the tutorial exactly as you taught us. However, I wanted to download it as an Excel file, but the file isn't working. Could you please show us how to convert this file into MS Excel? Thanks in Advance!
@spreadsheetlife
Ай бұрын
Thank you so much! I'm glad you were able to follow along and complete the spreadsheet. Unfortunately, this template was not originally designed to be converted to Excel. However, if you are using the most updated version of Excel, it is possible. When you download the Google Sheets spreadsheet as an Excel file, all of the checkboxes will have transformed into FALSE values. They will probably show up as ### because the cells are not large enough to show FALSE. You can fix this by replacing all of the FALSE values with checkboxes by going to Insert > Checkbox. Again, this will only work if you have the most up to date version of Excel. I hope this helps.
@venariyadassana8216
10 ай бұрын
Very helpful, thanks a lot.
@spreadsheetlife
10 ай бұрын
Of course! So glad you found this helpful!
@iamkingrobert
5 ай бұрын
For some reason which i don't know, the formula is not working properly. when i check for someone it affects someone else, please can you share the formulas here or in response. I really need this, thank you for such a great content
@spreadsheetlife
5 ай бұрын
Where are you located? Depending on your location settings, your formulas might require semi-colons instead of commas. This might be the issue.
@iamkingrobert
5 ай бұрын
Oh okay, I did not know that. I am located in Accra, Ghana. Please what should i do different? @@spreadsheetlife
@spreadsheetlife
5 ай бұрын
Try using semi-colons in place of commas within your formula. If that still doesn't work, let me know.
@iamkingrobert
5 ай бұрын
Hi, i have tried it again and it still did not work. @@spreadsheetlife
@spreadsheetlife
5 ай бұрын
Ok. Let's see, could you possible take a screenshot or maybe even share the file with me so I can take a look at it? You can send me an email at info@spreadsheetlife.com.
@kabwechola7141
4 ай бұрын
Thank you for your patience. How can I get the total attendance formula for each day?
@spreadsheetlife
4 ай бұрын
Hmmm...total attendance formula for each day. I'm a little confused about what you are asking. Could you rephrase your question for me?
@SalAbraham7
10 ай бұрын
have similar but students scan their card containing QR Code to track their attendanceand record it in Google Sheet similar to this one. the check is based on wings ffont and funtions
@spreadsheetlife
10 ай бұрын
Very cool! Thanks for sharing!
@ProductofGodmercy
6 ай бұрын
Thank you so much
@spreadsheetlife
6 ай бұрын
You're very welcome!
@tal7atal7a66
Жыл бұрын
professional content ❤
@spreadsheetlife
Жыл бұрын
Thank you so much for your kind words.
@natashaxdress
3 ай бұрын
Very HELPFUL !!!! Thank you so much !!! Do you post to your IG too, so easier for us to track what tutorial you post on your youtube ?
@spreadsheetlife
3 ай бұрын
You are very welcome!! 😄 I actually don't have an IG. Do you think I should get one? 🤔
@natashaxdress
3 ай бұрын
@@spreadsheetlife 😏 yes so i can follow you . 😂 I mean people will follow you, they will know the preview of ur newest tutorial so we can check your youtube whenever we find a new video from you
@spreadsheetlife
3 ай бұрын
Okedokie! I will seriously consider getting an IG then. Thank you for the suggestion. I'm not sure how soon I'll have it up and running, but hopefully it won't be too long. Thank you again for the encouragement. 😄
@CastlefordCameraClub
7 ай бұрын
Great Tutorial, Thank you. is there a way to have the names in alphabetical order and if you need to add in a new person/name keep it all alphabetically arranged?
@spreadsheetlife
7 ай бұрын
Thank you for your feedback. That's a good question. For this setup in particular, the best solution is to type in the names, select them, right-click, view more cell actions, sort range. Then start logging the attendance data. After that, for new names, it would probably be easiest to add in the names in the proper place to keep everything in alphabetical order. Just select the row where the name should go, right-click, insert a row above or below, and add the new name. I hope this helps.
@SaraMcleod-x2e
2 ай бұрын
This is so helpful, thank you! I am implementing this tutorial for staff attendance of organization wide events throughout the year. Is there a way to adjust the formulas so that if an employee is either out on leave or was not yet employed at the time of the event, their overall attendance percentage will not be affected? Ideally this would look like a third option other than yes or no, I suppose? Would love to get your input!
@spreadsheetlife
2 ай бұрын
You are very welcome! Super glad you found this helpful. 😊 And that's an awesome question. There is an easy way to do this. All you have to do is delete the checkbox for that specific instance. The formulas are written to count either checked or unchecked boxes. So if you just delete the checkbox, it will not affect the attendance percentage at all. That would be your third option. 👍 Also, to delete a checkbox, select the cell with the checkbox and press the delete key on your keyboard. I hope this helps!
@SaraMcleod-x2e
2 ай бұрын
@@spreadsheetlife I'm so glad to know it's an easy work around! Thank you!
@spreadsheetlife
2 ай бұрын
You're very welcome! 😊👍
@arthurkawalewale6241
Жыл бұрын
Is there a way to export it to excel and maintain the checkboxes?
@spreadsheetlife
Жыл бұрын
That's a great question. Unfortunately, it is not possible to do so. Excel handles checkboxes differently, so the functionality would be lost if you were to export this spreadsheet into Excel. However, I'll make a note to try to create a future video building something similar in Excel.
@LocsofBeautytv
9 ай бұрын
What if you wanted to track PTO, Sick Time, and VTO as well?
@spreadsheetlife
9 ай бұрын
Good question. In that case, you would need to implement a different solution than this video presents. You are welcome to email me and I can assist further.
@Mars4bar7
4 ай бұрын
Is it ok for me to create in excel without any License issues? Or is this for my household use only?
@spreadsheetlife
4 ай бұрын
If you can re-create this in Excel, you are welcome to share it with whoever your please. 😊👍 There are no license issues to worry about if you make it from scratch!
@SanJoEsca
Жыл бұрын
Is it possible to connect this one with a QR code scanner so that the attendance will be checked using the employees IDs QR code?
@spreadsheetlife
Жыл бұрын
That's a really creative idea! However, I can't think of an easy way to set up the attendance tracker to work with QR codes like you have described. I'm sorry I don't have a better answer for you.
@spcsoftsolutions103
Ай бұрын
There are Google add-ons, such as Comfort Attendance, which can read QR code to mark attendance.
@bboyneon92
Ай бұрын
Formula for yes and no, not functioning consistently in all cells. Please help.
@spreadsheetlife
Ай бұрын
Could you type your formula here so I could take a look at it for you?
@bboyneon92
Ай бұрын
@@spreadsheetlife thank you so much! I had to use the dollar sign and things got sorted out. I really appreciate you responding to my doubt!
@spreadsheetlife
Ай бұрын
Of course! I'm glad that you ended up figuring it out! 😊👍
@Raj-f4s8h
9 ай бұрын
If suppose, the employee has taken half day off! how can we mark this out here? Or any such formula to be used to showcase the half day?
@spreadsheetlife
9 ай бұрын
Unfortunately, there this no way to mark a half-day in this specific spreadsheet. You would have to take a different approach to the setup.
@PowerfulQuotes_Quotation
2 ай бұрын
helpful but, every month dates and days are not same......
@spreadsheetlife
2 ай бұрын
That is true, but this tracker is organized by week instead of by month. If you'd like to see an Attendance Tracker organized by month instead, check out this video. kzitem.info/news/bejne/yZ5pnq1mnpiBiHY Just keep in mind that this alternative Attendance Tracker is designed for Excel rather than Google Sheets.
@umarwan80
Ай бұрын
I could not get the formula right.. Could you type it here
@spreadsheetlife
Ай бұрын
The best way for me to help would be for you to type your formula as you've written it. This way, I can see what needs to be corrected. 😊👍
@ameenahmd4386
2 ай бұрын
Only the 'No' section isn't working on my sheet. Can anyone please help me to type the code of yes & no here :) 8:32 ❤
@spreadsheetlife
2 ай бұрын
For sue. What does your current formula look like?
@DavidHill-mc6dq
8 ай бұрын
Is there a way to lock the sheet so it can't messed up? I'm thinking of having students check the boxes as they enter class. One wrong check and potentially all formulas get messed up!
@spreadsheetlife
8 ай бұрын
Yes. Under the Data tab, you will find a command called Protected Sheets & Ranges. This will allow you to lock certain portions of the spreadsheet. I also wrote an article on this topic a while back. spreadsheetlife.com/spreadsheet-protection-in-google-sheets/
@spcsoftsolutions103
Ай бұрын
Instead of opening up the sheet, you can consider add a Google add-on, such as Comfort Attendance, which creates a web app on the sheet to just track the attendance on current date.
@FilipHalvarsson
5 ай бұрын
Please help me when I type in the formula for the yes box it says error what ever i do even though I wrote it exactly as u did, please help
@spreadsheetlife
5 ай бұрын
For sure! Email me a screenshot at info@spreadsheetlife.com, and I can help.
@FilipHalvarsson
5 ай бұрын
@@spreadsheetlife thank you for wanting to help me out, but it happened to be that my docs formulas was based on another language than English so I just changed it to English and the formulas worked. Amazing video tho!
@spreadsheetlife
5 ай бұрын
I'm so glad you were able to figure it out, and thank you for letting me know!
@islamabdul6133
Ай бұрын
HEY I WANTED TO ADD MORE WEEKS AFTER I DID 3 WEEKS HOW TO DO IT
@spreadsheetlife
Ай бұрын
Follow the exact steps that I demonstrate at 13:28 in the video. 😊👍
@ailynparrera2509
8 ай бұрын
I have no checkbox in my insert, how to have the checkbox
@spreadsheetlife
8 ай бұрын
Are you working in Google Sheets? If you are in Excel, this may be the issue. At the time of this comment, only the Beta version of Excel supports checkboxes.
@_animesh.gaming
2 ай бұрын
Sir what is Yes and No refers to
@spreadsheetlife
2 ай бұрын
Here are what the Yes and No refer to. Yes - the person was present No - the person was not present
@skinnylages
Ай бұрын
Hiw can i add the permition tab for this attendance
@spreadsheetlife
Ай бұрын
Hi there. I'm so sorry, but I do not understand your question. Could you please re-phrase it for me?
@skinnylages
Ай бұрын
@@spreadsheetlife what if a student ask for permission
@spreadsheetlife
Ай бұрын
Oh ok. So are you asking - how do you enable the spreadsheet to allow for excused absences when the student has a valid reason to be absent?
@skinnylages
Ай бұрын
@@spreadsheetlife yes
@spreadsheetlife
Ай бұрын
Ok. So the easiest way to handle this is to delete the checkbox in any cell where the student has an excused absence. So if they are present, check the box. If they are absent, leave the box unchecked. If they have an excused absence, delete the checkbox. I hope this helps.
@Orchid8244
Жыл бұрын
success 😍
@spreadsheetlife
Жыл бұрын
So glad you were able to accomplish it! 😊👍
@PUPIncredABELS
Жыл бұрын
what can I do if the formula did not work?
@spreadsheetlife
Жыл бұрын
Check that your formula is correct. If you are still having trouble, check that you followed the steps correctly. I'm sorry I can't help more without more context.
@tobrighterdays
Ай бұрын
My F4 key is not working
@spreadsheetlife
Ай бұрын
On many keyboards, the F4 key shares a key with another one. You may have to press Fn and F4 at the same time to get it to work for you.
@jawwadkhan2208
9 ай бұрын
Percentage Formula =If(C7+D7=0 , 0 , C7/(C7+D7))
@spreadsheetlife
9 ай бұрын
Hi there! Are you asking why this formula is written this way?
@jawwadkhan2208
9 ай бұрын
No No Just Copy Pasting Great Video BTW !
@spreadsheetlife
9 ай бұрын
Ok awesome! Just wanted to be sure. I like to answer as many questions as I can. And thanks so much!
@ameenahmd4386
2 ай бұрын
Only the 'No' section isn't working on my sheet. Can anyone please help me to type the code of yes & no here :)
@spreadsheetlife
2 ай бұрын
Formula for Yes in cell C7: =COUNTIFS($H$5:$HF$5, TRUE, H7:HF7, TRUE) Formula for No in cell D7: =COUNTIFS($H$5:$HF$5, TRUE, H7:HF7, FALSE) I hope this helps.
@9629995279
6 ай бұрын
Really nice. How to track the attendance for a hybrid model like any 3 days in office. Pls help
@spreadsheetlife
6 ай бұрын
Great question. If you send me an email, I will be able to help better there!
Пікірлер: 133