Sign in to join the conversation:
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.
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
You can read about the new Automation action Move Row here:
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.
Happy to help!
I saw that Paul/Mike answered already!
Let me know if I can help with anything else!
Andrée
@Paul Newcome , Hope you are well. Question for you, meant to ask quite some time ago but forgot. You had shared this right after Engage 2025. I'm unfamiliar with the view and how to create it. Can you tell me about this view?
I am trying to change owner on a Smartsheet sheet to the owner of the workspace it is located in. I keep getting an error message stating the permissions need to be managed at the workspace level. I am unable to change owner for the sheet at the workspace level. Not sure how to accomplish this change. HELP!
I would like to add two dynamic filters as a widget within my Dashboard to define a date range (start and end date) which would then return a count value to that same Dashboard. I have been searching for answers but am not coming up with the solution I'm looking for. What is the cleanest way to configure this?
