Feb 6, 2023
List All Instances of TRUE with Corresponding Date Value (Attendance Reporting)
I am trying to set up a report generator based on an attendance tracking sheet.
I am needing to select a student, have it list all instances where a box is checked and it's corresponding date above. If needed I can create a CONCATENATE row to mash up the three date data at the top.
In addition to needing the dates listed, I need it to be gated so that it only lists the first 30 hours worth of attendance in one column and then lists the remaining hours in a different column.
I've simplified the actual spreadsheet so that it has only necessary information.
>> Spreadsheet with data set up and explanations Any help would be sincerely appreciated.
This question is locked and replying has been disabled.
Community content may not be verified or up-to-date. Learn more.
All Replies
Feb 6, 2023
We don't have edit access to your file - please share that.
Also, what is meant by "AM" and "3rd"? Also, (i suspect related), how are hours calculated?
Feb 6, 2023
- Attendance is calculated twice a day.
- Before School = AM
- During 3rd Period = 3rd
-Each check box = 30 minutes
- There are some days where additional testing lasts 2 hours, thus there are 4 boxes equaling 2 hours
Feb 6, 2023
It currently displays the running total of hours for that individual. If you would prefer to see how many hours per day, i can make that change - let me know.
Eric