Sorting question


#1

I have the following number format in a column:

270417-001935

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

Thanks,

Nathalie


#2

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.


#3

Thank you Jeremy. I will give it a try.