Automation: Copy Row to Another Sheet
With automation, I am able to copy rows from one sheet to another based on certain criteria. When this happens, the rows are added to the bottom of the destination sheet. Is it possible to place the rows in a certain place within the document, without manually moving?
The goal is to copy 4-5 tasks that need to repeat several times within the sheet, but need to be placed under the correct parent.
Answers
-
That would be awesome but no, it cannot be done. It's a pretty major limitation of the parent/child hierarchy. We encounter this problem in other areas, for example, a form where we want an entry to be added into a specified hierarchy.
When we face this problem we just flatten everything out and put the hierarchy information in columns.
If Smartsheet ever fixes this in these use-cases, we will come back the same day and ask them to do Data Shuttle now (let me shuttle data into specific hierarchies)
-
Thanks @James Keuning. I love and hate Smartsheet at the same time. 😁
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives