#155

In this video, you will learn How to create an automated attendance sheet in google sheets with google app script. I think you have not seen this type of video on KZbin. So enjoy the video and if you face any problem write me in the comment section.
***********************************************************
~:Related Video Links:~
Previous Video: • #154-Fully Automated F...
Next Video: • #156-Automated Invento...
***********************************************************
Related Video Links:
Demonstration Video: • #142-Automated Attenda...
Monthly Attendance Sheet: • #82-How to Make Autom...
Yearly Attendance Sheet: • #133-Fully Automated F...
Multiple Year Attendance Sheet: • #239-How to Create Mul...
***********************************************************
You need to understand few things to create this template, so watch this video:
Creating Named Range in Google Sheets: • #139-Dynamic Named Ran...
Highlight Alternate Rows in Google Sheets: • #141-Google Sheets Tut...
Highlight Alternate Columns in Google Sheets: • #143-Google Sheets Tut...
Static Drop down list in Google Sheets: • #145-Google Sheet Tuto...
Dynamic Drop down list in Google Sheets: • #147-Google Sheet Tuto...
Highlight Weekend Attendance Sheet in Google Sheets: • #149-Google Sheet Tuto...
Auto-Populate data in cells, using google script: • #151-Google Sheet Tuto...
***********************************************************
~:Support Our Work Financially:~
Premium Download : sahacomputer.co.in/?add-to-ca...
***********************************************************
~:Join us on Social Media :~
🔔Subscribe to Our Channel: bit.ly/2TTblTG
Visit Website: www.sahacomputer.co.in
Join Us on Patreon: / scec
Facebook: / scecpkt
Twitter: / manojsaha2016
***********************************************************
~:Hire Me:~
If want me to help you to build Excel-based applications, you can Hire ME!
Contact me: [e-mail]
***********************************************************
~:Sponsored:~
***********************************************************

[@SahaComputer]

Hi, Viewers if you have problem regarding this tutorial, you can write me in the comment section.👇

[@chikpink31]

I can't do the part of clear cells button, it leads me to macros.gs and not code.gs and from there, I have no idea what to do :'( also I don't know where you got that information for the code.

[@SahaComputer]

this is same but different version

[@geedivijay3164]

Hi, Thanks for your video and i am stuck in date 2 That you are saying something life (absolute F4) i am unable to do that

[@pathtopeace334]

=if(c7

[@oliviarentas6838]

I cant do data validation for AL SL P A

[@gunjanagarwal4994]

Thanks a lot. This video is amazing 👍

[@SahaComputer]

Glad you liked it!

[@tobidisconn6602]

Nice, thank you for the tutorial..

[@SahaComputer]

Thanks for your comment & Please Subscribe our channel.

[@bunthonmok5237]

Thanks, this tutorial is useful ...!!!

[@SahaComputer]

Glad to hear that!

[@AbdulMajeed-hx4jv]

Good information

[@SahaComputer]

Thanks

[@shantisawaroopsharma877]

Very helpful video

[@SahaComputer]

Glad to hear that

[@blkkobra]

Nice Video sir.

[@SahaComputer]

Thanks and welcome

[@sadeeshanatomy4094]

Congrats, its very useful video and simple too. it can be used for the classes also. Is it possible to prevent over writing of attendence for previous day

[@SahaComputer]

You can use Data Validation for that, Select the range =C$1>today() use this formula in custom data validation row1 is date row.

[@masudar]

Great tutorial!!! Great Teacher!!!!😍🥰❤💥 Following along without hearing a thing... computer issues.

[@SahaComputer]

Thanks for your comment. 😍😍😍

[@masudar]

@@SahaComputer Most Welcome! Novice to Apps Script but I did a good job following your lead. Thank you so much.

[@masudar]

@@SahaComputer Can you help me write a script to hide blank rows when the amount of persons change?

[@SahaComputer]

Yes I will

[@masudar]

@@SahaComputer Thank you because my sheet works great, functions well but just that one issue have me at 99.%😏😁

[@jeetendrachopra7493]

How could you allow all the weekends and or holidays to an employee who joined or left at middle and or after/before certain weekends or a holiday(s)

[@lauramurphy2179]

Hi there, I have followed your tutorial and developed a great annual leave calendar however, 2 things: 1) My script does not seem to work at all - I have followed your guidance, but I receive the message: Script function ClearCells could not be found. 2) I see others commenting about the content being the same for each month, which I have found too, and you say to copy a master sheet for each month - but it's not clear what you mean, or how to do that, can you provide a video of how to do that, or some detail please as this becomes pointless without it? The other video you direct to is losing me. Thanks

[@sarvodayaconventvidisha1757]

Super

[@SahaComputer]

Thanks

[@barnalisaha1050]

Nice

[@SahaComputer]

Thanks

[@Crystaldesigns91016]

Hi, Please confirm how can we get attendance input from google form in same sheet. Thanks

[@jeetendrachopra7493]

if a person also present on weekend and or holiday then how allow him an extra attendance or overtime

[@montibhai8208]

👍👍👍👍👍👍

[@SahaComputer]

Thanks for your comment.

[@yabado20032003]

i can't see the extentions tab..? how to enable it. mine is just add-ons

[@Rimjeet9564]

There is a problem here, the present is not changing when the month changes. The previous present here is therefore changing the month when coming

[@riddhifataniya8230]

Can you please give some suggestions for it. I am also facing this problem.@saha computer Education Centre

[@ivanaalonso899]

I love what you did and I am very happy but I am a bit confused how to do for the next month

[@SahaComputer]

In this sheet you can do for one month only. But it is obvious that you need it for next month, so after creating this sheer keep it as master. Then when you need a sheet for next month , just copy it from the master sheet. I will create a google sheet so that attendance for whole year can be done.

[@ivanaalonso899]

@@SahaComputer How would I connect it to make a one sheet as a functional for all other sheets?

[@carlaafidchao6748]

Hello, thank you for this video. I have a concern tho, I'm not sure on how I can clear the data (P, A) if I change it to another month? Because when I change it to other months, same data is there. Would appreciate a feedback. Thank you.

[@SahaComputer]

After completing the attendance for a month, you have to create a new sheet from the Master sheet. I understood your problem you can watch Video #101, #133, #165

[@shantisawaroopsharma877]

Sir, your video is very helpful. I have s query that suppose I want to count the attendance of all the employees on specific days of month i.e, Wednesday. How can we do it.

[@SahaComputer]

A video on excel related to your query is coming soon, you can take help from there. And I will also try to make a same video on google sheet.

[@avroneelbiswas]

Very complex.

[@SahaComputer]

No, Its easy. Only App Script part is little complex.

[@Psygnosis]

very useful video. thank you. But is there a way to retain the data attendance data when i switch between months when click the Month drop down menu?

[@SahaComputer]

I will create one. I have done it in excel video 165

[@Psygnosis]

@@SahaComputer is there a way to export to google sheet while retaining formulas and macros? Thank you!

[@deependrapaudel5785]

how to indicate if some one worked at holiday or weekend if there is provision of overtime pay or compensation leave

[@SahaComputer]

You can create another column within the report part and use any other legend for that but while you add them use negative value.

[@AzeemKhan-jw6mh]

Very very informative video sir. I like this very much. But one thing i want to know that how we can create of whole the year. Also tell me how can i get your this, Please do tell me.

[@SahaComputer]

You can create it for whole year. I will try to upload a video on that. If you want this file link is given in the description box.

[@Rimjeet9564]

Sir apnar ei video khub valo legeche Amio ei rokom ekta sheet creat korte chai Kintu amader month start hoy jemon 6 Jun to jul 5. Amader morning, evening and night shift hoy National holiday duty hoy eveni morning night shif a Ekhane amader count korte hoy koto gulo national holiday te duty koreche Apni ki ektu help korte parben. Korle khub upokar hoto

[@juvyfestijo6081]

What if we had day shift and night shift schedule. How? could shifting schedule per week will automatically posted by the end of the week (sunday)

[@SahaComputer]

Watch this video, may be shift schedule problem will be solved else you elaborate your problem

[@naveenms2584]

Hi Sir I prepared Automatically attendance sheet based on your video. but we need 8 to 9 sheets how to copy paste same format and formulas and date and att all ?

[@SahaComputer]

Right Click on the sheet tab -> Copy To -> Existing Spreadsheet -> Select the sheet -> Click Select -> Rename the Sheet.

[@hudaalraee8794]

I was waiting for you to explain how do I can save my data what if I change the month to FEB how can I know that Attendance of JAN and How can I know the report for All month I need your answer Please

[@SahaComputer]

This is a single month attendance sheet. you have to copy the main sheet when you need it for the next month. And in this video I have you will get the monthly report separately for each month. If you need to get the for full year you have to do it yourself or wait for my next video on attendance sheet in google sheet.

[@flordelizajagualing5816]

Hi, this is very helpful! However, I have a concern. Let's say I put P on February 2, 2021, and then when I go to other month like March, the P that I placed on February 2 also appears in March, what happened? I appreciate your response, thanks!

[@SahaComputer]

Actually this is a single month attendance sheet where you select a month and do your attendance and if you wish to do attendance for other month then you have to copy the master sheet and change the month name and start your attendnce. But in the next update of this file I will add the feature so the if anybody select any month then that will automatically created and for existing months it will move to that sheet.

[@candicekimtorres9180]

@@SahaComputer Hi! Is there an update already for selecting per month? Thanks!

[@SahaComputer]

Hi Candice Kim Torres, Thanks for the comment.

[@JohnPeter-li1js]

@@SahaComputer is there any update on this

[@aleashajohnson8463]

I am having the same problem I want it to update to a clean sheet for each month and year

[@LuisOrtiz-ku5qb]

When I put the attendance for the month and change month the same attendance passes to the other months how can I fix that. Thank you

[@relyonsppsupport1406]

how to calculate absence or present using IN time and Out Time by google form

[@SahaComputer]

I will make a video on that.

[@mmalleswari7516]

Including intime n out time we need this, n i am not able to see clearly in mobile phone

[@SahaComputer]

In mobile you have change the data settings

[@apoorvakhodiyar2005]

sir, I make this Google Sheets it's very working easily but some errors come in the weekend part all sections show 0 not 1 as a weekend

[@SahaComputer]

Please check the formula, there must be mistake. Please do subscribe our channel.

[@sikofrederic684]

Fank you for the presentation. Is it possible to have the file?

[@SahaComputer]

I will put the download link in the description box. Please check later.

[@melissalasig2102]

Hi what did you click at 11:02 min. Is that a comma after +1? when I put comma it is showing error.

[@SahaComputer]

=IF(C7

[@funfunfun2255]

How to make summary of the classwise attendance according to the attanndace..plz tell

[@SahaComputer]

With IMPORTRANGE function

[@funfunfun2255]

@@SahaComputer please make a video on it

[@SahaComputer]

I will.

[@JoinUs-wq1zp]

is it possible to make specific cut-off day example from January 16 to February 15?

[@SahaComputer]

Yest, it is possible. In Start Date type =DATEVALUE(16&T3&AA3) and in End Date type =EOMONTH(L4,0)+15

[@extremebright3714]

Hi Sir, I always a pop up message that I need authorization. Can't run the extension. What to do?

[@SahaComputer]

Yes it will ask for authorization and you have authorize it with email id in which you created the file and you have proceed with unsafe mode.

[@swapniljadhav6237]

I have filled the data for January but when I switch the month the previous attendance is still present, it should show blank and the earlier month data should also be visible if I switch back any ideas or am I doing something wrong

[@SahaComputer]

Master sheet is for creating attendance sheet for respective month , then you have to use Copy button to create the final sheet.

[@sivaranjani8943]

Sir explain this! How to do this?​@@SahaComputer

[@SahaComputer]

Right click on the Master Sheet tab and click copy, then rename the sheet as month name.

[@sivaranjani8943]

Thank you sir

[@user-rq2eb2ii5y]

is there a way to hold the data for each month? If not, then why make a dropdown to change months, having to make a copy for each month seems senseless@@SahaComputer

[@radhasoni2500]

I have alternative Saturday Off!! What shall I do ?? Please Reply.…….

[@SahaComputer]

You have to create a helper row above the day row and with formula you have to generate Saturday number, and based on that value you have to conditional formatting.

[@NoorAhmed-xn5yt]

Very very well work... Plz provide link to download the file.. thanks

[@SahaComputer]

Send me you mail address.

[@Rimjeet9564]

When I changed the month previous date is not changed

[@SahaComputer]

You have to copy the master sheet for each month;s attendance.

[@francojapanis1029]

Sir, I have a question when it comes to the Coding, I do not understand how you are copy pasting the coding. please direct me, Thanks

[@SahaComputer]

I copying the code from my previous file which I made before making the tutorial. If you can get the free files, link given in the description box.

[@amitkumarchautala8373]

@@SahaComputer please share link

[@SahaComputer]

Hi, we have changed our policy. We only share all our free project files to all our member and premium project files to Diamond member. So to get the project file you can join our membership. Click the link to join: kzbin.info/door/yQtJUJWTUTm8fpYXrU87zAjoin

[@setjie]

i have to purchased but not open the google sheets plz help me

[@SahaComputer]

Have you got it?

[@pavisshivanand]

Hi, i need formula for calculating holiday list

[@SahaComputer]

Write your query in details.

[@P_R_I_N_C_E___68]

Have some doubts please can you reply

[@SahaComputer]

Ofcourse

[@ladychio1427]

Hello, can I ask a copy for the file please?

[@SahaComputer]

See the description box.

[@benidani2621]

Sir i am facing trouble regarding formulas... please share excel file link

[@SahaComputer]

Link given in description.

[@asifaccount6960]

When I enter the data in January & after that when I change the month, the same data is showing in other month. How to resolve it?

[@SahaComputer]

Actually here this sheet is single month that's why you have to the sheet and create new one in Master sheet.

[@user-rq2eb2ii5y]

what's the sense in making a dropdown for months and years if the data you put in for one month goes to the next .@@SahaComputer

[@vimukthipehesara5140]

i cant set the weekends here..all numbers came as "0"

[@SahaComputer]

Get the correct formula.

[@funfunfun2255]

How to Link this sheet with summary sheet..

[@SahaComputer]

With IMPORTRANGE function

[@setjie]

I have to purchased empty file u know

[@sagarreddy23]

Sir I got problem in weekend helper . As weekend is in sheet , in weekend helper I didn't get 1. For all days it's showing zero. I couldn't rectify it do update on this issue

[@mohammadashrafkadambu2272]

Same issue

[@SahaComputer]

Sorry for the late reply, please watch carefully from 13:48 to 18:52 , Yoy have to create the dynamic range for weekend and use that range in the weekend helper row with indirect function.

[@SahaComputer]

Please watch this video: kzbin.info/www/bejne/bmjRlZhphMyXe5o

[@masudar]

Hi, have you resolved the issue? I had the same issue at first but after reviewing the video I rectified it.

[@pavisshivanand]

Hello, sir i need formula for calculating holidays. What ever u have mentioned here is not working for me.

[@SahaComputer]

There must be a mistake, watch the video carefully and try to correct it or you can send me the file.

[@hrmanager8887]

Try again. It will work. Same I was facing but after trying several times it works.

[@lakshminarayanan1932]

I have to calculate the attendance from 26th to 25th of Next month. How can do it?

[@SahaComputer]

Watch this video your problem will be solved regarding dates, it is Excel but the same formula can be applied to google sheet.

[@Rimjeet9564]

@@SahaComputer which video

[@SahaComputer]

Video no 96

[@hrmanager8887]

=and(C$7=0,C$8=0),or(C11="A",C11="P",C11="SL",C11="AL",C11="CL",C11="ML",C11="UPL")) please guide.

[@SahaComputer]

watch the video carefully, it will be solved.

[@vikassainiii]

please share this sheet

[@SahaComputer]

Ok I will

[@manoj_7374]

Pp attendance ko kaise count kre

[@SahaComputer]

Jaise present count kiya, sirf usme criteria chnage kar dijiye.

[@dhanakugan2468]

Can you please share this sheet thankyou

[@SahaComputer]

Purchase link given in description box.

[@anamulhaque589]

Where is the attendance database?

[@SahaComputer]

The sheet itself is a database.

[@sanjuakarsh8801]

. Please can you share this source file with us. Please

[@SahaComputer]

I have added the Payment & Download link in the description box.

[@afzalkhanmiefellow8661]

Where is file??????

[@SahaComputer]

I will provide the link.

[@geedivijay3164]

Hi I am stuck at date 2 That you are saying (absolute F4) i am unable to find it At 10 minutes 30 seconds

[@SahaComputer]

To make relative cell reference to absolute cell reference, click on the cell reference and press F4. Suppose your cell reference is C6, place the cursor in the cell reference and press F4, it will be $C$6

[@geedivijay3164]

@@SahaComputer Thanks for your response

[@shaheenamore]

Date value not work

[@SahaComputer]

The formula will be =DATEVALUE(1&V4&AC4) where 1 is the start date of month V4 is Month Cell AC4 is the Year Cell