Bathroom Sign Out (2)

I had a friend using a Google Sheets spreadsheet to have students sign out and in for the bathroom instead of the paper sign out. The problem became the amount of scrolling after many students had signed out. I created a template to help with this.

The Template

Bathroom Menu

After making a copy of the template look for the “Bathroom” menu near the “Help” menu.
bathroom menu

The menu has 3 options: Check Out, Check In, and Sort.
Menu bathroom

Check Out

When students sign out for the bathroom they select an empty cell in column A. Using the “Bathroom” menu, the student chooses “Check Out.” This will place the date and time into the cell. The student would then put their period and name into columns C and D.
Bathroom sign out and in

Check In

When students return from the bathroom they select the cell in column B. Again using the “Bathroom” menu, the student chooses “Check In.” This places the date and time of the students return in column B.


Choosing “Sort” from the “Bathroom” menu sorts the entries in reverse order. Most recent at the top. This also inserts 10 rows at the top to give students room to sign out to the bathroom without having to scroll. Students can use the “Sort” option to insert more rows as well.
Sort Bathroom Entries



Apparently the spreadsheet defaults to the west coast where I live. This is a Google Sheets setting, not something in my code. CLICK HERE to change your Google Sheets settings to your local time zone.

Digiprove sealCopyright secured by Digiprove © 2015

Subscribe to the Alice Keeler Newsletter


WP Twitter Auto Publish Powered By :
%d bloggers like this: