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.
I have provided a dynamic view for my users to see content on-screen. However, I've been asked to provide a print option as well. Normally, I would export a report to PDF for 'clean' printing [that is, preserves layout and colours with pretty explanatory note in header]. However, I don't want my users to have access to the…
Hi, Does anyone know if there is a way to send an alert if the value in a cell changes by more than a certain percentage? So, if I have 100 in a cell (text/number) and the value changes by over 5%, I'd like to be able to send an alert. Thanks, Vince
I'm sure this is super simple but myself and a colleague could not figure it out. I have some very simple data I need graphed for a project: Not Started, In Progress, Complete and then % Complete using the total. The pie chart for the Not Started etc. comes out correct: But when I ask it to graph just % complete, it does…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.