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

Script to rank records that updates according to filter

175 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi all,

Hoping someone can help me with this,

I have a table with a list of brands and a score for each brand. The brands are labelled by category, some brands have multiple categories. I want to be able to automatically rank these brands by their score, and have that rank update if I filter.

E.g if I filtered to just 'makeup' the rank would update to only rank the brands categorised as makeup.

Included an example table that's simplified,

Hoping this is possible!

Thanks in advance,

Charlie

1 Reply 1

What sort of value do you want in that "Rank" column? If you filter *and then sort on the score*, Airtable's automatic row numbering will give you a kind of ranking, no? Airtable doesn't have a dynamic RowNumber() function that updates when you change the filters.