Sign in to join the conversation:
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?
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
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.
Thank you for the replies, I will give the form a try.
How can I delete old sheets I no longer use from my account?
I'm trying to display a task progress chart showing "complete", "late", and "not complete" in my dashboard and for some reason the chart will display as a column chart but it won't display as a donut chart even though I'm referencing the same report. I'd prefer to display as a donut chart as I think it looks better and is…
Hello, I am trying to create a chart widget in my dashboard, but I keep getting "Selected data cannot be charted. Please select a new range." error. The report I am using is already summarized in numeric value. What is funny is I have report that I created a chart widget in another dashboard, and when I use that same…
