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
I am attempted to export to excel. I have two different smartsheet documents to export. One of them exported to excel fine, but not the other. This happened a few weeks ago. I make sure all columns were the correct size & no cells were hidden. "We have found a problem with (file) Do you want us to try and recover as much…
Hello Smartsheet Community, I need some help with a report that I created and shared with a customer. The customer is not seeing any of the information that is pulling into the report. See screen shot below that the customer texted me. I do have the report filter only showing the customer their product pulling from our…
BLUF: When I create an Invoice, I need the cell-link to my live price data to be severed. I currently have a Price sheet for my products that is updated frequently. I use Control Center to create Projects, which includes an Invoice sheet. I have a dropdown on my invoice sheet to select a product, and then I use Index…
