Auto-move a row to another sheet when work complete?

Pamela Wagner

Any way to set something up to have a row from one sheet move to another when that task is marked complete? I'd like to have all of my completed items more to a different sheet for archiving purposes.

Andrée Starå

Hi Pamela,

Absolutely.

You’d use an Automation and a Move Row Workflow.

Automatically Move or Copy Rows Between Sheets | Smartsheet Learning Center

https://help.smartsheet.com/articles/2479626-automatically-move-or-copy-rows-between-sheets

With the Move row and Copy row actions, you can automatically move or copy a row to another sheet when conditions

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi Pamela,

Absolutely.

You’d use an Automation and a Move Row Workflow.

Automatically Move or Copy Rows Between Sheets | Smartsheet Learning Center

https://help.smartsheet.com/articles/2479626-automatically-move-or-copy-rows-between-sheets

With the Move row and Copy row actions, you can automatically move or copy a row to another sheet when conditions

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Pamela Wagner

Wow! Perfect and it works!! Thanks!

Andrée Starå

Excellent!

Happy to help!

Cimafranca

This worked for me too.

Follow up question: if I wanted my Destination Sheet to note when the moved column was imported from Source Sheet, how would I do that? I'd like to track when items were completed if possible.

Pamela Wagner

@Cimafranca I believe you should be able to add a column for "Created Date" and that may pull in the date it was moved. You may try that.

Cimafranca

Thanks @Pamela Wagner. I played around with it a bit and found that I could create a new workflow under Automation that records the date created under your suggested column of "Created Date". Thank you!