Copy rows workflow

Dheeraj Goyal

Hi,

I want to copy rows from one sheet to another weekly. But I only want newly created rows that were created past week to copy over and not all rows. I am also locking rows in the same workflow. Is there any possible solution?

Thanks,

Dheeraj

Paul Newcome

You would need to insert a Created Date system generated column and then a checkbox column with a formula along the lines of

=IF(Created@row>= TODAY(-7), 1)

This should check the box in any row created in the past 7 days. Then you would set up your copy row automation to run weekly with a condition where the box is checked.