The Airtable Community will undergo scheduled maintenance on September 17 from 10:00 PM PST to 11:15 PM PST. During this period, you may experience temporary disruptions. We apologize for any inconvenience and appreciate your understanding.
I need help in creating rankings of products based on its quantity.
We have a table with 3 fields.
Name of Fruit, Quantity, Ranking.
We want to rank the Fruits as 1,2,3,4... based on the quantity of that fruit. Whenever the quantity of any fruit changes, the Ranking should update itself.