Copy New Row, Delete Old Row

I have a quick question. I have a process by which a row gets copied (from Sheet A) into another sheet (Sheet B). Since there will be duplicate rows in Sheet A, I'm wondering if there is a way in which when the row gets copied into Sheet B, a row can be deleted if another already exists?

Essentially, I'm looking to avoid having duplicate rows so I can always see the most up to date one (because it'll have the most up to date attachments/comments).

Find more posts tagged with

functionality

Automations

Accepted answers

All comments

Mark Cronk

Hi Mike,

In your sheet B you'll create a duplicate helper column to flag the older duplicate record. Then you'll use automation to move the duplicate row to another sheet - the trash can.

You'll need to identify the data elements that identify the duplicate. Then there are several community posts on identifying duplicates. Let me know if you need more assistance.

Mark

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.