Copy only new rows with automation

Hi, I have an automation set up to copy new rows to a second sheet to run background calculations from. I would like it to just copy the new rows, however when a single new row is added, the entire grid gets re-copied. How can I set this up so it only captures the new rows? I would like this to be dynamic, but I cannot filter by something like "created date is in the past 1 minute".

Automation setup:

Trigger: + When new rows are added

Where Row ID is any value

Copy to ... destination sheet.

Find more posts tagged with

Accepted answers

All comments

ker9

Hi @emey1

I suggest adding a helper column that your automation can use to update. At the end of your copy automation, add and additional item to change a cell value. In your new helper column change the value to "Copied" or whatever makes sense to you (or use a checkbox). Then you can conditionally copy rows that do not have "Copied" or checkbox is not checked in that helper column.

Hope this makes sense and is helpful to you.

Matt Johnson

Hi @emey1

Do you really need the 2nd sheet for the background calculations? A lot of times a metric sheet is used to perform calculations with cross sheet references. That way you maintain the single source of truth for the data driving the metrics.

I hope that helps too.

Matt

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.