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.

Find more posts tagged with

Automations

Accepted answers

All comments

James Keuning

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)

DoraExplorer

Thanks @James Keuning. I love and hate Smartsheet at the same time. 😁

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.