Assistance with resident sign-up sheet
Appreciate all the responses! We're a bunch of old people who literally have no idea how to do this ourselves and too dumb to use A.I. to help us!
Hello Google Sheet experts!
I'm creating a sign-up sheet and would like help with the following, if someone is able to program the Sheets to do it. Or let me know if it's impossible.
All 5 fields required to reserve time slot or entire entry is rejected:
- Resident Name
- Resident Address
- Resident Phone # - Required!
- Resident Email - Required!
- DROP-DOWN MENU - YES to agree that no-shows will be charged $100 to re-schedule
For Column C: drop down of 107 possible addresses only in Column H
--- each address can only sign up once
For Column J:
I'd love to get an auto-generated list of which addresses have yet to sign up. Disappears in real-time as addresses get signed-up.
Sign-up sheet (the dates aren't done yet but you get the point):
https://docs.google.com/spreadsheets/d/116QQSr91b3Dosw6XDvzqEd3OKnaOs1JFiBZlmp0ciVI/edit?gid=0#gid=0
Thank you!