Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

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

Topic Labels: Formulas
210 0
cancel
Showing results for 
Search instead for 
Did you mean: 

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