Google Sheets Attendance Tracker

  • get calendar month on a click
  • automatic setup using predefined attendance values
  • precise marking for selected data

How to USE

HOW TO INSTALL

1. Goto to http://sheets.google.com and Create/Open a new google spreadsheet.

2. Goto Add-ons > Get Add-Ons > Search “Attendance Tracker” > Install 

3. Authorise when asked. 



HOW TO USE

1. Go to Add-ons > Attendance Tracker > Load


2. Open a blank/existing Google Sheet and Click on “Fill Header” to fill date from first  to last of the month required month.

Enter Employee / Student name under column B. 

Optional : Enter Employee / Student ID under column A


3. Select the cells where you want to mark attendance and click on respective button. For example : select cell(s) and click on “Mark P” button to mark P ( Present).

User can also select multiple cells to mark attendance in bulk . 


Automatically mark attendance for entire Month :

Click on “Auto Fill Data” to mark attendance for entire month . Change dropdown values of the week to mark attendance accordingly . 


Tip 1: Check “Replace Existing values” button to override existing attendance. 

Tip 2 :Uncheck “Fill Background color” for no background color while marking attendance. 


DOWNLOAD ATTENDANCE TRACKER

privacy policy

Attendance Tracker is a free add-on created for Google Sheets by Deepak Lohia.


1.No personal data is collected by the developer from the add-on.


2.No access to users email is given to the developer from installation of this add-on.


3.No access to users Drive files is given to the developer from installation of this add-on.


4.Reporting through the ‘help’ button in the add-on menu is the best way to request technical support.


5.Any data stored within the add-on is stored on google user account.


6.There is no guarantee for support for the add-on and the add-on could be removed at any time without notice (although this is very unlikely).


7.No guarantee is made for the quality or reliability of the service.


Regards

Deepak Lohia

Troubleshoot