I have a view where Status field is the categorized field. The status values are "Planning", "Confirmed", "Completed", and "Cancelled".
This is what the view looks like on the web page. It is a collapsed view.
143 > Completed
35 > Cancelled
The user can then expand to see the various documents.
Problem I have is that a user wants to expand Confirmed in the view and see the Confrimed sorted by Start Date.
Then when they expand "PLanning", they want to see the Planning sorted by ID#. And Completed is sorted by Start Date...Cancelled sorted by ID#. I suggested them going to separate views to get the type of sorts they prefer, but they like the collapsing format showing the totals.
The columns in the view has the following design:
Column 1 is a total where "1" is entered in the formula
Column 2 has the following sorted in ascending order so I can organize the statuses to appear in the correct order:
@If(AI_Status ="Confirmed"; 1;
AI_Status = "Planning" | AI_Status="On-Hold" | AI_Status="On-Hold/Funding" | AI_Status="Planning/Urgent";2;
AI_Status = "Completed";5;
Column 3 has the Status field (sorted in ascending order)
The rest of the columns don't have any settings for sorting.
Is it possible to have a situation in a web browser where a user selects the confirmed status and that will expand and sort by date...then when selecting the other status...it sorts by ID#....Is this even possible in one view? I'm wondering. If it is not possible and I ask all the experts..I will then have proof it is not possible...Someone please answer my question.