Help

Need a formula to return a value from multiple records based on two variables

Topic Labels: Formulas
609 2
cancel
Showing results for 
Search instead for 
Did you mean: 
kjhbjkljn5gfqrk
4 - Data Explorer
4 - Data Explorer

Hi,

I have a base where we I need to return the lowest value possible value for items that share a unique identifier (this is generated for each record and only some overlap) AND the same quantity. For example, say I had 4 records that generated their identifier to 101A, with quantities of 200, 300, 400, 500. For All of these records, I need a field that returns the minimum quantity (200) for each record with that matching ID ; and will work with possibly thousands of unique identifiers. 

I thought this would be an easy formula, but cannot seem to make this function whatsoever. 

2 Replies 2
Kenneth_Raghuna
7 - App Architect
7 - App Architect

I am a little confused about this wording: 


@kjhbjkljn5gfqrk wrote:

 

... for items that share a unique identifier (this is generated for each record and only some overlap) AND the same quantity. 

None of the items you gave in the example have the same quantity.

If I ignore that part, you can do this by linking all records with the same identifier, and using a rollup column that looks like this:
Source: Column with the linked records

Field You Want to Roll Up: Quantity

Aggregation Formula: MIN(values)

Arthur_Tutt
8 - Airtable Astronomer
8 - Airtable Astronomer

Hey @kjhbjkljn5gfqrk can you share some screenshots of your current tables and fields? Seeing a visual example will help me to better understand what you're looking for. Thanks!