This is interesting. You actually want to filter on a relation on the object that your object is related to. I was wandering about that too.
I was thinking maybe if you create a set of projects and filter the set on relation status (only ‘soon’ or ‘in progress’) maybe you can use that set as a filter in the task set.
But I can’t get it to work, alas…