Display column order based on single row's values

209 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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