In a previous video, I showed you how to take attendance with just check boxes and formulas. I want to show you one advanced way to take attendance if we want to keep a log of each and every student and the day they were there.

But right now, how do we take attendance for a student? We will want a checkbox here.

log, row, we can do logger. log, column and we can look at this, so let's do this, let's do a couple of edits, just checking off that checkbox is an edit.

We only want to know if we edit that column under the first row. That's why we do greater than one. And once we do that, what we're going to do is keep a log.

We need to get the sheet called log. So we go spreadsheet app dot get active spreadsheet dot get sheet by name log.

We want two things. We want the student name and we want timestamp . So how do we get the student name?

Let's save that. Once it's saved, once it's saved, we can now go back to student and let's do, try Darlene and Edna.

So this is an advanced way to take attendance if you want to keep a log of your students.

Better Sheets

Advanced Attendance in Google Sheets