Min function doesn't work with lookup fields?

Ask the community Formulas
#1

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

#2

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.

#3

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

MIN (values)

1 Like
#4

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?

1 Like
#5

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.

1 Like
#6

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.

1 Like
#7

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.