Hi Raewyn,
I’ve taken a look at the file you’ve shared with me and now understand what you mean and where you have gone wrong 😉
You’ve created a Google Sheet and used the actual spreadsheet to capture the information from people. This would be more effective as a Google Form.
This is a common misunderstanding when someone is new to Google Forms and how they interact with Sheets. Basically the Google Form ‘feeds’ the Google Sheet, creating a list of submissions for you to manipulate.
I think you should take a look at this tutorial which gives an overview of how to use a Google Form and this should set you off on the right track. You can click on each objective in this longer video and jump to that section which is handy.
The sections to take particular note of might be:
- What is a Google Form
- Navigating the Form editor
- Field settings to be aware of
Perhaps share the Google Form back to me, but please let me know how you go – don’t spend ages on this if unsure, but reply back so I can check how you are going.
This form is a more complicated one but will pay off if you set it up right.
Rob