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
Hi everyone, I'm the owner of worksheet/workspace and am currently unable to reliably remove user access through the "Manage Access" panel. This issue just started occurring recently. The Problem: When I click the "X" next to a user's name to remove them, it works for the first user. For any subsequent user, the "X"…
I'm trying to move data from two grids (Grid #1 and Grid #2) using workflows (When rows are changed) to archive grids when a cell is ONLY updated on Grid #1. Here is my setup and what the issue I'm having… Grid #1 has the column that is being updated. Workflow setup on Grid #1 to move the row when the cell is changed to a…
Helloe Everyone! I’m trying to reference another sheet in Smartsheet, but I’ve noticed that sometimes it loads quickly, while other times it takes a very long time to display the list. Does anyone know why this happens? Is there a way to reduce how often this issue occurs? Today, I can’t get anything to load at all. 😑
