Separate form submissions from reference data

cbeleno

I've imported a CSV File into Smartsheet that serves as my database repository for Form Fields. My Form is created on this sheet in order to reference data values within the grid for multi-select form responses, which are limited to the values provided.

I would like for form submissions to land on a separate sheet as my database repository will need to be refreshed each month (we will be adding values). Is using Smartsheet automation to move fields every time a new row is added the best method, or are there any other methods that can be used or recommended?

Much appreciated!

Andrée Starå

Hi @cbeleno

I hope you're well and safe!

• I'd recommend adding the form to another sheet and then moving/copying the row(s) to the other sheet.

Make sense?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!