Changing order in First/Last sort OR getting airtable to sort the same as excel does

[XYZ_James]

Hello

I imported a excel doc where I prioritize items based on a 1-4 scale for sorting. I also use "Z" to sort items to the bottom that no longer need a priority. 

After I imported to airtable, its only letting me sort my priority column "First - Last" or "Last - First" which I am not familiar with. So i changed the "z" items to "999" thinking airtable might only recognize numbers. Didn't help. The "1" priority is still not sorting to the top.

In short, I get that airtable wont sort as if it was a spreadsheet but i need to know how to label my prioities so they sort.

Right now, I am using 

• 1 - Ultra High
• 2 - High
• 3 - Medium
• 4 - Low
• 999 - Unavailable or Screened

Help?

[Sho · Accepted solution]

You are using single select fields, right?
Single select fields are determined by the order of the field settings, not the value.
Drag and drop the red circles to adjust the order.
So you don't need a numerical value.

If you have numerical values, you can press the Alphabetize button on the right for automatic sorting.