Google Forms are a fantastic way to collect data from your users. However, they can be difficult to use if you need to create sign up sheets.
This guide will show you how to make a Google form sign up sheet with time slots using Google Sheets.
1. Open Google Sheets and create a new sheet.
2. On the new sheet, enter the following data:
Name:
Email:
Time Slot: (1-5pm, 6-9pm, 10pm-12am)
3. To create a time slot, select the column heading and click the dropdown arrow beside it.
Select the time slot you want to use from the list that appears.
4. To add a row to the sheet, click the “plus” button next to the Name field and enter the name of your user in the Name field.
Enter their email address in the Email field and click “save.”.
5. To add a column to the sheet, click the “plus” button next to the Time Slot field and enter the name of your user in the Name field.
6. Click “calculate” below each column to get started filling in your data! You can enter whatever data you want into each column – it’s up to you! Just make sure that each column contains at least one entry.
When you’re finished, click “subtract” below each column to calculate your users’ timeslot totals.
