Help

Min function doesn't work with lookup fields?

Topic Labels: Formulas
1187 5
cancel
Showing results for 
Search instead for 
Did you mean: 
Onur
6 - Interface Innovator
6 - Interface Innovator

Hi,
I am experiencing unexpected behavior.

Is this expected behavior that MIN function in formulas doesn’t work with lookup fields that contain numbers (in the same format)?

Would be great if I someone can check & maybe I am getting this wrong?
Thanks in advance

5 Replies 5
augmented
10 - Mercury
10 - Mercury

I would check the formatting on the lookup field and make sure it’s one of the first four. If not, the lookup thinks your number is a string (probably). I just tried using MIN with a lookup (currency original field) and it worked fine.

Instead of creating a lookup field + formula field, create a rollup field that points to the number field and use this formula:

MIN (values)

What if he doesn’t want the min of all the values, but the min between the number in each record and some constant that’s important to him?

Not sure… that’s a little trickier since Airtable handles arrays relatively strangely. I think people have solved that problem before in other threads. I think it involves some combination of the ARRAY functions.

I also recommend using a rollup field instead of a lookup. Rollup formulas can include references to other fields in the same table as the rollup.