Automation to copy row at specific dates

noshiro

I have a sheet that I would like to automatically copy rows (with triggers) on specific dates. Does this mean I need to create an automation for each date?

Paul Newcome

If you can make a list of every date, you can use a formula to grab the correct date and put it into a column and leverage that in an automation. Granted, creating and maintaining the list is a manual process, but at least you only have one place you have to put each date one time. Then you would use

=MIN(COLLECT({Date Sheet Date Column}, {Date Sheet Date Column}, @cell >= TODAY()))

Then you would set up an automation to run daily with a condition of this helper column being equal to today.

Or is it different dates for different rows?

Paul Newcome

It depends. Is there logic driving the dates, or is there no pattern to it?

noshiro

@Paul Newcome yes there seems to be no logic, as every last friday or every second day. Its the end of fiscal months, and then the Tuesday after the end of fiscal month.

Paul Newcome

If you can make a list of every date, you can use a formula to grab the correct date and put it into a column and leverage that in an automation. Granted, creating and maintaining the list is a manual process, but at least you only have one place you have to put each date one time. Then you would use

=MIN(COLLECT({Date Sheet Date Column}, {Date Sheet Date Column}, @cell >= TODAY()))

Then you would set up an automation to run daily with a condition of this helper column being equal to today.

Or is it different dates for different rows?

noshiro

@Paul Newcome thank you! I think that would work! Thank you for your help! have a great day!

Paul Newcome

Happy to help. 👍️