I've got two cases where I've run into a similar issue:
- I have an column that displays HTML, and I want to sort by the HTML text, not the HTML url
- I have a column that displays an approximate number to two significant digits in a readable format (1.1k, 36, 910k, 190), but I want to be able to sort it numerically
In both cases, the "Mapped value" feature doesn't do what I want.
In the first case, I could have the unmapped value be the string, the mapped value be the HTML, and sort by unmapped value... but then where do I get the URL from to make the mapped value?
In the second case, it almost works to have the "approximater" be the mapping, and sort by unmapped value... but because I want to set the property type to "text," it appears to apply that to both the mapped and unmapped value.
What I feel like I want is one of two things:
- Either "secretly sort this column as if it was this other, hidden, column"
- An ability to map one way for sorting, and another way for display, and possibly with those two having different types.
Is there a workaround that other people have found?