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
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.
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.
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
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.
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 ?
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 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, Uncle!!!! I was able to create a working attendance sheet for the first time ever!!!
Most welcome
Best tutor ever. Thank you
Most welcome
THANK YOU THANK YOU....JUST NOW I WAS CONFUSED THIS VIDEO REALLY HELPED A LOT JUST PERFECT
Most welcome
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🙏
absolutely Knowledgeable content, thankyou so much
Most welcome
When we are changing the month we are not getting a fresh sheet but with previous month data on the next month
Hi good teaching to make google sheet on attendance
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.
Helpful information 👍👌👌👌
Thanks🙏
I am not satisfied, how we can update the weekly off and holiday in every 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
thank youuuu
Thanks Brother
Welcome
Respected,
Dropdown Option is not showing in office 365 online
Excellent
Thanks
Thank you for this!
My pleasure!
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
Nice work it will be helpful if you add the template link
Thanks.. will add
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.
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?
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 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.
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
How do you calculate the percentage?
You can check the formula in the template. Link is given description box.
Hello! Thank you for this! May I have permission to use your template for public use?
hello brother, if we go to the next month to mark attendence it is already showing the previous month attendence
yeh fake tutorial
Hey PK, nice video
Thanks
This template Download link plz🙏🙏🙏
how to get the total present/absent per day? it only shows the info per employee
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?
why the number format is not working in my speadsheet? what should i do
fx = 0 in my google sheet how i can fix it ?
But when i am dragging the dates… it is not working
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
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
why present absent not updating to default ?
Sir the count if formula is not getting applied. Pls help.
Drop-down ko kaise change karen month wise isska koi video banna do 🙈
Will try explain in the next version of it
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!
How to filter absent name list ?
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.
Dear sir
Tutorial is helpful but,request for the Hindi language
Noted
Magnifique tutoriel. Est ce possible de nous faire même sur Excel
muchas gracias
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 to store the data like May month April month june month Can u please can me how to store
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.
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