Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 09, 2024 09:45 AM
Dear 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
Sep 09, 2024 12:14 PM
Hello @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)))
👍
Sep 09, 2024 08:36 PM
Think 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!