Would it be possible to copy rows to another sheet on a specific day of the week

badams

If I was to use an =today() in a column to grab the current date and then a condition using the IF(WEEKDAY(Date@Row) = 1, and make an automation for say, every Monday (1), could I copy a row (or rows) to another sheet when that day condition gets triggered? I will try this as I think it should work…..but I am fairly new so that leads to my….

Second Question: If I automate data row copy to another sheet every Monday will the data overwrite or add to the existing Monday sheet the next week? I want to capture updates to existing rows each week so overwriting with new data would be ideal.

Paul Newcome

You wouldn't need a formula at all. You can set it for every Monday directly in the trigger.

It will add new rows, but you can use a formula on the second sheet to flag the most recent row(s) and use a report or filter to display only those.

EDIT: Forgot to include screenshot of setting up the weekly on Mondays trigger…

Paul Newcome

You wouldn't need a formula at all. You can set it for every Monday directly in the trigger.

It will add new rows, but you can use a formula on the second sheet to flag the most recent row(s) and use a report or filter to display only those.

EDIT: Forgot to include screenshot of setting up the weekly on Mondays trigger…