Need a form to send employees for availability

RCC Admin

I'm having trouble creating a form that we we will send all 6 employees that will display all our new upcoming events and they can choose which ones they can attend. When I send the form to employee #1, I don't want the other employees to see what they have chosen. I do need their results to automatically come into the sheet that has the events listed. Once I receive all responses, I will be able to see each event and each employee that can attend.

Is this possible? All I see in Forms is all the fields from the sheet are listed for them too fill out, not choose from a list of events. I'm lost!!

jmyzk_cloudsmart_jp

Hi @RCC Admin

The best way is to use a multiple-dropdown list, but parsing the result can be a bit tricky.

So, I advise you to use a sheet like this.

Then, summarizing the survey result is straightforward, as shown in the Sheet Summary fields.

https://app.smartsheet.com/b/publish?EQBCT=4ff1a4980ce04f7d821d4a18f804b154

Form Image

https://app.smartsheet.com/b/form/d9750e7ee029494c96e09adc4fa70a28

Form settings.

jmyzk_cloudsmart_jp

It's a bit tricky, but the form that lets your employee choose from a list of events is like this.

https://app.smartsheet.com/b/form/0bed32719e094bc4b031f049adf817b9

You need to set the Event column to a multiple-dropdown list.

https://app.smartsheet.com/b/publish?EQBCT=c1c02d58d4774ce1ac1ac0a01991643b

Then, a sheet to summarize the result is like this.

https://app.smartsheet.com/b/publish?EQBCT=f8e06095821f43d6962fc5d85428713d

RCC Admin

Thank you. This was helpful. I followed the info and it works pretty well except for a couple of issues: the Event Name has to be the full name of the event or the employee won't know the details. It has to show the event date, name and time. I don't see any other way to give that info on the form. It works well for events with very short names, but the longer ones won't fit correctly. Maybe I need a different form layout or something?

Also, the email that the employee receives after submission that shows what they choose, is not readable. To copies all the events flushed together over on the left side so that the info appears scrambled and unreadable.

Any suggestions?

Paul Newcome

Try a multi-select dropdown column with the various options entered in the column properties instead of separate columns for each option.