Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Display column order based on single row's values

54 0
Showing results for 
Search instead for 
Did you mean: 

I have a survey form asking participants of their confidence scores that feeds into a table. Here’s 3 sample questions, all 1-5 score:

  • confidence with financials
  • confidence with communication
  • confidence with strategy

These go into columns B-D. I’d like to then have a way to display, for a single respondent (record), a sorted list view of these 3 columns to show highest to lowest rank.

E.g. someone responds 2, 4, 3 respectively. I’d like to create a table (preferably in Interfaces) that shows:

  1. Communication (4)
  2. Strategy (3)
  3. Financials (2)

Is this possible?

0 Replies 0