Automatic blank top row

Sean_H

Hello,

Currently when I type into the last row of a sheet it adds a new blank row on the bottom of the sheet.  Is there a way to basically reverse this so that the row is constantly added to the top of the sheet?

Mike Wilday

No that's not possible in Smartsheet. However, if you are using a form to input your data, you can have that form input into a new row the top of your sheet. 

See here for more information: https://help.smartsheet.com/articles/522221-collect-information-form

DanS

I'm thinking a workaround will be to sort the sheet based on a column whose type is auto-number, then sort descending on that column.

So even when a new row is entered at the bottom, when you sort the auto-number column in descending order, it will appear on top.

Sadly, the sort setting isn't persistent, so every time you add a new row, you will need to sort again.

Sean_H

Thank you for the replies, I will give the form a try.