It would be great to be able to reverse the order of a sorting by a Workflow field on a per view basis.
My use case is for listing Tasks and grouping by State. I have states like Backlog, Todo, Blocked, In Progress, Done and Won’t Do. Sometimes I want the default order, but in some cases it would be nice to be able reverse the order.
Example: Filter out the Done and Won’t do states and then reverse the order so that In Progress Tasks show at the top instead of the Backlog items showing at the top.
I could not find an option to do this and the Fibery AI told me it was not a feature yet, so starting this topic to put it on the agenda.
Note: Sorting the State by type does not really do the trick when having multiple states within each type because the sorting inside of the type stays constant even if the sorting direction by type changes.
As a workaround, you can add a value field (number) to your workflow, and then manually set these (from 1 - 6) to match the rank order. Then you can use this as a sort option in any views
Open any entity, and alt click on the name of the workflow state option. This opens entity view for that option, and here you can add a new field.
You can show this field on a data view where the state field is being used and thus edit the values for each option.
Once you’ve set the values, you never really need to use it again except for the sorting purpose
It would be very nice if it was built in and automatically changed if the state order is changed or new states are added. I got it working, but having it built in is more robust and less to maintain (at least for the users, not the devs )
)