Automating Status of "Completed"

Melita Clark

I want to be able to have all tasks with a status of "completed" moved to the bottom of my parent section. I don't want to move to another sheet, but instead to the bottom of the parent. Is there a way to do this? Formula / Automation?

Thanks in advance! -mc

Debbie Sawyer

You could get this functionality if you view your sheet through a Grouping and Summarising report.

To achieve this you could create a couple of helper columns in the sheet - they can be hidden:

One called ParentName with the formula of =PARENT([Task Name]@row)

then another column with a number associated with the order of Status that you want to use. StatusNumber =IF([Status]@row="Not Started",1,IF([Status]@row= "In Progress",2,3))

Then in the report group by ParentName and it would also sort by ParentName, but you could add a second Sort by StatusNumber in ascending order.

This would give you what you want, but not directly in the sheet. You can still update % complete and Comments etc from a report.

Hope this helps...

Kind regards

Debbie