Filters & unexpected row creation / drag and drop behavior
I'd like to use a filter to hide all completed tasks from my sheet, but when I do this, I find that adding rows or dragging and dropping rows results in unexpected destinations. Sometimes the added or moved row ends up with the wrong row number, or disappears entirely because it ended up nested beneath a row hidden by the filter (really weird).
Is there any way to make this behavior more reliable? I'd like to keep this particular filter condition on basically all the time, but right now I have to turn the filter off every time I need to add or move a row, to ensure the row ends up where I expect.
Also worth noting - I don't want to automatically move rows around based on completion, because then I lose their original context. I want to keep them where they are, but just not see them unless I choose to turn the filter off.