Smartsheet Keeps adding blank rows in between or rows
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.
Best Answer
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
I have already done that several times but these blank rows keep coming between other rows.
-
Can you share a screenshot?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Any specific this you want me to Include the ScreenShot?
-
No, I just need to see how it looks and see if I can figure out why.
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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).
-
Thanks! Can you share a screenshot of the sheet?
Yes, the blank rows aren't activated, so they don't have any history.
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Any solution to this? I am continually struggling with this myself. I have hundreds of blank rows for no reason.
-
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!
-
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.
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives