September 29, 2023
I have used your sort order conditional column to help with sorting my data - thanks very helpful.
However, in my data it is putting two of the same values one after the other and I need it in a more custom sort order
I have trainings courses in my list that I want listed under the relevant Overview course for that subject, but I don't know how to automate that. I am attaching what have done already in the Power Query and a screenshot of what I mean.
Is there a way of automating this? The Overview course usually starts with the same name as the general course I require after it, e.g.
Tender Management Overview
Pricing Managment Overview
The other order is working fine. 1-5
October 5, 2010
The Sort_By column is created based on your logic and the contents of the Sorter column. So if you want things sorted differently you need to modify either, or both.
That said, looking at the code for the Sort_By column you have a line that says if the Course Title contains the text "RB" then 6 - but "RB" only appears in the Sorter column.
If you want Tender Management to appear after Tender Management Overview then you need to rewrite your Conditional Column code to assign appropriate Sort_By values for each of these.