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
Is anyone a SmartSheets pro that could get on a call with me for no longer than an hour and go over some basics (to you I'm sure) on how this system works? My Launch10 package was used mostly to set up my first sheet and I never had the time to actually learn how to use the system. I have automations set up but there are…
Hi all! I just noticed the new "Filter" feature on dashboards, but I cannot find any resources for additional support yet. So far I can only get it to connect to report widgets — does anyone know if you are able to use this filter feature with chart widgets? Use case: I have a line graph that shows various class offerings…
I am wanting to share content that has a default filter applied where it only pulls specific rows (leveraging "Current User") filter. Originally, I had tried leveraging a report, however, that does not allow the user to be able to add rows and self assign (unless experiencing user-error). Having a report is my preferred…
