Awesome work, thank you so much for this Spreadsheet! One quick question, though, is it possible to insert multiple teams for my employees? For instance, someone to be listed in 2 or three different teams. Thanks in advance!!
This template is not support 1 person in more than 1 team. In order to do that, you have to add a Person - Team mapping table, then change some formula in Month View sheet.
This template is for Leave tracking. To add OT need to add new sheet for OT record (I recommend to use daily basis not range of date). Then create new report, or modify the existing report if you want to show them together.
This workbook is amazing! I have added a column (K) in the Employee Leave tab with the header "Approved" with either a "Yes" or "No" result in each row. I want to update the conditional formatting in the Month View tab to take this new criterion into consideration. I only want the cells highlighted if there is a "Yes" in the approval column. I can't seem to revise the countif(indirect) formula correctly. Any suggestions?
The guide is - Add Name Range for the new Approved column. - Use the Name Rage in the conditional formatting formula by adding more condition in the Indirect() function.
As this is just a small template, it is not a system. The ways to handle terminated employees may be - keep all of their data listed as history data - create new list, Active Employees for leave record
Hi this tracker is amazing. But i have a question, is there a way to add check boxes in the employee record leave, and once it's checked(true) like approved, only then the colors will appear in the month view/calendar view? Thanks!
In Employee Leave sheet, you may add new Column name "Approve". Input 1 for Approved. In column Days, change the formula by adding * Approve column In Month View sheet, in the display area change formula by adding in CountIFS() function one more set of criteria for checking whether Approve column is 1 or not.
@@ExcelNaNa I see. I already added a column and inserted checkboxes bc I thought it was easier to just click it. I dont have to change the formulas in the conditional formatting? Thank you!
@@ExcelNaNa can't see the menu option. Just shows in a read only format. Can you send me your email ID? I will email you. Need this urgently thanks a ton
Did you mean you would like to create by yourself? Actually, you can Make a Copy of this file to your own drive. I not quite familiar with Google Sheet. I started by Excel file, then modified the unsupport features. If you don't mind learning from Excel, here is the playlist for basic concept for this file. Calendar / Attendance Report / Planner in Excel: ruclips.net/p/PLjlvnzlt72MDMlx4mRGvkau72_hbU68a- However, they are explained on Thai language. If you think this playlist helpful but still need English explanation, please let me know.
how about note and comment to display in calendar view
Awesome work, thank you so much for this Spreadsheet! One quick question, though, is it possible to insert multiple teams for my employees? For instance, someone to be listed in 2 or three different teams. Thanks in advance!!
This template is not support 1 person in more than 1 team.
In order to do that, you have to add a Person - Team mapping table, then change some formula in Month View sheet.
You're a lifesaver!!! By the way Can you tell me how to add OT (Over Time). Thanks.
This template is for Leave tracking. To add OT need to add new sheet for OT record (I recommend to use daily basis not range of date). Then create new report, or modify the existing report if you want to show them together.
This workbook is amazing! I have added a column (K) in the Employee Leave tab with the header "Approved" with either a "Yes" or "No" result in each row. I want to update the conditional formatting in the Month View tab to take this new criterion into consideration. I only want the cells highlighted if there is a "Yes" in the approval column. I can't seem to revise the countif(indirect) formula correctly. Any suggestions?
The guide is
- Add Name Range for the new Approved column.
- Use the Name Rage in the conditional formatting formula by adding more condition in the Indirect() function.
I am unable to enter the end date for leave.receiving an error like this.. #VALUE!
Sorry I cannot find the error. Could you share your file to me with brief explanation where the error occurred.
This looks awesome... I have requested access to be able to edit this sheet with the data that I have. Thank you
Please select menu File > Make a copy.
This tracker is amazing! Only thing I am trying to figure out is How to handle terminated employees?
As this is just a small template, it is not a system. The ways to handle terminated employees may be
- keep all of their data listed as history data
- create new list, Active Employees for leave record
Hi this tracker is amazing. But i have a question, is there a way to add check boxes in the employee record leave, and once it's checked(true) like approved, only then the colors will appear in the month view/calendar view? Thanks!
In Employee Leave sheet, you may add new Column name "Approve". Input 1 for Approved.
In column Days, change the formula by adding * Approve column
In Month View sheet, in the display area change formula by adding in CountIFS() function one more set of criteria for checking whether Approve column is 1 or not.
@@ExcelNaNa I see. I already added a column and inserted checkboxes bc I thought it was easier to just click it. I dont have to change the formulas in the conditional formatting? Thank you!
@@ally3144 It's depended on what you did and what you want. If anything isn't meet your expectation, let me know.
In month view column i want to add total number of working days in month , is that possible and how?
support.google.com/docs/answer/3092979?hl=en
Hi... thanks for sharing the file. I have one question. How can I change the colour of leave type? Thanks
You can change in Conditional Formatting.
@@ExcelNaNa How the colour will sync between different sheets? I'm still lost. Thanks
You can check this vdo as a guideline.
ruclips.net/video/yaw8iW3cYDA/видео.html
What are those points? I don't get it. What are those points meaning?
They show leaving date.
Is it possible to change calendar year i.e July 2019 to July 2020?
In Calendar View sheet, you can change the 1st month of the year by modifying formula in cell D7.
from =DATE(ReportYear,1,1)
to =DATE(ReportYear,7,1)
@@ExcelNaNa You are AMAZING! Thank you!
Hi I can't find the menu button it's opening in a read only format.
Select menu File → Make a copy → select your google drive
@@ExcelNaNa can't see the menu option. Just shows in a read only format. Can you send me your email ID? I will email you. Need this urgently thanks a ton
You use Google Sheets or Excel?
@@ExcelNaNa Google sheets
Are you able to create new file?
Or open existing file?
im a newbee. do you have a tutorial on this sir?
Did you mean you would like to create by yourself?
Actually, you can Make a Copy of this file to your own drive.
I not quite familiar with Google Sheet. I started by Excel file, then modified the unsupport features.
If you don't mind learning from Excel, here is the playlist for basic concept for this file.
Calendar / Attendance Report / Planner in Excel: ruclips.net/p/PLjlvnzlt72MDMlx4mRGvkau72_hbU68a-
However, they are explained on Thai language.
If you think this playlist helpful but still need English explanation, please let me know.
hi how do you do half day leave?
Let create Half day Leave Type or you need another structure design as this one:
ruclips.net/video/Qd3jsHKj5zE/видео.html
@@ExcelNaNa Thank you nana how about if employees have different day off ?
Sorry I'm not understand your question. Could you give some sample data or scenario.
@@ExcelNaNa how about if employee 1 time off is saturday and sunday then employee 2 is wednesday thursday - do you also have google sheet for hours?
Sorry, I do not the version to support your requirement.
However, I will consider to create one.