How to copy automatically copy a row to the top of a sheet?
Hi, I just created a sheet that has an automated workflow that copies a row when a box is checked.
The problem is that my destination sheet is otherwise populated by a form that adds news rows at the top. When my automation copies a row it goes to the bottom- any way to change this?
Answers
-
That's a great idea! Unfortunately the copy a row automation only copies the row at the bottom of the sheet.
Leroy Noriega | Smartsheet SME | Independent Smartsheet Consultant
Core App, Project Management and System Administrator Certified🏅
E: leroy.noriega@yahoo.com | Linkedin Profile
-
Wow, really? that's pretty rediculous.
Follow up question, I created a filter that shows all of my rows that have the cell in the status column as blank and a few other criteria. Why are there a number of blank rows between my copied rows and the rows added by the form?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!