Google user
Original Poster
Sep 16, 2020
Form needed: people signup for multiple dates, easily see who is signed up for each day
I have tried using a checkbox grid labeled Mo-Sun in columns and week 1-4 in rows, as well as a simple checkbox question with each day of the month being one checkbox. However, both of these options result with all selected dates being listed in one cell divided by commas. If I then use the "separate data into columns" feature, it doesn't update correctly if someone changes their selection.
Greateful for your help! Have spent way to long on this and cannot figure it out!
Details
This question is locked and replying has been disabled.
Community content may not be verified or up-to-date. Learn more.
All Replies (5)
Hi Sarah Adams 3027,
We would like to help you with this but because there are so many variables that can affect your results, we need to see a sample of your problem. Would you please take a look at this post about Best Practices When Asking a Question and share a sheet that has the permissions set for “Anyone with link can EDIT”? Thanks!
Adam
Diamond PE volunteer (not a Google employee)
When you've received a response that answers your question, please observe these forum courtesies:
• Leave your demo sheet shared as View Only as part of this solution's archive,
• Click Recommend on the post that best addressed your question, and
• Post again soon!
Google user
Original Poster
Sep 17, 2020
Either of these two outputs would work fine.
The easiest way would be to have people mark the checkboxes on the bottom table themselves on days they are available. However, I'd like to be able to collect these responses confidentially, so every teammember doesn't see what days everyone else is available. That's why I'd like to collect it using a google form.
Thank you for the sample file but there does not seem to be any Form responses or a sheet for that in the file. Would you please include sample data of what you are expecting to see so that any solutions I or another volunteer comes up with can be tested? Thanks!
Adam
Google user
Original Poster
Sep 17, 2020
As you can see, it collates all available dates into one cell instead of collecting responses separately like i need them. I would like the final results to look more like the example I put into the "Ideal Results Format!" tab.
In your desired results you show names, not email addresses. Where are the names and their associated email addresses located?
Adam