Separating Form Submissions into new sheet

clyons
clyons
edited 12/09/19 in Smartsheet Basics

Hi everyone! I made the mistake of creating two forms in one sheet. They two distinct links and are for different events. The issue is that I cant separate the responses based on the sheets. Is there anyway to fix this? I need an accurate tally for an event.

 

Thanks!

Comments

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    One way of handling this moving forward is to add a dropdown column to the sheet with options for each form / event. Then on the form itself, you can designate an answer to the dropdown column that automatically sends the event with the form submission. You can then hide that field so that its not visible on the form. And you can set the default answer to whichever relates to the form.