Using a Form to input a row into a grid
I created a Form to enter a new row of data into a grid type sheet. The form setup was straightforward and worked fine except when it input the new row into the grid, it left a blank line between the last row and the new row created by the form. I tried it again and this time it left several blank lines between the bottom row and the new row. Am I doing something wrong?
Best Answers
-
Some times when making changes to a sheet, writing formulas does it a lot, it will look like a row is blank but it is not. Then a form or a move/copy row will add rows with blank rows above them. To fix this, simply highlight the first empty row and then shift-select the final row at the bottom of the sheet. Then delete them all. Then when you refresh the sheet it will add about 10 blank rows at the bottom.
That should stop the blank rows you're getting. At least until you do something that accidentally adds blank rows again like writing another formula without deleting the row you wrote it in.
-
Got it - Thank you!
Answers
-
Some times when making changes to a sheet, writing formulas does it a lot, it will look like a row is blank but it is not. Then a form or a move/copy row will add rows with blank rows above them. To fix this, simply highlight the first empty row and then shift-select the final row at the bottom of the sheet. Then delete them all. Then when you refresh the sheet it will add about 10 blank rows at the bottom.
That should stop the blank rows you're getting. At least until you do something that accidentally adds blank rows again like writing another formula without deleting the row you wrote it in.
-
Got it - Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 143 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!