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 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
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.
PERFECT EXPLANATION, AND I FOLLOWED EVERY STEP YOU SAID AND I GOT MY OWN ATTNEDENCE SHEET, THANKS FOR THAT. I USE IT AS A TEACHER. THAT IS VERY HELPFUL, THANKS AGAIN. (BUT I HAVE SOME PROBLEMS, IF YOU CAN HELP ME, I WOULD BE REALLY HAPPY, I WAIT YOUR REPLY, THANKS IN ADVANCE.)
That's amazing!! 😄 It's incredible to hear that you've gotten so much out of the template so far. If you do have further questions though, just send me an email at info@spreadsheetlife.com. I will help if I am able. 👍
I made it a little different by adding classes to each day. For example, there are five hours (checkboxes) under Monday to Thursday and three ones under Friday. The best thing about this is that I can work on my phone as well. Thanks a lot. Now I need to know how to make a copy, a backup of this sheet every week. I know that it keeps the history of changes but I need to have backups every day, just in case.
That's amazing to hear. I'm glad you were able to custom it to fit your setup. To make a copy, just go to File > Make a Copy. This will allow you to create a copy of the entire spreadsheet. 😊👍
Gotcha. The method you described will make a copy of that specific worksheet tab within the spreadsheet itself. So you have different options to pick from for sure.
@@spreadsheetlife yeah. I started using the second one to track submitted assignments (that are sent via email), though, I might start using Google Classroom for that, it has assignment functions. I haven't decided yet.
Thanks! I was able to follow and get the idea right away. Just curious, it is possible of the excel offline but I don't know if applicable or how to do it on google sheets though. The thing is, if the month and the year is change, the whole data is changed accordingly but on the same page. It was about the data validation and the criteria something I think. Do you happen to know how to do it in googlesheet?
Hi there! Did you mean to leave this comment for a different video? This is a Google Sheets video and there is no year and month selection. Let me know if you were asking about a different video.
Thank you so much bro you are a lifesaver fr i have a lil question if there are too many employees how to add a separate row to calculate number of employees & also the first employee's name starts from row 7 how to make it start from number to 1 to so on & so forth!!
Yes, I'm sure you could modify it that way. You'd have to change a few things though such as the formulas, and maybe replace the checkboxes with numbers.
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?
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.
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?
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.
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
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.
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?
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?
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?
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.
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.
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!
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!
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
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?
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. 👍
That's amazing! And you are a genius!! There is a unique genius in everyone, and that includes you! 😊👍 I'm so glad you were able to figure it out and get it working. 😄
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.
@@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
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. 😄
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.
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!
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!
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.
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.
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!
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/
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.
Hello, please can you help. The formula isn't really working, when i press the F4 it doesn't change it just keeps showing the F4. Sorry for the disturbance.
No need to be sorry at all. I'm here to help. If you can't get F4 to work, what you can do is type in the dollar signs manually. If you do that, the formula should still work the same way. Let me know if this works for you.
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
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.
@@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!
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.
What an interesting issue. If you'd like, send me an email at info@spreadsheetlife.com. Include a link to your spreadsheet, and I can take a look at it for you.
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. th-cam.com/video/hh38y0efPUA/w-d-xo.html Just keep in mind that this alternative Attendance Tracker is designed for Excel rather than Google Sheets.
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.
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.
Thank you so much for a simple and detailed explanation. I have been able to create my own attendance tracker using the steps in this video.
That's so amazing to hear! Thank you for watching and letting me know! 😄
VERY WELL EXPLAINED STEP BY STEP. THANKS ALOT FOR GUIDANCE
Thank you so much for the feedback. I'm glad you found this video helpful! 😄👍
I AGREE 100%
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!!
That's so awesome to hear! Thank you for the feedback!
@@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
That sounds pretty cool! Thanks for sharing!
Wonderful tutorial, thank you for being so precise and well-spoken.
Thank you so much for your kind words and feedback! I'll do my best to continue creating high quality content!
Thank you, I took my time to follow your lectures and follow through for my usage. Your lectures is one of a kind
Thank you so much for your kind compliment! I hope you enjoy using the Attendance Tracker!
Nevermind! I realized my mistake. You have a new subscriber
Glad you got it to work! And thanks so much for watching and subscribing!!
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.
Send me an email, and it will be easier for me to help there than just in this comment section. spreadsheetlife.com/contact/
This was FANTASTIC! Thank you so much!!
Of course! Thank you for watching!! 😄
Thank you. This video helped me a lot.
That's so awesome to hear. Thank you for letting me know. 😊
You did a fantastic job explaining. Thank you so much.
Thank you so much for your feedback and for watching!! 😄
PERFECT EXPLANATION, AND I FOLLOWED EVERY STEP YOU SAID AND I GOT MY OWN ATTNEDENCE SHEET, THANKS FOR THAT. I USE IT AS A TEACHER. THAT IS VERY HELPFUL, THANKS AGAIN. (BUT I HAVE SOME PROBLEMS, IF YOU CAN HELP ME, I WOULD BE REALLY HAPPY, I WAIT YOUR REPLY, THANKS IN ADVANCE.)
That's amazing!! 😄 It's incredible to hear that you've gotten so much out of the template so far.
If you do have further questions though, just send me an email at info@spreadsheetlife.com. I will help if I am able. 👍
I made it a little different by adding classes to each day. For example, there are five hours (checkboxes) under Monday to Thursday and three ones under Friday. The best thing about this is that I can work on my phone as well. Thanks a lot.
Now I need to know how to make a copy, a backup of this sheet every week. I know that it keeps the history of changes but I need to have backups every day, just in case.
That's amazing to hear. I'm glad you were able to custom it to fit your setup.
To make a copy, just go to File > Make a Copy. This will allow you to create a copy of the entire spreadsheet. 😊👍
@@spreadsheetlife Yeah. Usually, I just rightclick on the tab below and select Dublicate
Gotcha. The method you described will make a copy of that specific worksheet tab within the spreadsheet itself. So you have different options to pick from for sure.
@@spreadsheetlife yeah. I started using the second one to track submitted assignments (that are sent via email), though, I might start using Google Classroom for that, it has assignment functions. I haven't decided yet.
Thanks! I was able to follow and get the idea right away.
Just curious, it is possible of the excel offline but I don't know if applicable or how to do it on google sheets though.
The thing is, if the month and the year is change, the whole data is changed accordingly but on the same page. It was about the data validation and the criteria something I think.
Do you happen to know how to do it in googlesheet?
Hi there! Did you mean to leave this comment for a different video? This is a Google Sheets video and there is no year and month selection. Let me know if you were asking about a different video.
Thank you so much bro you are a lifesaver fr i have a lil question if there are too many employees how to add a separate row to calculate number of employees & also the first employee's name starts from row 7 how to make it start from number to 1 to so on & so forth!!
To better answer your questions, send me an email at info@spreadsheetlife.com. I can help more there! 😊👍
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
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.
Your video is helpful for me and I make this.
That's so awesome to hear, and I'm so glad you found it helpful!
is there a way to use this with a point sysytem example present late behavior and uniform
Yes, I'm sure you could modify it that way. You'd have to change a few things though such as the formulas, and maybe replace the checkboxes with numbers.
THANK YOU SO MUCH ! MINE TURNED OUT GREAT.
That's so amazing to hear!! 😄🎉👍
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
Thank you so much, this was very helpful! new subscriber
So glad that you found this video helpful!! 😄
Great Video. Thank you so much.
Wanted to ask why my numbers are different from yours even though i marked the same day as you did?
I saw your email and sent back a response. 😊👍
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?
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.
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?
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.
Thanku so much
Thank you so much for watching! 😄
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
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.
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?
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?
Did you ever make a spreadsheet to track Sunday attendance ? If so would you mind sharing your template?
I did not . I never got a response to clarify the question, so I couldn't move forward unfortunately.
Thank you for your patience. How can I get the total attendance formula for each day?
Hmmm...total attendance formula for each day. I'm a little confused about what you are asking. Could you rephrase your question for me?
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?
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.
Is there a way to export it to excel and maintain the checkboxes?
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.
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!
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!
@@spreadsheetlife I'm so glad to know it's an easy work around! Thank you!
You're very welcome! 😊👍
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 ❤
For sue. What does your current formula look like?
And i sincerely appreciate u for it bruv
u are the best
😊👍😊
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
Very cool! Thanks for sharing!
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?
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. 👍
I figured it out!! I'm a genius! Actually, I'm more of a noob, but I'm wildly happy about the discovery.
That's amazing! And you are a genius!! There is a unique genius in everyone, and that includes you! 😊👍
I'm so glad you were able to figure it out and get it working. 😄
thankyou brother
Thanks for watching! 😄
Crystal clear explanation
😄👍
Thanks a lot.
You're very welcome! 😄👍
What if you wanted to track PTO, Sick Time, and VTO as well?
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.
professional content ❤
Thank you so much for your kind words.
Thanks a lot for this video.....❤
You're very welcome! 😊👍
Very helpful, thanks a lot.
Of course! So glad you found this helpful!
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 ?
You are very welcome!! 😄
I actually don't have an IG. Do you think I should get one? 🤔
@@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
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. 😄
THANK YOU BROTHER. I DO IT
That's awesome!! Way to go! 😄
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?
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.
There are Google add-ons, such as Comfort Attendance, which can read QR code to mark attendance.
Is it ok for me to create in excel without any License issues? Or is this for my household use only?
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!
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!
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.
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?
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.
Hiw can i add the permition tab for this attendance
Hi there. I'm so sorry, but I do not understand your question. Could you please re-phrase it for me?
@@spreadsheetlife what if a student ask for permission
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?
@@spreadsheetlife yes
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.
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!
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/
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.
Hello, please can you help. The formula isn't really working, when i press the F4 it doesn't change it just keeps showing the F4. Sorry for the disturbance.
No need to be sorry at all. I'm here to help.
If you can't get F4 to work, what you can do is type in the dollar signs manually. If you do that, the formula should still work the same way. Let me know if this works for you.
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
Where are you located? Depending on your location settings, your formulas might require semi-colons instead of commas. This might be the issue.
Oh okay, I did not know that. I am located in Accra, Ghana. Please what should i do different? @@spreadsheetlife
Try using semi-colons in place of commas within your formula. If that still doesn't work, let me know.
Hi, i have tried it again and it still did not work. @@spreadsheetlife
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.
Thank you so much
You're very welcome!
Formula for yes and no, not functioning consistently in all cells. Please help.
Could you type your formula here so I could take a look at it for you?
@@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!
Of course! I'm glad that you ended up figuring it out! 😊👍
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
For sure! Email me a screenshot at info@spreadsheetlife.com, and I can help.
@@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!
I'm so glad you were able to figure it out, and thank you for letting me know!
I have no checkbox in my insert, how to have the checkbox
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.
I followed all the steps, but in my case, every 2nd row of 7 -14 rows is not in sync on my sheet, so the tracked results aren't 100!!!
What an interesting issue. If you'd like, send me an email at info@spreadsheetlife.com. Include a link to your spreadsheet, and I can take a look at it for you.
success
😍
So glad you were able to accomplish it! 😊👍
HEY I WANTED TO ADD MORE WEEKS AFTER I DID 3 WEEKS HOW TO DO IT
Follow the exact steps that I demonstrate at 13:28 in the video. 😊👍
I could not get the formula right.. Could you type it here
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. 😊👍
helpful but, every month dates and days are not same......
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.
th-cam.com/video/hh38y0efPUA/w-d-xo.html
Just keep in mind that this alternative Attendance Tracker is designed for Excel rather than Google Sheets.
what can I do if the formula did not work?
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.
Sir what is Yes and No refers to
Here are what the Yes and No refer to.
Yes - the person was present
No - the person was not present
why i cant press F4?
On your keyboard, you might have to hold the Fn key to enable the F4 key.
My F4 key is not working
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.
Percentage Formula
=If(C7+D7=0 , 0 , C7/(C7+D7))
Hi there! Are you asking why this formula is written this way?
No No Just Copy Pasting
Great Video BTW !
Ok awesome! Just wanted to be sure. I like to answer as many questions as I can.
And thanks so much!
Only the 'No' section isn't working on my sheet. Can anyone please help me to type the code of yes & no here :)
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.
Really nice. How to track the attendance for a hybrid model like any 3 days in office. Pls help
Great question. If you send me an email, I will be able to help better there!
Sure, give me your email Id
info@spreadsheetlife.com