Let's always use Done to close an activity, even a cancelled one. Let's add a Cancelled flag to easily filter out cancellation.

It could be nicer to set a true/false flag in the Deleted column (renaming it as Cancelled) while using the Done column for marking a finished (either way) activity.

The actual issue is that having empty cells in intermediate states (when putting some activity in Cancelled/*Done* state) disallows sorting by column states and dates (Done, In-Progress, Next, Deadline, Backlog, ID) so all other charts have to be either reviewed or created dynamically with macros and the like.