Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Ranking of Products based on the Quantity

Topic Labels: Automations Formulas
287 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Msgems_Dmcc
4 - Data Explorer
4 - Data Explorer

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

2 Replies 2

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)))

👍

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!