We have an online/ virtual signup in our community garden in Feb asking our 140 members to volunteer for one week out of 28 weeks/dates. We need 4 gardeners per week. We want to have them signup and choose one of the weeks but make a date " unavailable " if there are 4 who have already signed up .

We tried one last year but it didnt work. One week we had 8 volunteers but in August we had zero. It was a mess!!. Help!!

I can send the spreadsheet with the formulas for your review and correction.

Hi Will ! I have attached the form we use for signup. The Response tab is the mail screen that the gardeners see when the go to the site.There is column for choosing you work day and Chore week.The other 2 tabs were supposed to do the countdown but they bombed and it was a mess.

Your formula looks perfect and just trying to figure out how to link to the main sign up screen with all the other necessary information.

Wish you were on our committee!