Hi, is it possible with an automation or set up a formula to move a row to another sheet after it three months old? I have a date column, but I can't find a way to move it by date.
If you're using the system column "Created" for your start date, add a date column:
=Created@row + 90
Alternatively, just use this formula to add 90 days to whatever date field you are using.
That will set the date field to 90 days after it was created, roughly 3 months old.
Then create your automation rule:
Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
I created this automation saying if the form date field is not within the next 90 days to remove older rows, but it removes everything. What do I have set wrong in the condition? Thanks
Another way is to set the trigger if you set the automation to run when 90 days is reached:
Change your Condition to:
Where Form Date is not the LAST (days)
and then add another condition
Where Form Date is not in the future.
This way the Form Date must be in the past, and it must be older than 90 days, in order to be Moved.
Cool! I didn't even know that was built-in. Thanks!
I'm learning new things every day too :)
Oh I get it now.... Thank you so much
I'm wondering if there is a way to lock rows 1-12 out of the sorting and filtering of a sheet. I might have take out that part of the from otherwise I dont like how the built in dashboard moves when a sort or filter is applied?
Hello, I apologize if this has already been answered, I did search before asking. I recently downloaded a template and it had the google slides displayed in presentation mode. I cannot figure out how to do this as when I embed, it's just the entire google page where you can edit and see the menu bar. How do I embed the…
I'm working on a compensation request form that follows these steps: An HR Business Partner completes the Compensation Request Smartsheet Form that then triggers an alert to our Compensation Manager. Our Compensation Manager will insert the requested information. The HR Business Partner will be alerted when the…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.