Forms
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?
Best Answer
-
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.
Answers
-
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.
-
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.
-
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.
-
OK. the "Save as new" method worked. Thanks.
-
