Forum Discussion
Xeryar
Sep 25, 2022Brass Contributor
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 trac...
- Sep 26, 2022
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
Riny_van_Eekelen
Sep 26, 2022Platinum Contributor
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.
- XeryarSep 26, 2022Brass ContributorI mean if there is a formula we can put in place that changes 1 to 0 same date next year if applied daily
- Riny_van_EekelenSep 26, 2022Platinum Contributor
Xeryar Still don't know what you mean. Sorry!
- XeryarSep 26, 2022Brass Contributori want to build an attendance tracker for my team . It is our company policy that the attendnace points you accrue drop off on same date next year . I am trying to figure out a way to achieve that