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?
Solved! Go to Solution.
I figured and ended up with:
ORDERBY(
FILTER(
“Tasks”,
([Phase] <> “Complete”)),
IsBlank([Is Part Of]),
False,
IsBlank([MotherID]),
False,
[Title]
)
Generate a list of all then remove those that are complete.
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.
Good luck.
Sorry, I don’t understand your response
I figured and ended up with:
ORDERBY(
FILTER(
“Tasks”,
([Phase] <> “Complete”)),
IsBlank([Is Part Of]),
False,
IsBlank([MotherID]),
False,
[Title]
)
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |