Forum Discussion
Solved
Attendance tracker
I am looking for an attendance tracker where points drop after 1 year automatically. I found a few forms online but cant really make it work for a team of hundred employees.
Has someone used a tracker or recommend one .I found these two but not sure how to make them work to fit my needs .
Xeryar I would check what actual version you have installed as the #name indicates to me it isn't recognizing the new functions I used in that sheet. Here is a version using "traditional" functions but you have to fill down instead of it spilling automatically. If you have Office 365 I would recommend you check for available updates and update your Excel
12 Replies
Xeryar What do you mean by "....where points drop after 1 year automatically." ?
Templates you find on-line are OK if you use them as they are. They are often very difficult to adjust to specific needs. The first one is certainly not one of my favorites. The other one I haven't seen before.
- I mean if there is a formula we can put in place that changes 1 to 0 same date next year if applied daily
Xeryar Still don't know what you mean. Sorry!
