Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Create Multiple sheets from template

edited 12/09/19 in Archived 2015 Posts



I am new user and was wondering if anyone can help. I have created a template which has questions users have to answer. I need to send this out to 100s of users and will need to do this annually. Is there a way to use the template to create multiple sheets which can be assigned to multiple users. I need each person to have their own sheet so they do not overwrite other peoples answers. Also is there a way to automated it to create the same sheets every year?




  • Stephanie Taylor
    Stephanie Taylor ✭✭✭✭✭✭

    Depending on what membership level you are you may not be able to create hundreds of Smartsheets.  You could instead set up one Smartsheet and then create a webform for that sheet to send to the users.  Once the webform is submitted their answers will be populated into one Smartsheet. 

  • I have the enterprise version. i should be able to create that many. I tried using the webform and it seems i will have to add each question as a seperate column

  • JohnHinkle
    JohnHinkle ✭✭✭✭✭✭

    I agree the best way would be to use a web form. Yes, each question will require a new column, but once it is set up, no further action is required. You can use the same sheet and send the same web form out each year. If you create a sheet for the hundreds of users, then you have to keep track of all of those. To see each response, you will need to open up hundreds of sheets which can take a lot of time. You would also need to share the hundreds of sheets with the users so they have access. That alone will take quite a bit of time. 

  • Agreed - webform is the way to go, I have used this for simlar things in the past

  • Thanks

    few more questions

    On the form is there a way to save the form in the middle and come back to it?

    Is there a way to add attachment in more than one place. It seems if i add the attachment option once to a question i can not add an attachment to other questions

  • Stephanie Taylor
    Stephanie Taylor ✭✭✭✭✭✭

    Yes you can save the form in the middle and come back to it.  As for adding attachments if you are adding attachments while in a sheet then you can add multiple attachments to each row by clicking on the paper clip icon to the left of the row.   

  • I was looking at the web form and i dont see anywhere to save and come back later. How do i add the feature


    For attachment i was looking to add attachements in different parts of the web form


  • Stephanie Taylor
    Stephanie Taylor ✭✭✭✭✭✭

    og I see what you are talking about. If you are actually filling out the webform then no you can not save and come back. I was thinking you were in editing mode. 

This discussion has been closed.