Create Attendance Template in Google Sheet | Complete Process

[@rei_rei]

Thank you, Uncle!!!! I was able to create a working attendance sheet for the first time ever!!!

[@NeotechNavigators]

Most welcome

[@KellyCook-k7w]

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!

[@NeotechNavigators]

Thanks for your valuable feedback

[@ZenaNassir]

THANK YOU THANK YOU....JUST NOW I WAS CONFUSED THIS VIDEO REALLY HELPED A LOT JUST PERFECT

[@NeotechNavigators]

Most welcome

[@shridharsharma3438]

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

[@NeotechNavigators]

Most welcome🙏

[@understandthewordsfeelthes3036]

Helpful information 👍👌👌👌

[@NeotechNavigators]

Thanks🙏

[@Ssquarecreations]

absolutely Knowledgeable content, thankyou so much

[@NeotechNavigators]

Most welcome

[@stitches_by_anthonia]

Best tutor ever. Thank you

[@NeotechNavigators]

Most welcome

[@zelgt9774]

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.

[@VirosheniMoodley]

Thank you for this!

[@NeotechNavigators]

My pleasure!

[@balajis4632]

Hi good teaching to make google sheet on attendance

[@SidraTahir-rj7dy]

Excellent

[@NeotechNavigators]

Thanks

[@rajyagami]

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 ?

[@gravitex2396]

Very Informative and i did complete by following the steps however there is one issue if you could help on this

[@sonofsadaram6429]

Thanks Brother

[@NeotechNavigators]

Welcome

[@Office-Monk]

Hey PK, nice video

[@NeotechNavigators]

Thanks

[@naazparveen5812]

When we are changing the month we are not getting a fresh sheet but with previous month data on the next month

[@undertfigtree]

Hello! Thank you for this! May I have permission to use your template for public use?

[@tpzrocky2409]

Nice work it will be helpful if you add the template link

[@NeotechNavigators]

Thanks.. will add

[@Rudra-p1c]

Please share template link it will be helpful for us🙏. Btw it's a very informative video.

[@NeotechNavigators]

Template link has been given in videos description box

[@GEOTRANSITEXPRESS]

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.

[@NeotechNavigators]

I will try to create a separate video on this topic

[@mudhurakolasandeep]

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

[@NeotechNavigators]

For the next month we have same inventory

[@rameshhvlogs8099]

thank youuuu

[@kevinryhn14]

Thank you can you add the tempalte link on description, it will be helpful

[@NeotechNavigators]

Template link is in the description box

[@catwhowatchesyoutube9601]

​@@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?

[@AmirIqbalAnsari-c3s]

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?

[@VivekKumar-dy6it]

I am not satisfied, how we can update the weekly off and holiday in every month??????

[@AzeemKhan-jw6mh]

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.

[@NeotechNavigators]

Thanks for your valuable feedback. I will try to add in next version.

[@alaaelhady3674]

fx = 0 in my google sheet how i can fix it ?

[@MadillineOrtiz]

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

[@malatuga1561]

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.

[@OakRealtyRealEstate-l4j]

hello brother, if we go to the next month to mark attendence it is already showing the previous month attendence

[@thoithoithokchom29]

yeh fake tutorial

[@mexicanreformist1522]

You should consider freezing the name so when you're scrolling to the far right the names will be aligned with their attendance.

[@KellyCook-k7w]

great suggestion!

[@vinodkumarmanchu3993]

After changing month previous attendence data is not changing. Still it's been displaying. Please suggest.

[@NeotechNavigators]

You need to manually remove the old attendance data.

[@NadineAlfonso-g4t]

@@NeotechNavigatorshow do you do that? Can you assist? Thank you

[@adilshahzad4672]

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

[@sheikhmateen1610]

Respected, Dropdown Option is not showing in office 365 online

[@sahanabs]

I am applying the countif formula for p a and leave count but it's showing zero the count is not changing... Can u please help me on this wrhere I am doing the mistake

[@arrahimhossinrodro714]

This template Download link plz🙏🙏🙏

[@CarlAndreiLopez]

why the number format is not working in my speadsheet? what should i do

[@vaivmusic]

why present absent not updating to default ?

[@mariannefayegimena7659]

how to get the total present/absent per day? it only shows the info per employee

[@AnneCOGO]

How do you calculate the percentage?

[@NeotechNavigators]

You can check the formula in the template. Link is given description box.

[@pkdasinstituteofmedicalsci2104]

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 ?

[@NeotechNavigators]

Will create this in next version.

[@rupalimishra0228]

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

[@tansinamustafa1318]

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?

[@inshaanam7882]

How can we add attendance percentage

[@AryanSingh-vl5yr]

Drop-down ko kaise change karen month wise isska koi video banna do 🙈

[@NeotechNavigators]

Will try explain in the next version of it

[@aayushiravindrakirdat3403]

Sir the count if formula is not getting applied. Pls help.

[@rodriguekinda9255]

Magnifique tutoriel. Est ce possible de nous faire même sur Excel

[@NeotechNavigators]

muchas gracias

[@RealAshwxn]

wher is the template i cant find it in te descprtion

[@NeotechNavigators]

Template link has been given in videos description box or visit our website www.NeoTechNavigators.com

[@PallaviSonkamble-c1c]

Dear sir Tutorial is helpful but,request for the Hindi language

[@NeotechNavigators]

Noted

[@sanjayselvakumar9084]

How to filter absent name list ?

[@aartinaryani3256]

But when i am dragging the dates… it is not working

[@NadineAlfonso-g4t]

How do we unselect data selected

[@NeotechNavigators]

Just put False in one cell then copy to all

[@NadineAlfonso-g4t]

@@NeotechNavigators thank you

[@warlock3996]

How to store the data like May month April month june month Can u please can me how to store

[@k.v.ramprathaban4456]

kindly grant me access...

[@myparamount]

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.

[@vaivmusic]

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.

[@sourabh5461]

Same issue have you got the solution if yes pls help

[@prakashdeep5394]

Week off kaise hoga? Jab month change hua tab v wahi date ka A P Or L kaha change hua fool banana chhoro Or excel shikho nahi to vedio delete karo