Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
I need to collect data that I need to duplicate 10-15 times. Is it possible to use web forms to collect the information and have it move to seperate rows as the customer fills in on one web form? Is there an efficient way to do this without creating 30-40 extra columns?
Jamie, can you explain it a bit more of what you are needing, or if you have an image of what you are looking to accomplish that may be helpful.
Not exactly - a web form can only be used to add data to a single row. You could build multiple web forms and set the "Submit" button to reload the web form or load a new web form. For example, the first web form contains questions 1-10, when they submit the web form, a second web form loads, which contains questions 5-15.
Thanks for the responses Joel and Travis. I'll proceed accordingly.
Hi Jamie,
One strategy I've used for repeating data and building custom reports is to use create additional hidden columns with formulas. The formulas will auto-populate the cells based on the initial web form data entry. Then the reports can pull from the additional columns based on your criteria.
Here is more formula info: http://help.smartsheet.com/customer/en/portal/articles/775363-using-formulas
Hope that helps!
