Attendance Tracking 90 Days

It would help if you could offer more specifics on exactly which cells aren't working correctly, but my guess is you're referencing the N/A error in G4 of the 'Attendance' sheet and the subsequent errors that flow from that one? The issue there is that it is looking up a very specific term: "Absence:Less than 2 hrs" in your Formula table and it isn't finding it. You have LE: Less than 2 hrs and Tardy:Less than 2 hrs, but you don't have Absence:Less than 2 hrs. Add that row to the Formula table, refresh your data, and the errors go away.

To add extra points if there's no communication, change the formula in G2 of 'Attendance' to:

=VLOOKUP([@[Reason for Occurrence]]&":"&[@Specifics],Table_Reasons,4,FALSE)+IF([@[Communication of Occurrence]]="Called Supervisor",0,1)

This will add 1 point if the supervisor was not called. Change the "1" at the end of the formula if you want to add more/less points.

Hopefully that helps?

It looks like the data validation drop downs are some combination of macros and pivot tables, which... isn't how I would approach it. I'd dive in deeper, but I'm about to check out for the weekend, so I'll direct you to this link (https://www.contextures.com/xlDataVal02.html) or any number of others that result from searching for "Excel Dependent Drop down list". You might want to think about replacing the drop down system in the file with the one in the link. It will be easier to understand and maintain once you put it in place.

I'm sorry I can't give it more time, but if you run into difficulties, post here and I'll try to give it a look next week if someone else doesn't jump in first.

I'm glad you were able to make it work, good luck!