Smartsheet Keeps adding blank rows in between or rows

Soumitra Bhowmick

Any Idea why Smartsheet keeps adding blank rows in between of rows? Data is getting added to the Smartsheet via forms and not manually. Number of blank rows also varies from 1 to 8 for my case. Tried deleting all blank rows be it in between or at the bottom by selecting the row then, right click and selecting Delete option but it keep coming back.

Andrée Starå

@Soumitra Bhowmick

Excellent!

Glad you figured out the issue!

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Soumitra Bhowmick

I hope you're well and safe!

Smartsheet automatically always adds ten empty/not activated rows at the bottom.

Try deleting all other empty rows except the last ten rows, and it should work.

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Soumitra Bhowmick

I have already done that several times but these blank rows keep coming between other rows.

Andrée Starå

@Soumitra Bhowmick

Can you share a screenshot?

Soumitra Bhowmick

Any specific this you want me to Include the ScreenShot?

Andrée Starå

@Soumitra Bhowmick

No, I just need to see how it looks and see if I can figure out why.

Soumitra Bhowmick

Snap1.JPG

Snap2.JPG

Snap1 is of the blank lines which are marked in Red between 2 rows where we had data.

1 Interesting fact is that, when I right click on any of the cells of the blank rows to check cell History, the option is disabled (Refer Snap2).

Andrée Starå

@Soumitra Bhowmick

Thanks! Can you share a screenshot of the sheet?

Yes, the blank rows aren't activated, so they don't have any history.

JSanita

Any solution to this? I am continually struggling with this myself. I have hundreds of blank rows for no reason.

JSanita

Actually, I have 172 rows with content, and 14,225 row because of the blank row that are added. It's now affecting other sheets where I have calculations referencing this sheet because there are too many rows!

Soumitra Bhowmick

To all,

As per Smartsheet support team, blank rows are added by an user whether intentional or accidental. So the only way to deal with it is to select the rows, right click and select option Delete to delete them permanently. That's what I am doing since I don't have any other options left.

Andrée Starå

@Soumitra Bhowmick

Excellent!

Glad you figured out the issue!

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!