Moving completed rows onto an archive sheet automatically?
When a user checks the box "Completed", that row will go away or get moved onto an archive sheet. Is this possible?
Or would I need to manually drag rows (or copy/paste) onto the new sheet?
Best Answer
-
Sure. You can create an automation for this.
Trigger: When a row is changed, when Completed changes to Checked
Action: Move a row (select the sheet to move it to.)
Regards,
Jeff Reisman
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!
Answers
-
Sure. You can create an automation for this.
Trigger: When a row is changed, when Completed changes to Checked
Action: Move a row (select the sheet to move it to.)
Regards,
Jeff Reisman
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!
-
You can set up an automation such as:
You can only move the row to another sheet. Automations cannot delete entire rows.
-
@SmartsheetRookie I am curious to see if this has worked out for you?
I was going to ask the same question, until I spotted yours.
@Jeff Reisman & @Mike TV .. all noted and will test this on Monday - I have a lot a Data to migrate towards an Archive Sheet, and if I can automate this based on several conditions, this would be amazing!
Salèha El D.
Talks about #Smartsheet #productivity, #eventindustry, and #informationtechnology
➖Continuous improvement – for me, an ongoing desire to enhance processes, and increase productivity ➖
-
Yes, you can specify multiple conditions to indicate that a row can be moved. I will generally use a single trigger followed by a condition block with the other criteria; alternatively, I run an archive workflow on a schedule to move all the rows that match the conditions.
I have a series of cascading archive sheets I use to archive our training class sign-in records. It's done by class date, so rows older than 30 days move into a 31-60 day archive, then 61-120, 121-180, 181-240, 241-300, and 301-365. When rows in the final archive sheet reach 366 days old, a formula checks a 'Ready to Delete' check box. I have an automated job from another application that uses the Smartsheet API to collect the row ids for rows that are marked Ready to Delete, and then deletes them from the sheet.
Regards,
Jeff Reisman
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!
-
It has worked out well for me, this has solved my storage/capacity conundrum.
Thanks for the tips re-cascading archive sheets - very insightful!
Salèha El D.
Talks about #Smartsheet #productivity, #eventindustry, and #informationtechnology
➖Continuous improvement – for me, an ongoing desire to enhance processes, and increase productivity ➖
-
Hi Saléha,
Ciruous, what do you mean with storage/capacity conundrum?
You mean actual storage-size in smartsheet?
Continuous Improvement Facilitator in HVAC industry || Timezone CES
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
