Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

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

Solved
Jump to Solution
875 0
cancel
Showing results for 
Search instead for 
Did you mean: 
XYZ_James
4 - Data Explorer
4 - Data Explorer

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?

1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

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.

2023-08-19 104138.png

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

See Solution in Thread

1 Reply 1
Sho
11 - Venus
11 - Venus

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.

2023-08-19 104138.png

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