Automatically move rows?

J Johnson

Is it possible to have rows move automatically from one sheet to another (to make room on the first sheet) when they are over 8 days old? I am doing it manually right now, and that means I have to do it every few days. 

Andrée Starå

Hi,

Yes, it is. I'll get back to the post a little later.

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Mike Wilday

You can read about the new Automation action Move Row here: 

• https://app.smartsheet.com/b/publish?EQBCT=97f25854d81445b98891c8b8b9d1c8dc&_ga=2.33526906.535684056.1570462938-61535698.1548289777

Paul Newcome

You can create another date column we will call [Move Date] for this example. I am also going to assume you are using a Created Date type column to track when it is actually created.

 

In the [Move Date] column, enter something along the lines of

 

=DATEONLY([Created Date]@row) + 8

 

Then when you set up your automation, you can set it up to run on a specific date column. Set that column as the [Move Date] column, and you should be good to go.

Andrée Starå

Happy to help!

I saw that Paul/Mike answered already!

Let me know if I can help with anything else!

Best,

Andrée