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.
Locked
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
Hi there,

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
- Access updated so that you can edit, sorry about that!!

- 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
thanks! i created a copy of report tab - it has the lists of dates and limits to the 30 hours (feel free to test). 

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
false
2302579824707242136
true
Search Help Center
true
true
true
true
true
35
Search
Clear search
Close search
Main menu
false