Skip to main content

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

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.


Reply