Move row automation based on age of start date

Amanda Bevilacqua

Hi there -

I'm looking to set up an automation to archive rows to a new sheet where the date is 200+ days in the past. Currently I've archived everything greater than 06/30/2020. I'd like to get this set up so I do not have to update the automation every few months & am blanking on the correct parameter.

Which condition parameter should I use to set archiving rows where the start date is 200+ days in the past?

Screen Shot 2020-12-09 at 2.43.11 PM.png

Mark Cronk

HI @Amanda Bevilacqua ,

I think the easiest solution is to add another date column to your sheet titled "Archive Date". The formula would be =[start date]@row+200. You can do it as a column formula. Then set up your automation to run daily or weekly and move any row where the archive date is in the past.

Work?

Mark

Mark Cronk

HI @Amanda Bevilacqua ,

I think the easiest solution is to add another date column to your sheet titled "Archive Date". The formula would be =[start date]@row+200. You can do it as a column formula. Then set up your automation to run daily or weekly and move any row where the archive date is in the past.

Work?

Mark

Amanda Bevilacqua

@Mark Cronk - Thank you!!! The archive date column is the step I couldn't remember yesterday 😁

Mark Cronk

Happy to help. Thanks for using the Community.

Mark