Move row automation based on age of start date

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?


Best Answer

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer ✓

    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.



    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.