Forms

mpatton

I created two different forms and the data entered on both of them is saved in the same sheet. How do I get it to save on two separate sheets?

Paul Newcome

You would create the sheet first, then you can click on "Forms" in the top right corner of the new sheet to create the form.

If you need a bunch of the same columns, You can "Save as new" the existing sheet and then just delete whatever you don't need from each sheet.

Paul Newcome

You would need to either use a Move Row automation to send one over to another sheet, or recreate the second form in the other sheet.

mpatton

I'm new to smartsheet. Can you explain how to create a new form in a new sheet? I just used Create, Form to create mine.

Paul Newcome

You would create the sheet first, then you can click on "Forms" in the top right corner of the new sheet to create the form.

If you need a bunch of the same columns, You can "Save as new" the existing sheet and then just delete whatever you don't need from each sheet.

mpatton

OK. the "Save as new" method worked. Thanks.

Paul Newcome

Happy to help. 👍️