Rows' will not permanently delete
Answers
-
For some reason, Smartsheet automatically adds blank rows to the bottom of your sheet. They shouldn't print but if you are experiencing issues, try deleting the bottom rows by selecting the first and last blank row and then right clicking on one of the selected rows and deleting them. Then choose the print icon immediately and you will be able to print the sheet without the blank rows.
You can also select the rows you want to print and choose the print icon and choose Print selected rows.
-
Hi,
I'm experiencing the same thing even though the above issue was reported 4 years ago :-(.
I'm trying to delete 800 line items to start fresh instead started from a blank sheets due to all my formulas and reports have been developed from this sheet.
Can anyone help?
-
There are always at least 10 blank rows at the bottom. Whether or not they are counted can involve many factors.
Are you using formulas that are copied down the columns, or are they set up as column formulas?
It looks like you have cross-sheet formulas from or cell links out to other sheets referencing those blank rows. How are these set up? Direct cell links can cause this to happen.
Are there any hidden locked columns anywhere that may have data?
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Editing to ask: did you clear the data from the rows or did you delete the actual rows? Once you've entered data in a row, it is assigned a Row ID on the backend and your column formulas will always refer to those rows -- you have to delete rows for them to go away. Deleting rows does not delete the column formulas. You can delete every row and if the formula is a column formula, the formulas will remain.
ORIGINAL POST BELOW:
Yeah, @Caravan, it looks like your referencing those row numbers in a formula as Jeff said above. Change your ranges in your formulas to (for example) "[N/A]1:[N/A]791" instead of "[N/A]1:[N/A]801". Better yet, swap the formulas to column formulas instead of static ranges (I.e. instead of using the range "[N/A]1:[N/A]801", use the range "[N/A]:[N/A]"). You have to be an owner or admin of the sheet to create the column formulas. Here's an article on how to use column formulas.
Use column formulas to apply calculations to all rows in a sheet | Smartsheet Learning Center
-
I thought of that but thought there may be an easier way to just delete instead of un-converting the column formula. Thanks a bunch. You guys are awesome!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives