11 new rows always pop up even after deleted

Options

hi all

anyone have similiar problems?

these empty rows keep appeared even after deletion. i havent create any automation

and the properties also cannot be seen


Best Answer

  • Jenn Hilber
    Jenn Hilber Overachievers Alumni
    Answer ✓
    Options

    @andri witana 

    You will always have several rows at the bottom to make it easier to enter new data from the sheet.

    I like to use an Auto-Number column that assigns a Sequence Number to rows that have data. If there is a row that data was entered into then deleted, the Sequence Number would be assigned automatically. You can also use conditional formatting where Seq Number is NOT blank, and other rows ARE blank color the row gray. The gray rows would then be deleted to remove the cell history.

    I hope that makes sense.


    Jenn Hilber

    Smartsheet Overachievers Alumni

    https://www.linkedin.com/in/jennhilber/

Answers

  • Jenn Hilber
    Jenn Hilber Overachievers Alumni
    Answer ✓
    Options

    @andri witana 

    You will always have several rows at the bottom to make it easier to enter new data from the sheet.

    I like to use an Auto-Number column that assigns a Sequence Number to rows that have data. If there is a row that data was entered into then deleted, the Sequence Number would be assigned automatically. You can also use conditional formatting where Seq Number is NOT blank, and other rows ARE blank color the row gray. The gray rows would then be deleted to remove the cell history.

    I hope that makes sense.


    Jenn Hilber

    Smartsheet Overachievers Alumni

    https://www.linkedin.com/in/jennhilber/