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

Document filtered by form responses
I've created a Smartsheets form. When someone submits the form, I want them to automatically be emailed a document that has resources and links, but the document is filtered to only show the content that corresponds with what they selected in the form. Is something like this possible? What types of documents or automations…
Form stopped working after upgrade
I have a sheet that I created in a previous version, and it had a form. I was recently upgraded to a newer version and now my form is not working. I created a new form for the sheet, and it is giving me an error also. Does anyone know what I can do to fix this? The error says Form Unavailable. Sorry, the form you're trying…
Getting Error About Emulated Environments
Hi, I have read the post from 8/21/25. I am still getting the same error. I am setting up a new device and just download the latest version as of 9/5/25. I am using a Eunivon Smart White Board for touchscreen capability. It is running Android 14. Any help would be appreciated.