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?

Leigh Choate
edited 12/09/19 in Archived 2016 Posts

I'm setting up budget docs for several people, and Smartsheet automatically adds lines to every sheet. Unless the budget owner is paying attention, this will screw up one of the formulas. 


Is there any way to turn this feature off? 



  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    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.



  • Shaine Greenwood

    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.


  • b.bennett

    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.

    google sheets add more rows button screenshot

  • Oscar Romero

    auto added rows dont apply the auto formula filling, so this actually its an issue, not a feature request 

This discussion has been closed.