How to move lines so that they are together after filtered
Hello! I created an automation so that all the rows other than rows with column X's value = Y. Now, all the lines are apart from each other because a lot of the rows have been deleted in between. Is there a command line or something in automation that brings all these rows together so that they are right below each other?
Hope I'm making sense - thanks in advance
Answers
-
If you sort (by any way you want) after deleting rows in the middle, the empty rows will fall off because they'll be punted to the bottom of the list.
Disable the filter (you can't sort with a filter on), right-click on a column header, and click Sort rows.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 351 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 443 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 36 Webinars
- 7.3K Forum Archives