Unable to set-up Copy Rows Workflow, because of system generate columns

Hi,

I wanted to create a workflow, that copies a data to other sheet (destination sheet) whenever a new row is added in source sheet. However, I do have some system generated columns like Added By, Date added, Updated By, Updated Date. The destination sheet was also formatted and designed as a same way as source sheet. I have even tried renaming the system generated columns differently in destination sheet. Can someone please help me with this?

Thanks,

Mounika

Find more posts tagged with

Accepted answers

John_Foster

Hi @Mounika,

I had a similar problem, to get around it, I created a blank sheet and created the automation to copy the rows across to it. Once copied I then amended the rows in the destination sheet as required.

Hope this helps.

John

All comments

John_Foster

Hi @Mounika,

I had a similar problem, to get around it, I created a blank sheet and created the automation to copy the rows across to it. Once copied I then amended the rows in the destination sheet as required.

Hope this helps.

John

Mounika

@John_Foster

Thank you so much! That helped :).

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.