We keep a list of Completed tasks. Based on the date in the Work_Ended column, I would like to autmomatically move rows > 90 days old onto another sheet, which we'll call Completed Archive.
Is there any way to automate this process?
Thank you!
I don't think it is possible to move rows from sheet to sheet automatically.
Though, you could use conditionnal formatting to color a row when it is 90 days old to help you locate old rows. This way, you can move them yourself without having to look carefully around the sheet.
If you don't want to remove them from your task list but only want to have a place where you see old data, I suggest building a report.
Hope that helps!
Étienne Desbiens
Étienne,
Thank you for the thoughtful reply.
I believe you may be able to do this using an add on app called Zapier. Here is their link - https://zapier.com/app/explore
As Stephanie mentions, it is possible and quite easy to set up in Zapier.
Craig
