Automated feedback using forms

Hi there,

After we have a speaker attend an event and deliver a speech we have prepared, we would like to automatically send them a form to fill out asking what worked well, what needs further work etc as many speeches are different versions of similar material. I can link the cells from the original event to a new sheet and was hoping to populate the remaining fields with the information on a new 'feedback' form. I know how to automatically ask them to update cells after the event date is in the past, but was hoping it could be done using the form view which is cleaner. Any suggestions on this or a better way to achieve what I am looking for would be welcomed.

Thanks in advance

Louise

Find more posts tagged with

Forms

Sheets

Solution Center

Email Notifications

Comments

Andrée Starå

Hi Louise,

Would it work to send them a notification with the link to the form? You could prepopulate the form with information. Depending on your specific use case it could also make sense to collect it in the same sheet and then move it to another if you need to.

There are many different ways to set this up.

Would that work?

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

louisebarren

Hi Andree,

Yes I think that would work but not sure how to send them a notification automatically once the event date has passed. Otherwise we might need to send the reminder to one of the administrators to remind them to send the form to the Director to complete once the event has passed. Just can't work out how to automatically send the form for feedback once the event has passed.

Any assistance is greatly appreciated

Thanks Louise

Andrée Starå

Happy to help!

You could set up a notification including the link to the Smart Form that gets sent automatically the day after the event ended.

Event Date (Column with the end date for the event)

Speaker Feedback Date (Column with the formula that sets the date to the next day after the event date)

=[Event Date]@row + 1

The notification would be set to trigger on a specific date, and the date field would be the Speaker Feedback Date. Alert someone would be set to send to contacts in a cell (Speaker)

Would that work?

Best,

Andrée

kagrawa

This is what I'm doing for my own workflow. However, the alert email does not look good to the client ("Speaker", in the above case). Why should they care about the rows and column numbers and internal stuff about Smartsheet? I just want to send a nice email with a link for them to follow...

kagrawa

A URL column in your original sheet can also be sent as one of the shown column values in case you want to custom-generate the URL (e.g. with an ID embedded) (see the "Query Strings" for forms).

Sign in to join the conversation!

Quick Links

Trending discussions

Monthly feedback from multiple individuals
Hello community, I need help figuring out how to set up a sheet to collect monthly comments on several projects. Each project is assigned to a different person who need to provide monthly feedback on its progress. Ideally, I would like them to receive a reminder notification on the report due date, followed by reminders if…
Sheet shows BLANK rows, there is a "MOVE rows" worflow, is that why?
Is it possible that a workflow that MOVES rows to another sheet too basically do a CUT/PASTE (like in Excel), and then you are left with BLANK rows on your original sheet? I cannot think of any other LOGICAL reason why this would happen. The users enter the data from an Intake Form, it gets placed onto this sheet. They do…
Sorting not working?
Hi. I have a sheet where I am sorting dates by ascending order. But the sorting functionality doesn't seem to be working. Instead of bringing all items with date values to the top of the sheeting and sorting them in ascending order, it leaves a gap. Is it a result of the "Next Review Due" column containing a column formula…