Sorting question


I have the following number format in a column:


I need to sort the column from low-high based on the last 6 didgets 001935. Is this possible?




You’ll have to make another field - perhaps call it “Sort By” - and make it a formula field with this in it:
RIGHT({name of number field}, 6)

That will pull only the last 6 digits out in the “Sort By” field, and then you can hide that field, but still use it to sort by.


Thank you Jeremy. I will give it a try.