We want to move completed tasks within a given hierarchy to the bottom of the list allowing active tasks to "move up"
Ideas?
This has to be a manual process, select the task or tasks and drag and drop, Bear in mind if you sort the columns then they will get mixed in again.
If you have two Hierarchies: Active tasks & Completed Tasks this makes it clear. Alternativly you can archive the completed tasks into another sheet.
