Question about sorting

Scott Houle

Hi, i'm looking for some suggestions on an issue that I am seeing related to sorting in one of my Smartsheets. 

I have a sheet that has a row with instructions to the users as the first row. I have a checkbox column that is only checked off in the instruction row, and I use a sort to keep this at the top of the sheet. 

My issue is that when data is added to this sheet (via the API) it goes to the top of the sheet, above my instruction row. Users can also move rows manually above this instruction row, and the sort i've applied does not change this back. Today I have to keep manually moving the instructions back to the top of the sheet. 

Is there a way that my preferred sort can be made permanent, so that I can keep this instruction row at the top of my sheet? Or, is there another way to go about keeping this row at the top? 

Mike Wilday

One thing you can do is add this data to the api call so it forces new rows to the bottom and stops messing up your instruction row!  

http://smartsheet-platform.github.io/smartsheet-java-sdk/com/smartsheet/api/models/Row.AddRowBuilder.html#getToBottom--

Otherwise, there is no way to default sort your data on load.