The best way to do this is as follows.
Especially if you filter by other inputs or dropdowns.
- Create two states in the group for the order and and field name. ie “Order” type yes/no, “Field Name” type text.
- Sort by the the option “Change Which Field…” and link it to a state in the group ie “Field Name”
- Make the yes/no des ascending option linked to a state in the group.
- Then in column header create a workflow that changes the Order yes no by getting its current option format as text make the yes no and the no yes then set it to is “yes” this will toggle it when clicked. ie yes = no is yes = no, no = yes is yes = yes.
- Then set the field to name of the column you are clicking.
Done