Sign Up Sheet

I am looking to create a sign-up sheet for over 200 staff members with at least 100 different locations, four different time slots over a two-day period. I have the basic sheet and form created. Each location has a number of staff needed for that location. What I'm stuck on is how to make sure that more staff then needed sign up for the same time and location. I'm hoping to have something along the lines of once the location and the time slot are full, that location will disappear so no one else can sign up for that spot. Can anyone help me?
Thanks,
Janelle
Answers
-
Hi @Janelle ,
If you can share some screenshots of the sheet, I could give a more specific answer.
Generically though, you could have a column for each location that indicates how many sign-ups are needed. Let's call that [Volunteers Needed].
Make columns for the maximum number of volunteers needed at any location (let's say 5).
Another column counts how many sign-ups you've gotten across those 5 volunteer columns - [Sign-Ups].
When [Volunteers Needed] = [Sign-ups], lock the row via an automation and use conditional formatting to make it clear that the location is booked. Maybe gray it out. You could also update a dropdown column with a status to say "FULL".
If you want it completely removed, you could use a Move Row automation to move it to a different sheet altogether.Thanks,
Sam
β
Want to chat about a Smartsheet problem you're facing?
Grab time on my calendar here:
https://calendly.com/sam-samharwart/30min -
Sam,
Thanks for the tip. I was totally lost on how to do this. I will let you know how it goes.
Janelle