Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
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.
We have 2 licenses. The HR make changes and I complete the process. She added 16 new staff members on our sheet but I do not see the entries from my side.
I want to setup automation for a distribution email list. This distribution email list should be tied to each form request. Do I have to add it to the form or can I add it, somehow, to the responses sheet.
Hello, I have a question about what I'm calling an errant alert. Here is the automation Trigger: When {{XYZ date}} changes to anything + Condition - {{Status}} = Phase 1 - In Progress + Alert someone, send to contacts in a cell = {{AA Assigned}} + Alert someone, sent to contacts in a cell = {{RE Assigned}} The automation…
