Multiple Forms, One Smartsheet

AllieB · 06/08/23

I created two identical forms (except for the name) and both of them populated into the same smartsheet. Is there a way to only see one form's submissions?

Peggy Parchert · 06/08/23

@AllieB

Yes - in your sheet, add a Created date column.

-Peggy

Peggy Parchert · 06/08/23

@AllieB

Hello! You could create a helper column that has the form name as a dropdown list.

Then in each form, add that column but hide it from view with the default option being the name of the form.

Then in your sheet, you could create filters using the helper column and form name.

Hope this helps.

Thanks -Peggy

Nick Korna · 06/08/23

Add a dropdown column with 2 values (for example A & B).

On your forms, add this column but make it hidden with the default value corresponding value selected. When the form is submitted, then you will have this value for all submissions from that form and can use this as your filter value.

AllieB · 06/08/23

Will this work if the submissions have already come in?

Peggy Parchert · 06/08/23

@AllieB

Existing entries would have to be manually updated for the new column. Once you add the column to the sheet and to each form with the default set, it will populate on submission.

Peggy

AllieB · 06/08/23

Is there a way to see the date/time of each submission?

Peggy Parchert · 06/08/23

@AllieB

Yes - in your sheet, add a Created date column.

-Peggy

AllieB · 06/08/23

Thank you, this helps!!

Peggy Parchert · 06/08/23

Thank you, this helps!!<\/p>","bodyRaw":"[{\"insert\":\"Thank you, this helps!!\\n\"}]","format":"rich","dateInserted":"2023-06-08T13:46:23+00:00","insertUser":{"userID":152102,"name":"AllieB","url":"https:\/\/community.smartsheet.com\/profile\/AllieB","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-08T13:49:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379549#Comment_379549","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/379549#Comment_379549

Happy to help - have a great day!

-Peggy

Multiple Forms, One Smartsheet

Best Answer

Answers

Categories