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.

Details

Sheets,Chrome OS,Education

Locked

This question is locked and replying has been disabled.

Community content may not be verified or up-to-date. Learn more.

All Replies

Eric Maccabi

Silver Product Expert

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?

Shannon Espitia

Original Poster

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

Eric Maccabi

Silver Product Expert

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