List all but

[HCF]

I try to list all items except those completed and then I try to sort the items in a Ref field using the Valid If:
OrderBy(

SELECT(Tasks[Title], ([Phase]<>“Complete”)),

[Is Part Of],
True,
[Title],
False
)
But it doesn’t work. what am I doing wrong?

[Steve]

Generate a list of all then remove those that are complete.

help.appsheet.com

List Subtraction

Subtract lists to produce another containing only the unique items of the first list that aren't also in the second.

[HCF]

Thanks, but the Select statement works and filters the data needed. The OrderBy() function however, does not produce an output “ORDERBY has invalid inputs” I do not understand why.

[Steve]

Good luck.

[HCF]

Sorry, I don’t understand your response

[HCF · Accepted solution]

I figured and ended up with:

ORDERBY(

FILTER(
“Tasks”,
([Phase] <> “Complete”)),

IsBlank([Is Part Of]),
False,
IsBlank([MotherID]),
False,

[Title]

)