Forum Discussion
SORTBY newb... Other solutions don't appear to apply??
SortBy() takes the source range, sort it based on another array and put result into new place in the same or another sheet. That's practically no limit on the size of the source range.
If to sort in place that could be done programmatically (VBA, OfficeScript) or manually by Data -> Sort. Here you may sort by helper column which map Urgent, High, etc on numerical order of which (e.g. using XLOOKUP); or here you may sort by color if that's more suitable.
So, depends on goals, do you need to sort in place or copy sorted data into another place.
Thank you for your reply, Sergei!
In this instance, I am trying to sort in place as opposed to pushing the data to another place. I had hoped that SortBy could accomplish this in place, but the examples (and your information here) shows me that it can't.
I just want the sheet sorted by dropdown selection in place and I want it to do it dynamically, rather than using the filter sort manually.
Afraid that's VBA or Office if sort with button. If fully dynamically - VBA, but it's not clear what will be the trigger. Plus you won't have the control to sort or not to sort at this very moment.