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.
Community content may not be verified or up-to-date. Learn more.
All Replies