Check box to move assigned tasks to completed tasks row

Cody Mattern

I want to have a task that is checked as done moved to the completed task row of the same sheet? How can I create a condition to take this row and move it to the completed row and ideally in order of date completed and as child rows under the completed row?

Andrée Starå

Hi @Cody Mattern

I hope you're well and safe!

Unfortunately, it's not possible now, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

Here's a possible workaround or workarounds

• Workflow to move the row to a so-called helper sheet and then add a workflow to move it from there, and it will be added at the bottom, but not as a child row.

Would that work/help?

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 support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Cody Mattern

I hope you're well and safe!

Unfortunately, it's not possible now, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

Here's a possible workaround or workarounds

• Workflow to move the row to a so-called helper sheet and then add a workflow to move it from there, and it will be added at the bottom, but not as a child row.

Would that work/help?

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 support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Cody Mattern

Andree,

While a little goofy that did do the trick. I created a second sheet for completed tasks to move the row off of my original task list sheet, used the copy row automation to keep a copy of the completed task in my helper sheet, and send it back to my original. As you predicted it appeared at the bottom but not as a child row of my completed tasks row. Well done sir! Many thanks, and I will follow up with Enhanced Request as you mentioned!

Cody

Andrée Starå

@Cody Mattern

Excellent!

You're more than welcome!

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