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, pleaseVisit the Current Forums.
Is it possible to duplicate columns in Web Forms?
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?
Comments
-
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.
-
Travis EmployeeNot 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.
-
Alina Anderson EmployeeHi 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!
Categories
=IF(OR([Current Quarter]@row = \"Q1\", [Current Quarter]@row = \"Q2\"), \"S\" + RIGHT([Current Year]@row, 2), \"F\" + RIGHT([Current Year]@row, 2))<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":279,"urlcode":"marketing","name":"Marketing"},{"tagID":281,"urlcode":"support","name":"Support"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}]},{"discussionID":111714,"type":"question","name":"How do I ensure links to reports and cells persist when copying a folder of artifacts for a project","excerpt":"Hi, I have a folder of artifacts that I was using as an 'artifact tree' for new projects my team manages. The folder includes all the sheets, reports and dashboards that a project manager would need to set up a new project from scratch. The Dashboard w\/in the folder is linked to various sheets and reports w\/in the folder.…","snippet":"Hi, I have a folder of artifacts that I was using as an 'artifact tree' for new projects my team manages. The folder includes all the sheets, reports and dashboards that a project…","categoryID":321,"dateInserted":"2023-10-16T16:39:58+00:00","dateUpdated":"2023-10-16T17:12:10+00:00","dateLastComment":"2023-10-16T19:41:45+00:00","insertUserID":130047,"insertUser":{"userID":130047,"name":"Alex Hackford","url":"https:\/\/community.smartsheet.com\/profile\/Alex%20Hackford","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!m_jVn4tpYLQ!zh1V8wNL1sQ!ziK_jPs8qoT","dateLastActive":"2023-10-16T19:41:16+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":161936,"lastUserID":130047,"lastUser":{"userID":130047,"name":"Alex Hackford","url":"https:\/\/community.smartsheet.com\/profile\/Alex%20Hackford","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!m_jVn4tpYLQ!zh1V8wNL1sQ!ziK_jPs8qoT","dateLastActive":"2023-10-16T19:41:16+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":22,"score":null,"hot":3394960903,"url":"https:\/\/community.smartsheet.com\/discussion\/111714\/how-do-i-ensure-links-to-reports-and-cells-persist-when-copying-a-folder-of-artifacts-for-a-project","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/111714\/how-do-i-ensure-links-to-reports-and-cells-persist-when-copying-a-folder-of-artifacts-for-a-project","format":"Rich","lastPost":{"discussionID":111714,"commentID":400223,"name":"Re: How do I ensure links to reports and cells persist when copying a folder of artifacts for a project","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/400223#Comment_400223","dateInserted":"2023-10-16T19:41:45+00:00","insertUserID":130047,"insertUser":{"userID":130047,"name":"Alex Hackford","url":"https:\/\/community.smartsheet.com\/profile\/Alex%20Hackford","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!m_jVn4tpYLQ!zh1V8wNL1sQ!ziK_jPs8qoT","dateLastActive":"2023-10-16T19:41:16+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-10-16T19:41:30+00:00","dateAnswered":"2023-10-16T17:03:28+00:00","acceptedAnswers":[{"commentID":400171,"body":"
![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/IJYSDKANJGGY\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
