Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Date Driven row roll off
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!
Comments
-
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
