Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Any way to stop lines from being automatically added?
Comments
-
Why does a new line screw up your formulas?
Smartsheet will add a small number of rows to ensure you have somewhere to add rows when you need them.
Craig
-
Hi Leigh—there isn't a way to prevent blank rows from being automatically added at the bottom of the sheet but I'll add your vote for this to our enhancement request list for further consideration.
The Community may be able to offer advice on how to avoid your formulas from being added if you can provide more information on the formulas and your process.
-
It doesn't mess up formulas for me, but it does still run the risk of causing issues.
We issue Job Numbers to construction projects and start a new sheet every 100 numbers. If someone doesn't know (or slips up) and adds information on a sheet instead of jumping to the new one, we can have a disconnect.
I understand the reasoning behind the rows auto-add, but I hate that it's not something you can opt out of (and it just looks bad on some of my sheets).
What about just having a button at the bottom like Google Sheets? You can type in a quantity of desired new rows and click the "Add" button and voila.
-
auto added rows dont apply the auto formula filling, so this actually its an issue, not a feature request
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