+1Dear Sir,
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.
Any help will be appreciated.
Thank you
Navin
+23Hello @Msgems_Dmcc ,
Create a formula field for Rank.
use this formula and change the value accordingly.
IF({Qty} >= 400, 1,
IF({Qty} >= 300, 2,
IF({Qty} >= 200, 3,
4)))👍
+31Think you'll need to look into an automation with a script for this, or if you want an out of the box solution you can try this out: https://airtable.com/marketplace/blkJYKH72q2NLBLZE/auto-ranker
(Disclaimer: I built this)
I created a workflow where you can trigger it with an automation too, so it'll keep your data ranked automatically!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.