I’ve created a Volunteer Form for one of our schools (and written up the process). This allows a volunteer sheet to be printed every day with the appropriate information. Basically, a Google form is filled out that populates a Google Spreadsheet. The Spreadsheet has a tab where the Administrative Assistant can pick the date (populated from a range on the spreadsheet). Picking that date populates the names of volunteers who have volunteered for that day.

Screenshot of a spreadsheet. There is a date (5/22/2024) in Column A, cell 2. The header row includes the following: Time In, Time Out, Teacher/Location, First Name, Last Name, Trained, Registration, CBC, Volunteer Signature, Minutes Spent Volunteering. Fake information is included in line 2: Library, Joanne, Lett.

The one caveat with this is that the date isn’t in order. I would love to be able to sort the date.

The date is populated by using Data Validation Rules. The Criteria is “Dropdown (from a range)”. The actual criteria is:

=’Form Responses 3′!$M$2:T

This works well, except the dates don’t get filtered or sorted. The dates are in whatever order they appear on the spreadsheet.

Screenshot of a spreadsheet. The dates are in the following order: 5/22/2024, 5/29/2024, 6/5/2024, 5/10/2024, 5/20/2024, 6/4/2024, 6/11/2024, 1/8/2024

If anyone has any ideas on how to sort the dates, or another way to accomplish the same end result, I would be greatly appreciative.

A public version (with Fake Names and data) with Commenting Rights is available.