I recently created a sheet and form for patient safety surveys. When the form is completed, data is populated starting on row 51. What did I do wrong and how can I get it to populate starting at row 1?
Delete all rows. You activated a row at the bottom of the sheet by typing something in them, and smartsheet found this as the lowest activated row.
(to delete rows, right click on the gray box on the far left (past the attachments ect). There should be an option to delete the row. You can hold control to select multiple individually, or hold shift and click the bottom and top rows to highlight a range. Once they are deleted the first row will be the target for the next form submission.
Alternatively, you could also potentially direct the form to send to the top of the sheet instead of the bottom in the form options. This may mess with some formulas/references depending on how the sheet was formatted.
Hi all. I am new to Smartsheet and I am building my first form. Is there a way to set up a form to show additional fields that will only appear after it is submitted? These new fields will be filled out by someone other than the person who submitted the form. They will be viewing this in the card view. Thanks for any help!
Looking to connect a dynamic view of HR dataset to a Power BI dashboard pulling information from multiple other sources. Appreciate any guidance, thanks
Hello! I copied a form I had made for a similar event I am working on now. I made minor adjustments to the form to match the needs of the event. I distributed the form for people to complete, so the form is active, but the data is not populating onto my Smartsheet. Please advise. I would prefer not to have people redo the…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.