Can we moved the entire row details in same sheet via automation or any other way ?
I have a Smartsheet with all my projects, and it includes a column for project status with 5 phases. When the status of a project changes, the entire row of details needs to move to the appropriate locked section. For example, when the project status changes from "In Progress" to "Finished," the entire row of details should move below the locked "Finished" row.
Answers
-
Rearranging rows in one sheet isn't really something that I'm aware is part of the design. You could conceivably have five sheets with individual phases and use a Move Row automation to relocate the rows based on status - though that gets less-than-scalable rather quickly, because you then have to create multiple automations on each sheet. So the other suggestion might be to use a report to consume the data on your sheet - which you can set up to group by Status. It's also possible to create sheet filters to include only the data required.
If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 143 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!