Skip to main content
Solved

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

  • August 19, 2023
  • 1 reply
  • 1 view
X

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?

Best answer by Sho

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.

View original
    Did this topic help you find an answer to your question?

    1 reply

    S
    • Sho
    • Inspiring
    • 560 replies
    • Answer
    • August 19, 2023

    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.

    X
    1 person likes this
    • X
      XYZ_James

    Reply


    Most helpful members this week

    Terms & Conditions