Add an option when using automation to move/copy a row to add the row to the top of the sheet.
Sign in to see the current vote count, add your own vote, or leave a comment.
Currently, when I have an automation which moves or copies a row from one sheet to another, the row is copied into the new sheet completely at random instead of populating at the top of the sheet. For example, I created a blank sheet, and set an automation to copy certain test questions from the master sheet. The automation placed the sheet starting at row 20 - completely random. It took me a while to even realize the automation had worked since I had to scroll down to find the copied rows.
It seems that, although there is a great deal of feedback to implement this fix, there is little being done to actually fix the problem.
I create solutions for my clients using Smartsheet and the fact that this does not function correctly reflects poorly on Smartsheet. I avoid using this functionality because of this fact. This is one of those things that makes me refer to it as "Dumbsheet."
I need this ability to move rows to the top of the sheet via automation (or even better data shuttle). I have linking to other sheets that need to take the information from the top rows to work properly.
Would be great that when moving a ROW to another Smartsheet, that you could actually select where it gets placed, specifically at the TOP of the sheet where it is moved. Manually sorting the list is not a big deal, but would be great if that step could be eliminated!
This option would he helpful for what my team has created. We have a primary sheet that is the intake sheet for vehicle maintenance and requests, that sheet has a copy row automation to go to an individual vehicle tracker so that we can track additional information about the vehicles. I would like the new rows that get copied into the individual vehicle sheets to go on top so that the team can see the new entry easily and be able to move it to where they need it.
I've seen that this has been an issue since 2022. The fact that it has been nearly 3 years since then and this issue still hasn't been resolved is a huge let down. :( At the very least, the automation should follow the rules of the recipient sheet (I.E if a sheet populates new rows at the top, then the automation should do the same or if a sheet populates at the bottom, then it should do that). Having the option to change whether a row is added to the top or the bottom but not being able to for an automation seems like an oversight. Granted, I am super content that I am able to copy a row over at all, but its not useful if it disrupts the current workflow of an existing sheet. Edit: I just realized that the last time the status was updated was in 2023. 😥
We really need this basic feature added! I want my rows to copy to the top of the other sheet and not have to spend time doing it manually!
This would be an excellent improvement, please consider implementing it.
I have been very happy with Smartsheet up until now. We have quite a few row automations, and the feature to add the row to top of the sheet instead of the bottom has been being asked for since 2022. Can we please change where the row gets added? Even if the default is the top of the sheet, that would be way better than 5 rows below the bottom of the sheet.
I have an option in the Form that gathers data into the Source Sheet to add to Top or Bottom. When I try to Automate moving Rows from Source to Target Sheet the Default is Bottom. Can we have this option in Move Row Automation or change the Default so that a Moved Row goes to the top of Target Sheet?
When using automation to copy a line from one sheet to another, it would be GREAT if when the new line is added to the new sheet it is added to the top of the sheet.
Yes agreed, top of sheet would be preferred.
I really need this feature it helps know what is needed to be worked on in the group. Please provide an update on this feature
I would really like to see this functionality as well. It is one of the biggest complaints I hear. The automation that moves rows between sheets is great, but when you have to scroll to the end of some very long sheets to find the newest additions, it loses some of its functionality.
We have sheets set up for projects, and have active tasks at the top of the sheet, and then when tasks are marked as complete, they move to a Completed, nested row at the bottom of the sheet. We have an automation set up for new tasks to populate on that particular sheet, and since our Completed section is at the bottom, new tasks that haven't even been started populate at the bottom and it looks like they are Completed. Is there a way we could have an option to populate new rows at the top of the sheet? Thanks!
Hi, I hope you're well and safe! Have you explored using the new Table View, which allows you to sort the data? Would that work/help? I hope that helps! Be safe, and have a fantastic day! Best,Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD ✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer! I appreciate it, thank you! 🙏
Hi, I was creating new dashboard and thought it'll be so nice to have easy drag and drop Report widget capability from Workspace Panel since I always group set of reports under one folder (for ease of finding them what goes on the dashboard). I think this would be great time saver especially if you have similar name…
In the Resource Management Plan Settings in Control Center, there is no way to link the Client and Project Code fields even though they are not Custom fields and part of the first 3 fields you enter when creating a new project. I can't select them in the Custom Resource Management Information Fields because they are not…
Since the license model has changed, the option to Share should default to VIEW, not EDIT. The View option allows less-experienced users to share that way by default, and share as Edit only when needed. This allows for less cleanup during true-up. This also prevents users from adding provisional licenses unknowingly.
