Using a Form to input a row into a grid

Options

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

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Answer ✓
    Options

    @Chadd

    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.

  • Chadd
    Chadd ✭✭
    Answer ✓
    Options

    Got it - Thank you!

Answers

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Answer ✓
    Options

    @Chadd

    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.

  • Chadd
    Chadd ✭✭
    Answer ✓
    Options

    Got it - Thank you!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!