Can i copy a row one time when criteria is met or will this happen constantly?

Brandon Morales

Hi im trying to automate my works sheet so that when criteria is met, a row is copied to another sheet automatically… my concern is that when that criteria is met, i will get numerous duplicate copies- is that correct? Is there a work around?

Lindsay AR

If you are wanting the row to copy only once when the criteria is met, you can accomplish this by adding conditions. For ease of knowing which rows have met the criteria you can use a helper column that updates when the criteria is met. You can go this through an automation or through a formula. If you do it through a formula, you can use this helper column as your trigger.

Brandon Morales

that make sense- what would the helper column look like? Would it update with a date? What kind of formula would give me that?

Lindsay AR

Without knowing the criteria being met it's vague, but could be something like this:

Helper column with formula:

When Column1 is updated check box in ColumnB (formula could be something like =IF(ISBLANK(Column1), 0,1) The formula would go in check box ColumnB.

Automation:

Put your criteria in the automation and once the row is copied have a helper column update. This could be a box that is checked, a status that is updated, or a date being captured. You would make that as a condition. The layout would be something like: