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:
- Communication (4)
- Strategy (3)
- Financials (2)
Is this possible?