How to show column headers in 1 column based on the values in those columns for each record?

Topic Labels: Formulas
471 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi all,

We have a table with records per customer, with multiple variables and their scores coming from typeform (auto-sync).

The goal is to get out the 3 highest scoring variables and send the label of those variables to the customer. I can’t seem to find a way to get inside 3 fields the 3 column-names with the highest value of that record.

Another solution I was thinking of, was when the auto-sync worked, to store the variables in different rows in another table but also with this I see no reason than to get the max 3 variables out of this table linked to the original one.

Help would be much appreciated, thanks!

0 Replies 0