Thank you! However, in the template, when I change the month, the drop-down button and total attendance remain the same. If possible, I would like the flexibility to customize the drop-down button and total attendance for each month. I would prefer that when changing the month, the drop-down button reverts to its original format, allowing me to customize it anew for each month. Essentially, I want the template to be adaptable and allow for customization of the drop-down button and total attendance every month. Is that possible? Can you make another tutorial? Appreciate it.
Excellent video. In our organisation we are allowed to take half a day leave. I will try to recreate this sheet with an option to mark H . Thanks a lot
well made template , was very useful and added some of uour logic in my version as well. i was trying to find certain calculations like how many people are off on friday/monday/ leaves etc, do you have any suggestions how to acheiev this ?
what if i want to add leave entitilement sick leave,emergency leave,mission,annual leave.how to fomulate that? Thank you.i look like easy for me that excel.more power
Hi! Present and Leave Tabs are Working where numbers are counted but in Absent tab there showed 0 values and nothing changed! Please guide a bit why this is happening
Hi, Your teaching is very much useful. Thanks for the video... But i was trying to add some more options like half day leave and timings of login and logout.. i ended up in confusion.
Wonderful approach sir. But one thing I want to know that how to create dashboard of whole year of all the employee. And also want to know how filter any employee with month wise attendance report.
I have started practicing this. But the formula is not working. I tried multiple times and it still shows 0 in the box of Present. Though i selected the present on two dates. Can you help me to recover this?
I need to clear the cell data on the google sheet when switching from the current month to the next months on the attendance sheet, however the prior months data should be remembered. How to do ?
It's all useless, when you fill the entire sheet for a month and then port it to the next month you will again be back to the previously filled sheet, only the date and month will change.
when you changed the month to October in the end. The Present and absent did not updated to default. Entire lecture of no use, just because of that one mistake.
Thank you, Uncle!!!! I was able to create a working attendance sheet for the first time ever!!!
Most welcome
Thank you SO much!! This has been soooo helpful! I'm an HR Asst and looking for new ways to organize our data and this is PERFECT!
Thanks for your valuable feedback
THANK YOU THANK YOU....JUST NOW I WAS CONFUSED THIS VIDEO REALLY HELPED A LOT JUST PERFECT
Most welcome
Thank you! However, in the template, when I change the month, the drop-down button and total attendance remain the same. If possible, I would like the flexibility to customize the drop-down button and total attendance for each month. I would prefer that when changing the month, the drop-down button reverts to its original format, allowing me to customize it anew for each month. Essentially, I want the template to be adaptable and allow for customization of the drop-down button and total attendance every month. Is that possible? Can you make another tutorial? Appreciate it.
absolutely Knowledgeable content, thankyou so much
Most welcome
Helpful information 👍👌👌👌
Thanks🙏
Excellent video. In our organisation we are allowed to take half a day leave. I will try to recreate this sheet with an option to mark H . Thanks a lot
Most welcome🙏
Best tutor ever. Thank you
Most welcome
well made template , was very useful and added some of uour logic in my version as well. i was trying to find certain calculations like how many people are off on friday/monday/ leaves etc, do you have any suggestions how to acheiev this ?
Excellent
Thanks
Hi good teaching to make google sheet on attendance
I am not satisfied, how we can update the weekly off and holiday in every month??????
Thank you for this!
My pleasure!
Hello! Thank you for this! May I have permission to use your template for public use?
When we are changing the month we are not getting a fresh sheet but with previous month data on the next month
Please share template link it will be helpful for us🙏. Btw it's a very informative video.
Template link has been given in videos description box
Thanks Brother
Welcome
thank youuuu
what if i want to add leave entitilement sick leave,emergency leave,mission,annual leave.how to fomulate that?
Thank you.i look like easy for me that excel.more power
if we are entering data for the next month, data is getting replaced in the original month as well.. how to keep all the months' data stored?
Nice work it will be helpful if you add the template link
Thanks.. will add
Hi! Present and Leave Tabs are Working where numbers are counted but in Absent tab there showed 0 values and nothing changed! Please guide a bit why this is happening
Hi, Your teaching is very much useful. Thanks for the video...
But i was trying to add some more options like half day leave and timings of login and logout.. i ended up in confusion.
I will try to create a separate video on this topic
Very informative and I don't see any change in the data when you go for the next month. It would be helpful if you let us know. Thanks
For the next month we have same inventory
This template Download link plz🙏🙏🙏
After changing month previous attendence data is not changing. Still it's been displaying. Please suggest.
You need to manually remove the old attendance data.
@@NeotechNavigatorshow do you do that? Can you assist? Thank you
Wonderful approach sir. But one thing I want to know that how to create dashboard of whole year of all the employee. And also want to know how filter any employee with month wise attendance report.
Thanks for your valuable feedback. I will try to add in next version.
hello brother, if we go to the next month to mark attendence it is already showing the previous month attendence
yeh fake tutorial
Thank you can you add the tempalte link on description, it will be helpful
Template link is in the description box
@@NeotechNavigators Thank you for the video! It appears that I cannot see the link in the description box. Is it only visible to few people?
Hey PK, nice video
Thanks
why the number format is not working in my speadsheet? what should i do
This is only good for one month. Once you change the month, the present and absences is still showing and not getting back to empty default.
Sir, when I am creating the drop-down, the text is not visible, font size is 8-9-5-4, I have tried everything...plz help
I have started practicing this. But the formula is not working. I tried multiple times and it still shows 0 in the box of Present. Though i selected the present on two dates. Can you help me to recover this?
Respected,
Dropdown Option is not showing in office 365 online
how to get the total present/absent per day? it only shows the info per employee
Magnifique tutoriel. Est ce possible de nous faire même sur Excel
muchas gracias
You should consider freezing the name so when you're scrolling to the far right the names will be aligned with their attendance.
great suggestion!
Drop-down ko kaise change karen month wise isska koi video banna do 🙈
Will try explain in the next version of it
why present absent not updating to default ?
Sir the count if formula is not getting applied. Pls help.
How do you calculate the percentage?
You can check the formula in the template. Link is given description box.
wher is the template i cant find it in te descprtion
Template link has been given in videos description box or visit our website www.NeoTechNavigators.com
How can we add attendance percentage
I need to clear the cell data on the google sheet when switching from the current month to the next months on the attendance sheet, however the prior months data should be remembered. How to do ?
Will create this in next version.
fx = 0 in my google sheet how i can fix it ?
Dear sir
Tutorial is helpful but,request for the Hindi language
Noted
But when i am dragging the dates… it is not working
How to filter absent name list ?
How to store the data like May month April month june month Can u please can me how to store
It's all useless, when you fill the entire sheet for a month and then port it to the next month you will again be back to the previously filled sheet, only the date and month will change.
How do we unselect data selected
Just put False in one cell then copy to all
@@NeotechNavigators thank you
when you changed the month to October in the end. The Present and absent did not updated to default. Entire lecture of no use, just because of that one mistake.
Same issue have you got the solution if yes pls help